Do lookup tables support list properties
Hi Christopher C., 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
Yes, lookup tables in Mixpanel do support list properties. According to the Mixpanel documentation on supported data types, list properties are one of the five main data types supported by Mixpanel, including for lookup tables.A list property is defined as:> A list of values as a JSON array e.g. Favourite Genres = ["Folk","Alternative"]
or Favourite Numbers = [1,5,10.0]
However, it's important to note that there are some limitations for list properties in lookup tables:1. Event Property list limit: 8KB
2. User Profile Property list limit: 256KB
3. Each item in a list is further limited by their data type's limits (e.g., a list of strings would be limited to 255 bytes per string)Additionally, the Mixpanel documentation on lookup tables mentions that lookup tables do not support Objects and List of Objects data types. However, regular list properties are supported.When using list properties with lookup tables, you can perform various operations such as filtering and breakdowns. The Mixpanel documentation provides detailed examples of how list properties work with lookup tables, including filtering and breakdown scenarios.
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.