DAU / MAU, WAU / MAU, DAU / WAU Template: Excel, Google Sheets, and Actiondesk

Sometimes called: Daily, Weekly, Monthly Active User Report

Determine how frequently your typical user uses your product on a daily/weekly/monthly cadence.

Jump to downloads

What you can do with this DAU / MAU, WAU / MAU, DAU / WAU template

Understand how sticky your product is
Calculate the proportion of monthly active users who engage with your product on a daily basis
Segment your customers: look at your DAU / MAU for paying customers vs non-paying customers

Download our DAU / MAU, WAU / MAU, DAU / WAU spreadsheet template

Excel Download
If you like manually inputting data offline:
Download .XLSX
Google Sheets Download
If you like manually inputting data in the cloud:
Copy Google Sheet
Live sync in an Actiondesk spreadsheet
Automatically sync your spreadsheet with your data sources:

Find reporting templates for all these related data sources

Actiondesk works seamlessly with all of them.

14 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

13 templates

14 templates

14 templates

14 templates

DAU / MAU and DAU / WAU can be very helpful ratios to look at for SaaS or consumer companies.

Let's define terms:
- DAU: Daily Active User
- WAU: Weekly Active User
- MAU: Monthly Active User
- Active User: this could depend on your business and you could customize your definition, but generally, it means the user logged in.

Looking at the DAU / MAU basically gives you an indication of the frequency of usage for a typical Monthly Active User. Do they use your product every day? Once every two days? Once a week?

For Saas, there are some subtleties you should take into account (well described in this article from David Sacks)
- You probably want to exclude weekend days from your DAU / WAU calculations (ie consider the week is 5 days long instead of 7 days long)
- As described in this other template, it's often helpful to look at segment rather than at the average metric for all users.
- Here, it can be particularly helpful to look at these ratios for paying customers only, and for your top 10 customers or top 100 customers.
- Don't look at an average over three months, rather, look at the data per day / per week over a longer period.