Skip to main content
Gabolino
Helper ⭐️
Mar 1, 2021 4:34 PM UTC
Solved

Top Monthly Members report

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!

Alistair FIeld
Expert ⭐️
Feb 14, 2023 10:58 AM UTC

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.

The needs of the many, outweigh the needs of the few. 🖖

13 replies

daniel.boon
Helper ⭐️⭐️⭐️
Mar 2, 2021 12:42 PM UTC

Hey @Gabolino - what activity are you considering for your active users reporting? 

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.

Translate
inSided product alumnus
Gabolino
GabolinoAuthor
Helper ⭐️
Mar 8, 2021 11:34 AM UTC

Hey @daniel.boon , thanks for that, I checked it out but since it’s post-led as opposed to user-led it doesn’t really help me I think. 

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. 

Translate
Kgastaldo
Helper ⭐️⭐️⭐️
Mar 8, 2021 11:37 PM UTC

@Gabolino  - Is the info you need in the User dashboard? You can sort those by posts, likes, answers, etc. You’d basically just need an export of that dashboard?

Translate
m4rc
Helper ⭐️
Mar 9, 2021 9:08 AM UTC

There’s a fiddly (but it does the job) workaround to export this from user dashboard @Gabolino 

Check out this thread :slight_smile:

Translate
Gabolino
GabolinoAuthor
Helper ⭐️
Mar 9, 2021 9:49 AM UTC

@Gabolino  - Is the info you need in the User dashboard? You can sort those by posts, likes, answers, etc. You’d basically just need an export of that 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 @m4rc !

Translate
anirbandutta
Expert ⭐️
Jan 21, 2022 1:01 PM UTC

There’s a fiddly (but it does the job) workaround to export this from user dashboard @Gabolino 

Check out this thread :slight_smile:

Oops couldn't access that thread. @Marion Frecaut could you enable me pl?

Translate
It's an opportunity for engagement
Blastoise186
Helper ⭐️⭐️⭐️
Jan 21, 2022 1:11 PM UTC

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.

Translate
Bug blasting absolutely everything... The Blastoise Way
alex.timmermann
Gainsight Employee ⭐️
Gainsight Employee ⭐️
Jan 21, 2022 1:46 PM UTC

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 ?

Translate
Alistair FIeld
Expert ⭐️
Feb 14, 2023 10:58 AM UTC

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.

Translate
The needs of the many, outweigh the needs of the few. 🖖
esthertrapadoux
Contributor ⭐️⭐️
Apr 20, 2023 1:35 PM UTC

@Alistair FIeld I tried this but there are people who show up as “Top users” in analytics but are not in the csv export.

Translate