MLT metrics
The document linked below has been created in hopes of creating a more self-serve Analytics infrastructure for product, product managers, and other employees to perform their own analysis. It provides up-to-date metric definitions, as well as Looker links to pre-filtered jumping off points for modeling the data. This documentation was presented in series of Self-Serve Analytics workshops that were hosted in early June FY22. A recording from the workshop has also been provided below for additional context.
This section outlines metric definitions maintained by finance for reporting to investors.
- 1.These are metrics for MLT discussions
- 1.Any metrics shared by a department with the MLT will be asked to work with business operations to define the metric to be listed on this page under standardized naming and MLT definition checklist
- 2.Definitions center around ARR, GMA Magic Number and NPS
MLT definitions checklist
- 1.Qualifiers precede metrics names
- 1.i.e. use ""Gross Margin Adjusted Magic Number" instead of "Magic Number, Gross Margin Adjusted" to avoid ambiguity when label names are truncated
- 2.Metric names should only have one possible interpretation
- 3.All MLT Metrics should have a unique acronym shorter than 8 characters
- 1.Metrics will inevitably be shortened, pre-emptive definition avoids collision
50% complete
- New ARR: ARR from new logos signed, with license start dates in the respective period.
- Expansion ARR: ARR from existing customers with a cross-sell/upsell deal, with license start dates in the respective period (e.g. increased licensed seat count, upgrading from E10 to E20).
- Contraction ARR: Reduction in ARR from existing customers, but where they are still paying Mattermost based on date of license change.
- Churn ARR: Reduction in ARR from an existing customer where they are no longer paying Mattermost based on the license end date.
- Total ARR: Total ARR ending in a specific period.
- IARR: Incremental Annual Recurring Revenue: (New ARR + Expansion ARR) - (Contraction ARR + Churn ARR)
- Count of New Logos (1%): Count of new logos signed, with start dates in the respective period.
- Count of Churned Logos (1%): Count of logos lost where an existing customer is no longer paying Mattermost.
50% complete
- Monthly Server Downloads: Number of successfully completed unique TE + EE downloads by unique client IP address per month, from mattermost.com. Includes web browser and wget / curl downloads.
- Note: Excludes GitLab Omnibus downloads, Docker (Dockerhub) downloads, and Bitnami or other cloud image downloads, as we don’t currently have a good way of measuring these downloads.
- Monthly Enterprise Account Server Downloads: Number of Monthly Server Downloads among companies and organizations with over 5,000 employees.
- New Monthly Server Downloads from Named Enterprise Accounts (1%): The first contact or lead from a Named Enterprise Account who were attached to an opportunity either manually by an AE or by Marketo, and who provides a business email on mattermost.com/download after downloading the Mattermost server binary. Excludes Salesforce account types equal to Customer or Partner.
- TEDAS: Telemetry Enabled Daily Active Servers: _**_Number of unique servers that have “Error Reporting and Diagnostics” or “Security Alert” enabled in System Console, and send telemetry “activity data” (such as number of users).
10% complete
- Total Active Users: The total number of user accounts created on a single Mattermost server. Excludes deactivated accounts, deleted accounts and bot accounts. This is also the “Total Active Users” measure shown in System Console > Site Statistics.
- Registered Authorized Users: Same as Total Active Users.
- Total Registered Users: The total number of user accounts created on a single Mattermost server, including deactivated and deleted accounts.
- DAU: Daily Active Users: The total number of users who viewed the Mattermost site in the last 24 hours. Excludes bot accounts. This is also the “Daily Active Users” measure shown in System Console > Site Statistics.
- TEDAU: Telemetry Enabled Daily Active Users: The total number of users averaged over the last 7 days, who viewed the Mattermost site in the last 24 hours from servers that have “Error Reporting and Diagnostics” or “Security Alert” enabled in System Console, and send telemetry “activity data” (such as number of users). Excludes bot accounts.
- MAU: Monthly Active Users: The total number of users who viewed the Mattermost site in the last 30 days. Excludes bot accounts. This is also the “Monthly Active Users” measure shown in System Console > Site Statistics.
- Active User Count: A measure of the number of active users last 24 hours. Legacy measure, do not use this for analysis or decision-making.
1% complete
- GMA Magic Number: Gross Margin Adjusted Magic Number (1%): Net New ARR in a period multiplied by Gross Margin in the period, divided by total Sales & Marketing expense in prior period.
- NGMA Magic Number: Non-Gross Margin Adjusted Magic Number (1%)
- Gross Margin: Net sales revenue minus cost of goods sold
- Net Sales Revenue:
- Cost of Goods Sold:
50% complete
- Organic Traffic:
- Organic Web Traffic: Monthly unique visitors to *.mattermost.org, *.mattermost.com who originate from non-paid sources.
- Organic Search Traffic: Monthly unique visitors to *.mattermost.org, *.mattermost.com who originate from an organic Google search.
1% complete
- Enterprise Trial Requests: Number of trial license requests via https://mattermost.com/trial from Named Accounts or Enterprises with 5,000+ employees, in America, EMEA, Australia or Japan.
- Enterprise Contact Us Requests: Number of contact us requests via https://mattermost.com/contact-us from Named Accounts or Enterprises with 5,000+ employees, in America, EMEA, Australia or Japan.
- MQL: Marketing Qualified Lead:
- PQL: Product Qualified Lead: Installed free TE/E0 version from a Target Account interested in EE features.
10% complete
- 90s Hiring vs Goal (P0, P1, P2): Difference between hiring plan and hires broken out by priority level (P0, P1, P2), function and time.
- P0 - Roles which hiring managers have flagged as high need.
- P1 (1%) - Roles which hiring managers have flagged as medium need.
- P2 (1%) - Roles which hiring managers have flagged as nice-to-have.
- Monthly Active Contributors: Number of unique contributors in a given month who have posted at least one message on the Mattermost forums OR have committed at least one line of code to any of the publicly available Mattermost repositories on GitHub, including Mattermost Staff and those participating in a paid R&D candidate audition project.
- Note: Excludes translators, integration/solution creators and QA/UX contributors, as we don’t currently have a good way of measuring these contributors.
- Monthly Code Contributors: _**_Number of unique contributors in a given month who have committed at least one line of code to any of the publicly available Mattermost repositories on GitHub, excluding members in the Mattermost GitHub organization.
50% complete
- Product NPS: The product net promoter score (Product NPS) measures user satisfaction of the product, calculated based on single question “How likely are you to recommend Mattermost?”. The score is based on a -100 to 100 scale, with the calculation detailed here _**_gathered through in-product survey.
- End User Product NPS: The Product NPS calculated among end users only (ie. not among Team or System Admins).
- System Admin Product NPS: The Product NPS calculated among System Admins only.
- EE Product NPS: The Product NPS calculated among all users in licensed E10 or E20 servers only.
1% complete
- Customer NPS: Customer satisfaction of the product, calculated based on single question “How likely are you to recommend Mattermost to a friend or colleague?", sent two days after booking or renewal is closed. The score is based on a -100 to 100 scale.
- Support Metrics (E10 and E20): Metrics calculated based on Zendesk tickets opened by E10 and E20 customers. Tickets opened by non-subscribed organizations are not counted towards these metrics.
- Tickets Created: Number of net new Zendesk tickets created.
- First Response Time [Median, hours]: The median number of hours from when a ticket was opened in Zendesk to when the first response was sent to the customer.
- % First Response >8 Business Hours: % of newly opened Zendesk tickets whose first response time is greater than 8 business hours as defined in https://mattermost.com/support/.
- Resolution Time [Median, hours]: The median number of hours from when a ticket was opened in Zendesk to when the ticket is resolved.
- % Resolution Time >7 days: % of newly opened Zendesk tickets whose first resolution time is greater than 7 days.
- % Resolution Time >14 days: % of newly opened Zendesk tickets whose first response time is greater than 14 days.
- Number of CSAT Responses: # of new CSAT (Customer Satisfaction) survey responses from customers whose Zendesk ticket was resolved.
- Customer Satisfaction Score: % of newly submitted CSAT survey responses who responded “Yes” to the question .
To be added.
DRI for this page is Jason Blais
Last modified 1yr ago