[Week 9] Learning Mixpanel: Checking data flow
Introduction
Welcome to Week 9 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.
Today, I’m going to talk about how to check data flow in Mixpanel and identify data discrepancies.
Let’s get into it
Checking data flow
If your preferred consumption is audio visual - access the video on Youtube.
Steps to check
- Open Mixpanel and click on the Events tab.
- Trigger events in your product. For example, if you have a sign-up event, sign up on your website to trigger the event.
- Go back to Mixpanel. Your event and user ID should appear instantly, though it might take a few moments sometimes.
- Click on the user ID to view the events you triggered and check if everything looks correct. If something is wrong, refer to the tracking plan and ask the dev team to review it.
What to check
Events
- Event Tracking Confirm all events listed in your tracking plan are firing as expected.
- Event Names Check that event names follow the proper naming convention and are consistent.
Property values
- Event Properties Verify that the event properties are being captured accurately.
- User Properties Ensure user properties are being tracked correctly.
- Property Consistency Make sure properties are consistently formatted. For example, if tracking user age, it should always be recorded as a number, not a mix of numbers and strings.
No duplicate data
- Duplicate Events Check for duplicate events to avoid skewing the analysis. Each event should be recorded only once per user action.
- Duplicate Properties Verify that properties are not duplicated and accurately reflect the user action.
Profile and Super properties
- User Profiles Ensure user profiles are being created and updated correctly.
- Super Properties Verify that super properties are set correctly.
Incremental Properties
Tracking Incremental Values Check that properties tracking incremental values, like session count or total spend, are updating as expected.
Mixpanel learning course
Every week, I’m going to talk about one topic from Mixpanel. If you’d like to access everything at once, take a look at my course on Mixpanel.
The course is a comprehensive deep dive into Mixpanel, covering each feature with relevant, practical examples.
By the end of the course, you'll become a Mixpanel expert—equipped with the knowledge and confidence to navigate and use the platform like a pro.
Having worked with 60+ startups, I’ve structured this course to focus on what actually gets used in Mixpanel and how.
Each chapter includes a video tutorial and a written document (with visuals) so you can choose the learning format that suits you best—video, text, or both!