How can I obtain a Monthly Active Users (MAUs) count for my team for the past 12 months?

If you have access to Insights, the User dashboard has a Users Engaged in Training trendline view that isn’t 100% identical to MAU, but is pretty close and can be filtered down by branch or group.

You can download non-anonymized reports from the Usage Dashboard, would that enable you to do the kind of analysis you have in mind?

Important warning, though: do not try to download more than one of these reports at a time. Always finish downloading the current report before you request the next one. If you get impatient, what can happen is that some kind of blocker is placed on your admin account, and you can’t download any more of these reports without raising a request to Docebo Support. I wish I was joking.

While the visual Usage Dashboard only shows aggregated MAUs at the domain level, you can get exactly what you need by downloading the Active Users report from that same dashboard.

When you download the CSV export (make sure to select the option to download with users' information in clear), the report provides the raw data. It includes columns for datetime, username, and crucially, branches and branch_path.

When I've deployed adoption tracking for organizations with similar requirements, we typically export this CSV and drop it into an Excel Pivot Table or a BI dashboard. By grouping the data by month and branch, and counting the unique usernames, you can easily divide that by your total branch headcount to get your utilization percentage.

A quick gotcha: This export includes Branch data natively. If your teams are configured as Docebo Groups rather than Branches, you'll just need to do a VLOOKUP against a standard Users custom report to map those active users to their respective Groups.

You can find the full data dictionary for the Active Users CSV export here: https://help.docebo.com/hc/en-us/articles/12231370602130-The-Usage-dashboard

In order to get anything valuable from the Active User Report, I have a whole transformation tab in a spreadsheet that allows me to ‘redefine’ the user in regards to teams, organisations, etc.

I think that would work for you too, or something similar.

Get the report, non-anonymized, using the branches, email address, etc. to then leverage Excel and lookups to redefine the user and then aggregate either right in excel or use it in Power BI.

I have been doing this monthly since our go live 6 years ago and while it takes some time, it gives us the view we need.  By chance, are you going to Inspire, I would be happy to sit and show you?

​@JeanetteMcVeigh, I won’t be attending Inspire this year, but would love to see how you map this out leveraging Excel or Power BI.