Hello,
I’m looking for a definitive recommendation of the right way to pull a report of my top internal employees’ user activity for the year within my community. The out-of-the-box options that Gainsight provides seem close, but not all the way there - would be eager to know if I’m missing some obvious filtering that would help me!
What I’m looking for:
- A list of community users from within my company who have been active in the community in the last year. I can determine this list either by email address (containing our company domain) or by custom role (which all employees are labeled with).
- Ideally, the users would be identified by email address too, and not only by username.
- How much they contributed to the community - essentially, the number of posts they’ve made - within a specified time frame.
The options I’ve considered and where they’re not meeting my needs:
- The user CSV export within analytics. This doesn’t work because it only includes users who registered for the community within my specified time frame and excludes those who registered before.
- The user dashboard in analytics. I am able to filter by user role and date, which is good, but I’ve been told previously by Gainsight that these dashboards are best for more informal, at-a-glance reporting and are not definitively accurate. Also not exportable.
- Users overview in Control. I can easily filter down to employees, it contains clear tallies of posts, and includes emails, but there isn't a way to specify timeframe for post creation. Also not exportable.
- Content overview in Control. I can easily specify content creation date, but can’t filter author by role or email, only username. Also not exportable.
So far, the best option seems to be the “post” CSV export within analytics. This would require me filtering down by the author rank that I need, then tallying the posts for each individual author. It includes username only per author, and not email, so I suppose I’d have to pull in user email from a separate table by matching.
I can do this, or prepare a report externally with my own analytics via API, if it really is necessary, but this seems like a straightforward request that should be more possible OOTB. Am I missing anything?
