I am looking for the SQL queries used to generate the trend for Registered / Active / Participating / Contributing users that appears in the Community manager reports.
I want to run the query on the Jive Analytics database.
Appreciate if anyone can help me with this.
We covered a lot of this here: User Adoption CMR report filtering out a system group
The following tables should get you started.
jivedw_adoption_u_*_summary - tables are Container level
jivedw_adoption_*_summary - tables are User & container level