How to calculate Gross churn in Mixpanel

Make the most of your Mixpanel data

What is Gross churn ?

Gross churn is defined as the MRR (Monthly Recurring Revenue) lost in a given month divided by the MRR (Monthly Recurring Revenue) at the beginning of the month. This value is expressed as a percentage where as Net Churn is expressed as the difference between MRR (Monthly Recurring Revenue) lost in a given month and the MRR (Monthly Recurring Revenue) at the beginning of the month.

What is Mixpanel ?

Mixpanel is an analytics platform that focuses on measurement via firing events. It's great for segmentation if the website you add it to has this data. It's strong for mobile and websites where you are able/will be using PII (Personal Identifiable Information).

How to calculate Gross churn in Mixpanel ?

It can be difficult to calculate Gross churn directly inside of Mixpanel; that's where Whaly comes in.

Whaly helps you build models on top of Mixpanel and many other solutions. You simply connect Whaly to your Mixpanel account, and then you can create your formula in Whaly to calculate your Gross churn.

How does Whaly work ?

01
Self-Service Business Intelligence
Our self-service exploration tool is designed with business teams in mind, with the goal of empowering non-technical users to answer their own data questions and run queries autonomously. Our familiar, intuitive, drag & drop experience maximizes adoption across the business, leading to more data-driven decisions.
Visualize your data
02
Declarative Modeling
Our modeling workbench is tailored to data teams, allowing them to implement business logic, create the semantic layer, and model data from different sources using SQL. Our bespoke tool enables data teams to set up a solid data foundation that can be easily governed as you scale.
Build your metrics
03
Get up and running ASAP
Whaly comes with some quick-start ETL connectors included with our platform, to help you get up and running in record time. For connectors that we don’t offer, we’ll connect you to your best-suited ETL partner to ensure that your BI projects are always complete.
Benoit Prigent
Benoit Prigent
Co Founder / CPO @ Lokki
Whaly helped us create metrics on top of 6 data sources in a matter of days instead of months without technical knowledge required !!
Edouard Mascré
Edouard Mascré
Co Founder @ Pennylane
We leveraged Whaly on the Sales team to build and share dashboards with ton of partners without having to continuously update things on many spreadsheets. It also gives us deeper insights on sales activity. The dashboards built can be shared with everyone in the company. Whaly saves us hours of data wrangling every day.
Benjamin Cambier
Benjamin Cambier
Co Founder @ Mansa
Mansa grew really fast in the past months and we were in urge of more precise metrics, especially for acquisition and deals analysis. Our engineering team was already swamped so we started our data analysis with Whaly. We compute our CAC per acquisition channel and understood at what stage the pipeline is under performing in minutes.
Quentin Lebret
Quentin Lebret
VP Operations @ Klox
Whaly gave us the tools to understand how our users consume our product and helped us create a better experience for our users.
Julio Cesar Rodriguez
Julio Cesar Rodriguez
Operation Automation Specialist @ Career Karma
Whaly helped us create actionable experience for our SDR based on data our data team has prepped for us in dbt.
Hugo Cornu
Hugo Cornu
Head of Growth @ Klox
Whaly helped us transform the way we work with data. We now back all our decision with data and can make informed decisions at any time