Is it possible to view total registered members by date range?

[tiffani]

What is the best way to see a breakdown of total members by year based on a date range or period of time? I discovered in this post on how to return total number of members. However, I want to see this figure annually going back a few years when we first migrated to Khoros. 

Thank you in advance. 

[JasonHill · Accepted solution]

No easy way unfortunately @tiffani.

The only way I can think of doing it would be to grab a spreadsheet and record monthly registration figures via Advanced Metrics in the Admin.  

I recommend you keep a running total of members as part of your record keeping...

Jason

[tiffani]

Thank you so much for the prompt reply, @JasonHill. I have a handy spreadsheet but my view is limited as our first year on Khoros has since been archived and is no longer available in the analytics tool. The Metrics section within the Admin tool is still a good resource to extract new registered members for a specific date range but I don't have a starting point of how many members we had when we moved from Jive. I will keep digging. 

[JasonHill]

I don't believe there is any limit to how far back you can go using Advanced Metrics in the Admin @tiffani. The problem is that you can only search for data in short time ranges - no more than a month I think... 

[Parshant · Accepted solution]

@tiffani,

You can also do it by using below API, this will give the results for specific time range using date_start and date_end parameter.

https://community.lithium.com/restapi/vc/users/registered?date_end=2018-12-31T23:59:00Z&date_start=2018-01-01T00:00:00Z

[JacobBo]

Hey everyone!  Stay tuned to the 20.8 release notes coming out this week!

"With the 20.8 release, the Bulk Members report will include Registration Start Date, Registration Completion Date, and Registration Status columns."

@SuzieH 

[tiffani]

This was quite helpful, @Parshant. 

[tiffani]

Thanks to everyone for the help. I appreciate it.