Public
Occasional Advisor

How do you measure Weekly / Monthly Active Users?

Hey all!

 

I'm looking for the most straightforward way to measure Weekly Active Users (WAU) and Monthly Active Users (MAU).

 

Our criteria for 'active' is posted a member who has logged in and submitted ≥ 1 posts within the last 7 or 30 days.

 

I'm figuring this out using User Exports both from Community Admin and Lithium Social Intelligence but it involves a lot filtering on my end with excel and then further sums. 

 

Can anyone recommend the most efficient (and of course) accurate way to do this?

13 Replies 13
Lithium Alumni (Retired)

Yes, @DanK, I agree. Depending on the size of the community and the particular query you are running, that can be a limitation.



If my post answers your question, please mark it as an "Accepted Solution."
Occasional Advisor

Hey @roisinkirby!

 

We took the route of using the Lithium API so we wouldn't have to make exports repetitively:

 

Interface.png

 

 View 2.png

 

  We automated the requests with a macro in our software, Alteryx, that fires off an authentication request with the provided credentials (v1 API, non-SSO) and uses the Community URL and Board ID to create the request to query a given board. We did a little parsing of the response and added a filter to the date specified in the interface. You’re welcome to use the tool if you like! It looks like the below:

 

 Active Users.png

  

You’d need a trial license to run the maco, but it should bring down all the data you were looking for and save you some clicks in the process!

 

Best of luck,

MattDe


Active Users.pngView 1.pngView 2.pngView 3.png
Honored Contributor

Active Members should be a standard metric in LSI. If you agree, vote with your clicks and comments: https://community.lithium.com/t5/Product-Ideas/Add-Active-Members-Metric-to-LSI/idi-p/213082

 

As has been thoroughly illustrated in this thread, getting at the metric today is painful. @MattDe's solution is awesome because it doesn't require any repetitive tasks like exporting of files or manual Excel work. We're happy to build these and share as we go.

thank you, this helped me. 

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.