Search for active users with at least 1 post AND registered within the last 6 months
Looking to gather data around this question:
Can you search for active users with at least 1 post and registered within the last 6 months?
I am trying to find out that for every 6 months of the new members joining, are they active and posting at least 1 time within the community. Right now, I can only uncover members all time rather than from members who are only newly registered during that time frame. Does anyone know a workaround or solution to this?
Page 1 / 1
It’s not pretty, but it should work:
Build a custom User Role (in settings) for each 6 month timeframe
You could automate this with a Zapier zap for going forward, if you wanted
Trigger: New user registration
Action: Add a custom role
Maintenance: update the Zap with the new user role when you need to reset your 6 month interval
Users Overview
Filter by registration date
Select all
Bulk add that custom User Role you created
Analytics > User Dashboard
Filter by that customer User Role
The result should be the User Dashboard showing you only users in that 6 month timeframe (based on your custom role) and you’ll get:
Total Users
New Registrations (should match total users)
Users with at least 1 post
the %
column chart of when they signed up
Filterable table to show top users by points, posts, etc
Upside of this approach is that you should be able to export the data to csv for more analysis or chart building in excel/sheets. But to do so, you’ll probably need to cross reference between the user export and the post/topic export.
The user role will be in one of the export columns and you can filter that way.
@DannyPancratz thanks for the insight and helping, it certainly isn’t a streamed line way of approaching it but it works at least. Thank you!
Hey @krystalwu, you should be able to get users that registered in the last 6 months on the User Overview. There’s an option on the filters named “Registration date”.
I did the filter you asked on our community and I believe that’s what you’re looking for?
You can also save this filter as segment on the top right corner
The only problem is that I don’t know if the segment will keep updating the last 6 months, it might co-relate only to the day you saved the segment but you can test this and let us know here
Hi @krystalwu ,
You should be able to achieve this from the user overview like @leo-inspired mentioned.
You can combine the filters so that you can target those that have registered after a specific date AND that have more than 0 topics or replies.
The segment feature will allow you to save these filters as a segment which auto-updates automatically, will show segments as a percentage of your user base and allows you to take action on your users through our upcoming bulk actions!
Those are much better solutions. :)
In defence of Danny, this is fairly new functionality :)
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.