Hi there,
Im trying to figure a way to pull out a report that shows me the most active users on a given time range (month, week, year, etc). I’d like to get this report on a csv.
Is there a way to get this data? When I export the user report via csv it only gives me the data for those who signed up within the time range selected, but what I want to see is the most active within that time instead.
Thanks!
Best answer by Alistair FIeld
UPDATE:
You can export user data via Analytics → Export. There, you can create an all time User export which will produce a CSV file where you can see, profile information, number of topics, replies, last activity etc.
Hey
Our Post export would help you understanding who is creating the most topics/replies on the community in a given time range. However, it doesn’t contain likes or visits.
Hey
I guess what Im looking for is that the CSV and full picture version of the leaderboard? Is there a report to find the most active users based on number of posts, likes, answers, etc? This would be the most useful report of all as far as I’m concerned.
+1
There’s a fiddly (but it does the job) workaround to export this from user dashboard
I need this on a CSV so I can separate users in bands and craft my own rewards system, but I need a comprehensive doc of all users and their actions per month. So unfortunately the user dashboard is not in the right format for me.
I’ll check that out
+2There’s a fiddly (but it does the job) workaround to export this from user dashboard
Oops couldn't access that thread.
Unfortunately… It seems no-one can access that post anymore. It appears to have been flagged for moderation and has since been moved to an evidence locker.
On the plus side, it appears that the post still exists, so it might be possible for someone to salvage the info you’re after.
Looks like something’s gone wrong with the link, but the idea is still available here:
Please note though that the workaround mentioned there should not be necessary anymore ?
+4UPDATE:
You can export user data via Analytics → Export. There, you can create an all time User export which will produce a CSV file where you can see, profile information, number of topics, replies, last activity etc.
+4was the date filter the same between analytics and the export?
+4ok, I think I understand now.
You need to do a POST export and then pivot table on username to get your active users.
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
