Introduction

Welcome to Week 10 of Learning Mixpanel. I’m Ansh, a Mixpanel Certified Partner. I’ve had the privilege of working with 60+ startups, helping them set up their analytics infrastructure and gain actionable insights using Mixpanel.

Curious about my work? Check out my website for case studies, testimonials, and more details about what I do.

Tired of Mixpanel data going wrong - events missing, properties breaking, or random spikes?

Pravix makes it simple to detect these issues and keep your data clean.

Today, I’m going to talk about how to create cohorts from a report in Mixpanel.

Let’s get into it

If your preferred consumption is audio visual - access the video on Youtube

Creating Cohorts from a Report

You can create cohorts directly from a report. Depending on the report type, cohorts can be static or dynamic.

Insights report

Cohorts created from Insights are static. The cohort captures users from a specific time frame (e.g., May 20June 20, and it won’t dynamically update based on current data.

To create a cohort Click on the bar → View Users → Create Cohort.

Line Chart

To create a cohort Click on the bar → View Users → Create Cohort.

Funnels Report

Cohorts from Funnels Reports are dynamic.

For example, if you create a funnel chart for Sign Up to Purchase Completed over the last 30 days, May 20 to June 20, the cohort will capture users from this period.

However, because of the dynamic nature, if your conversion criteria allow 7 days for purchase completion after signup, users who signed up yesterday still have 6 days to be counted as converted or not. The cohort will update as users complete or drop off.

To create a cohort Click on the bar → View Users → Create Cohort.

You can also click on the dropped off section to create a cohort of users who dropped off.

Retention Report

Cohorts from Retention Reports are static. You can create cohorts for either retained or dropped-off users.

Example: If you want to create a cohort of users who returned on Day 10 after signing up in the last 30 days, the cohort will include users who completed a purchase on Day 10 during that period. This cohort is static, meaning it wonʼt update with new data.

To create a cohort: Click on the Day 10 pointer  Choose between Retained or Dropped Off users → Create Cohort.