Skip to main content
Gabolino
Helper ⭐️
March 1, 2021
Solved

Top Monthly Members report

  • March 1, 2021
  • 13 replies
  • 214 views

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.

13 replies

daniel.boon
Helper ⭐️⭐️⭐️
March 2, 2021

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.

inSided product alumnus
Gabolino
GabolinoAuthor
Helper ⭐️
March 8, 2021

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. 

Kgastaldo
Helper ⭐️⭐️⭐️
March 8, 2021

@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?

m4rc
Helper ⭐️
March 9, 2021

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

Check out this thread :slight_smile:

Gabolino
GabolinoAuthor
Helper ⭐️
March 9, 2021

@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 !

anirbandutta
Expert ⭐️
January 21, 2022

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?

It's an opportunity for engagement
Blastoise186
Helper ⭐️⭐️⭐️
January 21, 2022

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.

Bug blasting absolutely everything... The Blastoise Way
alex.timmermann
Gainsight Employee ⭐️
Gainsight Employee ⭐️
January 21, 2022

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 ?

Alistair FIeld
Expert ⭐️
February 14, 2023

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. 🖖
esthertrapadoux
Contributor ⭐️⭐️
April 20, 2023

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