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
- Users
- Posts
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
- UserId / username
- Registration Date
- Date of first Time Stamp (from the Posts data)
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.
Pulling
You are welcome
Thanks for your input
Pulling
You are welcome
Hi there, Thank you for the mention!
This is actually not a metric we report on. I’m sorry!
I would follow
We use Tableau so this is actually a good inspiration for our tables :)
Reply
Sign up
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.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.