Mixpanel Community Icon

Can I use a group distinct ID as the key for a look up table

·
·

Can I use a group distinct ID as the key for a look up table

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Hi Jessica D., 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

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Based on the knowledge sources provided, I can answer your question about using a group distinct ID as the key for a lookup table in Mixpanel.No, you cannot use a group distinct ID as the key for a lookup table in Mixpanel. According to the Lookup Tables FAQ, group profile properties cannot be used as lookup table keys: "Note: Currently, group profile properties cannot be lookup table keys."Additionally, the documentation advises against using lookup tables for high cardinality IDs or as a way to mutate events. Instead, it recommends using Group Profiles for group-level data and User Profiles for user-level data.If you need to analyze data at a group level, Mixpanel offers Group Analytics as a separate feature. This allows you to establish an event property other than the distinct_id, such as a company ID or account ID, as an identifier for group-level analysis. However, this is different from using it as a lookup table key.For more information on Group Analytics, you can refer to the Group Analytics documentation.

    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.