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.
- Week 1What 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.
- Week 2Mixpanel 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.
- Week 3What 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.
- Week 4How 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.
- Week 5How 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.
- Week 6Mixpanel 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.
- Week 7How 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.
- Week 8Mixpanel 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.
- Week 9How 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.
- Week 10How 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.
- Week 11Mixpanel 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.
- Week 12How 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.
- Week 13How 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.
- Week 14How 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.
- Week 15How 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.
- Week 16Mixpanel Dashboards: Filters and Subscriptions
How Mixpanel dashboards work: combining reports with text and images, filters that override report filters, and Slack or email subscriptions.
- Week 17How 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.
- Week 18How 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.
- Week 19How 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.
- Week 20How 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.
- Week 21Group 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.
- Week 22How 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.
- Week 23Borrowed 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.
- Week 24How 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.
- Week 25Mixpanel 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.
- Week 26Mixpanel 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.
- Week 27How 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.
- Week 28Computed 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.