Mixpanel Community Icon

Can I export user data with event properties at the same time

Can I export user data with event properties at the same time

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

    Hi Evan S., 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
    ·
    ·

    Mixpanel stores user data (user profiles) and event data (with event properties) in separate tables. When exporting data, you typically export events (with their event properties) and user profiles (with their user properties) separately. - Event Export: You can export raw event data, which includes all event properties, using the Raw Event Export API or via CSV from the UI. These exports contain the event’s properties and the distinct_id that ties the event to a user, but do not include user profile properties directly in the same export file. - User Profile Export: You can export user profile data (user properties) using the Engage API or as a CSV from the Users tab. These exports contain user properties but not the event properties.Mixpanel joins events and user profiles at query time in the UI, not at export time. This means that when you export, you will get either event data (with event properties) or user profile data (with user properties), but not both combined in a single export file. If you need to analyze user data alongside event properties, you would need to join these datasets externally after export using the distinct_id as the key Mixpanel Data Model User Profile FAQ.Exception: If you use Mixpanel’s Data Pipelines (such as JSON Pipelines or BigQuery integration), all event and user profile properties are exported under a properties key in their respective tables, but events and user profiles are still separate tables. You can join them externally using the distinct_id JSON Pipelines BigQuery Integration.Summary: You cannot export user profile data and event properties together in a single file directly from Mixpanel. You must export them separately and join them externally if needed.

    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.