where do I create a lookup table
where do I create a lookup table
where do I create a lookup table
Hi Mattias N., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Lookup Tables in Mixpanel can be created via the Mixpanel UI, specifically through the Lexicon feature. Here are the steps to create a Lookup Table:
1. Go to Lexicon in your Mixpanel dashboard. 2. Navigate to Import > Lookup Table. 3. Here, you can upload a CSV file or manage existing lookup tables.
The CSV file should be structured in a specific way:
- The first row is the header and will serve as names for the lookup table properties for each column. Header names must be unique. The first column's header is unimportant and can be any text. - The first column's value will be used to join to the property you map to (i.e. song_id). Values in this column must be unique.
Once you have uploaded the CSV file for the lookup table, map it to an event or user profile property, which is the ID (e.g. song_id) that the lookup table should join with. Mixpanel will assume the first column of the CSV is the ID and will join it with that property.
Please note that only Project Owners and Admins can create global lookup tables mappings. Analysts and Consumers can only create local mappings within reports.
For more details, you can refer to the Mixpanel documentation on Lookup Tables.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.