Topic

Learning Mixpanel

A 28-week series on Mixpanel by Ansh Agrawal, from the basics to warehouse connectors, attribution and computed properties. Start at week 1 and read in order.

  1. Week 1
    What Is Mixpanel? An Introduction for Product Teams

    What Mixpanel is, the product questions it can answer, how product analytics differs from business analytics, and how it compares to Heap and FullStory.

  2. Week 2
    Mixpanel Sessions: Session Start, End and Timeout Settings

    How Mixpanel defines a session, when Session Start and Session End fire, the three ways to change session timing, and the session properties you get.

  3. Week 3
    What Is Lexicon in Mixpanel? How to Use It

    Lexicon is Mixpanel's dictionary of every event and property you track. What you can do with it and how it keeps your tracking consistent.

  4. Week 4
    How to Create Cohorts in Mixpanel, With 7 Examples

    What cohorts are in Mixpanel, seven example cohorts built from purchases and user traits, and why a cohort filter only counts users in it today.

  5. Week 5
    How to Create and Update User Profiles in Mixpanel

    How user profiles work in Mixpanel: filtering users in the Users tab, creating and updating profiles, importing from CSV, and deleting properties.

  6. Week 6
    Mixpanel Proxy Setup: Client vs Server vs Hybrid

    Client-side, server-side or hybrid tracking for Mixpanel: what each loses, which to choose, and how to set up a proxy for client-side tracking.

  7. Week 7
    How to Create an Event Tracking Plan for Mixpanel

    How to build an event tracking plan for Mixpanel: what it includes, how to write a good one, best practices, and a sample plan for a real product.

  8. Week 8
    Mixpanel SDK Implementation: ID Merge, Super Properties

    Set up Mixpanel from scratch: find your token, install the SDK, identify users, pick Simplified or Original ID Merge, and send events and properties.

  9. Week 9
    How to Check Your Data Is Flowing Into Mixpanel

    How to confirm Mixpanel events arrive correctly: trigger events, then check event names, property values, duplicates, and profile properties.

  10. Week 10
    How to Build an Analytics Strategy in Mixpanel

    Build a Mixpanel analytics strategy in three steps: break the product into parts, pick metrics that drive decisions, and stop before it sprawls.

  11. Week 11
    Mixpanel Insights Report: A Complete Guide

    A full guide to the Mixpanel Insights report: date and compare options, chart types, event metrics, frequency per user, aggregates and formulas.

  12. Week 12
    How to Build Funnels in Mixpanel: A Complete Guide

    How to build funnels in Mixpanel: conversion windows, any order steps, exclusions, holding a property constant, and each conversion rate measure.

  13. Week 13
    How to Use the Retention Report in Mixpanel

    How Mixpanel's retention report works: retention criteria, how the weighted average is calculated, day and calendar grouping, and which chart to read.

  14. Week 14
    How to Use the Frequency Report in Mixpanel

    Use the Mixpanel frequency report to see how often users repeat an action: grouping by hour, day or month, cumulative vs non-cumulative, charts.

  15. Week 15
    How to Use Flows in Mixpanel to Map User Paths

    How to use Flows in Mixpanel to see the paths users take before and after an event: user flows, top paths, hiding events and breakdown by conversion.

  16. Week 16
    Mixpanel Dashboards: Filters and Subscriptions

    How Mixpanel dashboards work: combining reports with text and images, filters that override report filters, and Slack or email subscriptions.

  17. Week 17
    How to Add Annotations to Mixpanel Charts

    How to add annotations to Mixpanel charts to explain a spike or change on a given date, and which line and column chart types support them.

  18. Week 18
    How to Create a Cohort From a Mixpanel Report

    Create cohorts straight from Mixpanel Insights, Funnels and Retention reports, and learn which ones stay static and which update as users convert.

  19. Week 19
    How to Set Up Alerts in Mixpanel

    How to set up Mixpanel alerts on Insights and Funnels reports: anomaly detection, custom thresholds, how often to check, and email or Slack delivery.

  20. Week 20
    How to Send Ad Data Into Mixpanel to Measure ROAS

    How to bring ad data into Mixpanel for ROI and ROAS: match UTM property names, skip the distinct ID, send daily aggregates and use an insert ID.

  21. Week 21
    Group Analytics in Mixpanel: How It Works for B2B

    What Group Analytics does in Mixpanel: analyse a whole company as one user as well as the people in it. Built for B2B SaaS, sold as a paid add-on.

  22. Week 22
    How to Use Lookup Tables in Mixpanel

    How to use lookup tables in Mixpanel to add details like product name and price to a property such as product_id, and how to format the CSV.

  23. Week 23
    Borrowed Properties in Mixpanel Explained

    How borrowed properties let you use a property from another event in Mixpanel, how to create one, and how the 30 day lookback picks the value.

  24. Week 24
    How to Create Custom Properties in Mixpanel

    How to create custom properties in Mixpanel with formulas, with examples like grouping paid channels and calculating age, plus every operator.

  25. Week 25
    Mixpanel Warehouse Connectors: How to Set Them Up

    Load data from BigQuery, Snowflake, Databricks or Redshift into Mixpanel: events, user and group profiles, lookup tables, and each sync mode.

  26. Week 26
    Mixpanel Attribution Models Explained

    How attribution works in Mixpanel: the lookback window and each model, including first touch, last touch, linear, time decay, U shaped and J shaped.

  27. Week 27
    How to Customise Buckets in Mixpanel Breakdowns

    How to customise buckets in Mixpanel breakdowns: even, varied or no buckets for numbers, and if else or contains rules to group string values.

  28. Week 28
    Computed Properties in Mixpanel Explained

    The four computed properties in Mixpanel: frequency per user, aggregate property per user, duration in Insights, and time to convert in Funnels.

Get new posts by email

Simplifying analytics for Founders and PMs. One email when a post goes out.

New posts only. Unsubscribe from any email.