Linking User Profiles with Datawarehouse Connector: Required Information
What information is required to link user profiles using the Datawarehouse Connecotor feature?
Hi Natsuki I., 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
To link user profiles using the Mixpanel Warehouse Connector feature, the key information required is the Distinct ID. This is Mixpanel's identifier for a user and is crucial for joining events performed by a user with their user properties.According to the Mixpanel documentation on User Profiles, when setting up a User Profile sync using the Warehouse Connector, you need to provide:1. A User ID column, which will be mapped to the Distinct ID in Mixpanel. 2. Other columns containing user properties you want to include in the profile.For example, a typical user profile table might look like this:| User ID (Distinct ID) | Name | Email | Department | |-----------------------|------|-------|------------| | 123 | Alice | alice@​example.com | Engineering | | 456 | Bob | bob@​example.com | Product |It's important to note that the User ID (Distinct ID) used in your warehouse table should match the Distinct ID used for tracking events for the same user. This ensures that Mixpanel can correctly join user profile data with event data.If you're planning to use historical profile data, you'll need to set up the table as a History Table, which requires an additional "Start Time" column. This allows Mixpanel to track changes in user properties over time.For more detailed information on setting up User Profiles with the Warehouse Connector, you can refer to the Mixpanel Warehouse Connectors 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.