I would like to understand what is the average time for a new registered user to post their first topic or their first reply.
Is there a way to get this information or calculate it somehow?
And of course it would be handy to exclude all non-active members out of the calculation entirely.
I don’t think it’ll be easy (and I haven’t done this myself), but I think it’s possible using the REST API for two things
You also can do exports of these, but you’d need to do “All time” exports and refresh them regularly.
With a BI tool (Tableau, Power BI, etc), you should be able to link those two data sources by userId. Then, you could create a table that pulls in
You should be able to also then calculate the difference between those two date and average/median it out.
Could you do the same thing in Excel/Google Sheets? Probably, but there’s a lot more risk of messing things up in the many steps along the way. From my experience, BI tools will make it a lot easier to 1.) model and 2.) refresh.
If you don’t have the expertise and/or tools needed to do that, I recommend finding a colleague who does.
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
