Skip to main content
Kautuksahni
Contributor ⭐️⭐️
Jan 29, 2026 1:00 PM UTC
Solved

How to Identify Top Users by Replies for a Specific Community Category?

Hi team,

I’m exploring Analytics exports to see if my regular Community Manager use cases can be handled through the Gainsight Analytics dashboard and data export. There’s one use case I haven’t been able to figure out yet, despite checking available resources:

I’m trying to identify top users by replies (Count) for a specific solution or community category within a given date range. This data will help us analyze the performance of our MVPs (Custom Roles and Ranks) relative to each other and also recognize and reward top contributors on a monthly or quarterly basis for each solution.

If anyone knows how to achieve this, I’d really appreciate your guidance.

Thanks in advance!

    DannyPancratz
    DannyPancratzAnswer
    VIP ⭐️⭐️⭐️⭐️⭐️
    Jan 29, 2026 1:51 PM UTC

    They haven’t announced it yet, but it looks like they’ve improved the analytics Exports slightly. Yesterday, I exported the Post report to test it out and one column listed if it was a Topic (question/conversation) or reply. 

    You should be able to do a one time export of that and filter by category, date, etc to get what you need. 

    The trickier part would be ongoing processes, if those are needed. 

    FYI: I am no longer active in this community
    View in thread

    7 replies

    DannyPancratz
    DannyPancratzAnswer
    VIP ⭐️⭐️⭐️⭐️⭐️
    Jan 29, 2026 1:51 PM UTC

    They haven’t announced it yet, but it looks like they’ve improved the analytics Exports slightly. Yesterday, I exported the Post report to test it out and one column listed if it was a Topic (question/conversation) or reply. 

    You should be able to do a one time export of that and filter by category, date, etc to get what you need. 

    The trickier part would be ongoing processes, if those are needed. 

    Translate
    FYI: I am no longer active in this community
      mitchell.gordon
      mitchell.gordon
      Expert ⭐️
      Jan 29, 2026 2:29 PM UTC

      From what I was able to find in the analytics dashboard, Im not sure this is possible. 

      -en.insided.com/analyticsV2/dashboard/user would be the spot as it needs to be per user. There isnt a possibility to drill down to content location inside of this reporting metric.

      Translate
        mitchell.gordon
        mitchell.gordon
        Expert ⭐️
        Jan 29, 2026 2:32 PM UTC

        Using the API this should be possible I should note. You could build a Snowflake (or other data tool) dashboard with the API data and drill down but it would require additional resources in your org.

        Translate
          Alistair FIeld
          Alistair FIeld
          Expert ⭐️
          Jan 29, 2026 3:04 PM UTC

          ​@Kautuksahni in the POSTS export it includes both the original post and all replies. 

          There is a data point- time_since_previous_post.

          In the original post this value is zero. So any “POST” that has a time value is a reply.

           

          One thing that would take some working out would be to ignore responses from the original poster. 

           

          Translate
          The needs of the many, outweigh the needs of the few. 🖖
            samanthahamlet
            samanthahamlet
            Gainsight Community Manager
            Jan 30, 2026 8:38 AM UTC

            Some great suggestions here 🙌
            Linking in these articles for more info! 

             

             

            Translate
              Alistair FIeld
              Alistair FIeld
              Expert ⭐️
              Feb 3, 2026 5:21 PM UTC

              In fact I just noticed the POST Type as a new field in the latest POST download.

               

              Translate
              The needs of the many, outweigh the needs of the few. 🖖
                KautuksahniAuthor
                Contributor ⭐️⭐️
                Feb 4, 2026 10:54 AM UTC

                Thanks everyone for the helpful suggestions — really appreciate it! 

                Based on your inputs, it looks like the Posts Export (Exports V2) is the most practical way forward right now. Using the new POST Type or time_since_previous_post  field to distinguish replies, then filtering by category and date range and aggregating replies per user externally (e.g., via a pivot table) should cover this use case well for one-time or periodic analysis.

                Thanks again for sharing your insights! ​@Alistair FIeld ​@DannyPancratz  ​@mitchell.gordon ​@samanthahamlet 

                Translate
                  Terms & ConditionsAccessibility statement