Hi Mixpanel community,
If you prefer a video walkthrough of Lookup tables, please click here
We know that there is no perfect data model, and we can’t always have all the data prepared exactly right to answer every possible question. Moreover, there are times when the relevant data doesn’t make it into Mixpanel or the data actually changes after being sent into Mixpanel, which makes answering specific user behavioral questions very difficult, if not impossible.
Enter Lookup tables. Lookup tables provide the ability for Mixpanel customers to augment their data within Mixpanel with additional data (properties). If you are familiar with VLOOKUP in Microsoft Excel and Google Spreadsheets or Dimension tables from the Data warehouse world, then lookup tables is nothing but VLOOKUP and Dimension tables for Mixpanel.
- Enrich data within Mixpanel: if you were tracking "Purchases" but were only tracking "ProductID" as a property, but wanted to do the analysis by "Product category" or "Product price", you can upload a mapping of "ProductID" → "Product category" and "Product price" into Mixpanel and do the analysis immediately with the new attributes without needing to download/export the data or send in new events.
- Change property values: If you were tracking the video category name as "Thriller", but at some point of time started tracking the same video as "Suspense & Thriller", 2 different category values show up in data: "Thriller" and "Suspense & Thriller" for the same video. A lookup table of mappings of the "old" category names to the "new" category names can be uploaded to have both "Thriller" and "Suspense & Thriller" show up as "Suspense & Thriller".
- Filter by a long list of property values: Let's say you ran a price experiment on your e-commerce platform, and then wanted to track how purchases were different in the "experiment cities" in comparison with the "non-experiment cities", you would have to filter a mixpanel report down one city at a time, and this can be very time-consuming, and sometimes impossible at scale. With a lookup table of "City" → "Experiment status", users can filter down to just the cities where "Experiment status" evaluates to TRUE, and this analysis can be completed within seconds.
Who is eligible for this closed beta? Customers on Growth and Enterprise plans.
Interested in joining the beta? Email us at firstname.lastname@example.org