DAU = # of unique active users in a day
Same as the MAU template we looked at, it is important to define what an “active user” is for your service.
DAU is often used with MAU, to calculate the stickiness of your service. First, let’s try calculating our DAU!
For this template, we will be using the database for the fake B2B SaaS startup we created, Awesome Company. We will be considering those who logged into our service on a given day. as active users.
On Outcode, you can create a Daily Active Users Databoard in under 10 minutes.
Sample MySQL database
This is what Awesome Company's MySQL database looks like.
To track your DAU, you need the following data:
- log-in date
- user id
How to calculate the DAU in SQL
Let’s say we want to find the DAU for April 10th, 2022. We need
user_id and the
created_atcolumns from the login_history table to calculate the DAU. 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.
SELECT DATE_FORMAT(created_at, "%Y %M %d") AS DAY, COUNT(user_id) AS DAU FROM login_history GROUP BY DATE_FORMAT(created_at, "%Y %M %d") ORDER BY DATE_FORMAT(created_at, "%Y %M %d") desc
Do you have a better way to find DAU? Please reply below and inspire the fellow Outcoders!
Want to do more with your data?
- DAU is only a number on its own. Try finding the ratio between MAU and DAU to see if your service is keeping your users engaged!
- 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 sent via Slack or email with Outcode's quick automation feature.