I created a lookup table and linked it to a property available in two events, but the table data is only available when using one of the events and not in the other. why is that and how to fix it ?
Hi Zeyad Y., 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
Based on the information provided in the knowledge sources, I can help explain why your lookup table might only be working with one event and not the other.Lookup tables in Mixpanel allow you to dynamically extend additional properties mapped to an existing Event or User Property. They're designed to enrich events at query-time by providing additional context for specific property values.The issue you're experiencing could be related to how lookup tables are linked to properties. When you create a lookup table, you map it to a specific event property. For example, if you create a lookup table for "Songs" and map it to an event property song_id
, you can use the additional properties from the lookup table when filtering or breaking down events that have song_id
as an event property.If your lookup table is only working with one event and not the other, there are a few possible explanations: 1. Property name case sensitivity: Mixpanel is case-sensitive, so property_name
and Property_Name
are considered different properties. Make sure the property name is exactly the same in both events.2. Property type differences: If the same property name is used in different contexts (like as both a regular profile property and a historic property), they will be treated as distinct and separate entities according to Mixpanel's documentation.3. Data Views filtering: If you're using Data Views, certain filters might be affecting which events can access the lookup table.To fix this issue: 1. Check that the property name is exactly the same (including case) in both events
2. Verify that the property values in both events match the key values in your lookup table
3. If you're using Data Views, check if there are any filters that might be affecting one of your events
4. Consider using Lexicon to merge the properties if they have slightly different names but serve the same purposeYou can also check your Lexicon to see which properties are linked to your lookup table by clicking into the Lookup Table definition as mentioned in the Lexicon documentation.If these suggestions don't resolve your issue, you might need to contact Mixpanel support for more specific assistance with your implementation.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.