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

Alistair FIeld
Expert ⭐️
April 20, 2023

@esthertrapadoux 

was the date filter the same between analytics and the export?

The needs of the many, outweigh the needs of the few. 🖖
esthertrapadoux
Contributor ⭐️⭐️
April 20, 2023

@Alistair FIeld Yes. This person that I spot checked for is our most active community member, too. So it’s strange he’s not on there.

Alistair FIeld
Expert ⭐️
April 21, 2023

ok, I think I understand now.

@esthertrapadoux as noted in the original topic, the user report is who registered in the date range selected for the report. NOT the activity per user within that range.

You need to do a POST export and then pivot table on username to get your active users.

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