Skip to main content
Gabolino
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
    Alistair FIeldAnswer
    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. 🖖
    View in thread

    13 replies

    Show previous replies
    Alistair FIeld
    Alistair FIeld
    Expert ⭐️
    Apr 20, 2023 1:49 PM UTC

    @esthertrapadoux 

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

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

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

    Translate
    Alistair FIeld
    Alistair FIeld
    Expert ⭐️
    Apr 21, 2023 9:00 AM UTC

    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.

    Translate
    The needs of the many, outweigh the needs of the few. 🖖
      Terms & ConditionsAccessibility statement