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 use lookup tables in Mixpanel

Let’s get into it

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

For example, if you have a product_id property, you can use a lookup table to add details like product name, product price, etc., wherever that property exists. This allows you to use those additional properties for deeper analysis.

To set up a lookup table in Mixpanel:

• Go to Lexicon.
• Select Lookup Tables.
• Click Import Lookup Table.
• Upload your CSV and select the relevant property.

Letʼs take the example of product_id, and enriching it with other data to see how our csv should look like, and the process of uploading it.

• Select product_id: In the “Select Property” section of the Lookup Table setup.
• Prepare Your CSV.

a. The first row should be your header (names don’t need to match the property you’re mapping).

b. The first column must contain the product_id values you want to map to (all values must be unique).

• Upload and Save: Click “Save,” and your CSV data will now be available with your event data.

You can also map properties using a lookup table directly within a report. This lookup table will only apply to that specific report and won’t be available globally in other reports.