Skip to main content

API Group output versus Audiences

  • April 30, 2024
  • 5 replies
  • 275 views

dwilburn
Guide III
Forum|alt.badge.img+4

I have a python script that pulls the groups in the system and exports it to CSV. The output has group user counts and I use this for cleaning up groups that have zero users, and for other documentation.

With the move to audiences and the deprecation of groups, the same pull from audiences only gives info about the group provisioning, not the user count.

To pull the user count I need to know the codes for all of my 600 plus groups, iterate on each group and then do the calculations to get the count.

This is significantly more effort to get the basic information that Docebo should be giving us in a report.

Has anyone else found a solution for this? Or reporting on groups in general?

5 replies

captainzelda
Helper II
Forum|alt.badge.img

We have over 4500 groups. I’d kill for a group report! 


dwilburn
Guide III
Forum|alt.badge.img+4
  • Author
  • Guide III
  • April 30, 2024

I can show you how to get it with groups...<shrug> 😂


dwilburn
Guide III
Forum|alt.badge.img+4
  • Author
  • Guide III
  • April 30, 2024

@captainzelda If I figure anything out I will let you know.


trose23
Helper III
Forum|alt.badge.img+3
  • Helper III
  • April 30, 2024

I wonder if since the member count is part of what you need if you can essentially either rig the Groups/Branches - Courses report to give you some of this information.

My two thoughts were:

  1. Run a report on all your courses with this, then create a pivot table or remove duplicate data to isolate your group names and member counts to give you most of the data.  Then you could potentially compare that to a master list of groups to see if any groups were missing/didn’t show on the report and may have no users.
  2. Would need testing and I’m not sure if it would actually work.  Maybe create a “dummy” course and enroll a “dummy group test” user into that course, then make sure that user is manually added to all groups.  Then the groups/branches - course report might show all the groups and their counts from that user being enrolled in them, and you would know that all the counts were minus the one test user/if the group only had one user then it was the test user?  I have no idea if this would be successful, but it may be worth testing. 

dwilburn
Guide III
Forum|alt.badge.img+4
  • Author
  • Guide III
  • April 30, 2024

@trose23 - I considered that, but having played with all of the groups and branches that show up in the survey reporting I went a different direction. I am playing with postman again going through bfarkas sessions. He does a good job of setting it up. 

I am going to work with that and our internal cognitive AI to see if I can figure it out.

My old groups Python script is still working. I just do not know how long it will work. So I want to have a plan.

I will work on getting a pull from audiences, and then I can do the calculations in Excel as needed. Hopefully.

I also want to be able to create groups based on specific content in a CSV (one parameter, everything else hard coded).