DAU/MAU = (# of daily active users / monthly active users)*100
Your DAU and MAU metrics can tell you a lot more through finding the ratio between the two. Higher ratio signals that users engage with your product more often.
Make sure to have your DAU and MAU ready before you get started with this template!
Notes: Most apps or software have a ratio of below 10%. It also depends on your industry, so make sure to find your reference points before you analyze your data.
On Outcode, you can create a DAU/MAU Databoard in under 10 minutes.
Sample MySQL database
This is what Awesome Company's MySQL database looks like.
To track your DAU/MAU, you need the following data:
- log-in date
- user id
How to calculate the DAU/MAU in SQL
We need to have
user_id and the
created_atcolumns from the login_history table to calculate the DAU/MAU. You can easily copy and paste the query below to find your own.
You can also create your own Databoard and share it with your team.
WITH Daily AS ( SELECT DATE_FORMAT(created_at, "%Y-%m-%d") AS DAY, DATE_FORMAT(created_at, "%M %Y") AS MONTH, COUNT(*) AS DAU FROM login_history GROUP BY DATE_FORMAT(created_at, "%Y-%m-%d"), DATE_FORMAT(created_at, "%M %Y") ), Monthly as ( SELECT DATE_FORMAT(created_at, "%M %Y") AS MONTH, COUNT(user_id) AS MAU FROM login_history GROUP BY DATE_FORMAT(created_at, "%M %Y") ) SELECT Daily.DAY, Daily.DAU, Monthly.MAU, CONCAT(ROUND(Daily.DAU / Monthly.MAU * 100, 1), '%') as 'DAU/MAU' FROM Daily JOIN Monthly ON Daily.MONTH = Monthly.MONTH ORDER BY Daily.DAY desc;
Do you have a better way to find DAU/MAU? Please reply below and inspire your fellow Outcoders!
Want to do more with your data?
- It is important to track if your ratio is increasing or decreasing and find out the reasons for such percentage changes.
- Check out our templates and see how you can use your data here.
Share and automate
Outcode helps you to track measures in real-time with the Databoard.
- Share your Databoard or data table with other team members. Copy and paste the page URL anywhere you like.
- Get your real-time DAU/MAU sent via Slack or email with Outcode's quick automation feature.