Mixpanel is a tool for storing and analyzing the behavior of web and mobile applications.
It has a simple and resilient API that allows you to quickly collect various events related to your product.
Adding the data source
To add Mixpanel on Kondado, follow the steps below:
1) Log in to your Mixpanel account and click on the gear in the top right bar;
2) In “PROJECT SETTINGS” select the project you want to pull data from;
3) On the project settings page, locate the “ACCESS KEYS” section;
4) In ACCESS KEYS, copy the value of “API Secret”;
6) Give your data source a name and in “API Secret”, paste the value copied in step (4).
Now you can save the data source and start replicating Mixpanel events into your Data Warehouse or Data Lake!
Pipelines
Relationship chart
Events
Main object
| Field | Type | |
|---|---|---|
| __kdd_fetch_date | date | |
| __kdd_row_key | text | |
| event | text | |
| time | float | |
| distinct_id | text | |
| insert_id | text |
_properties
| Field | Type | |
|---|---|---|
| __kdd_row_key__parent | text | |
| __kdd_fetch_date__parent | date | |
| properties__key | text | |
| properties__value | text |
Add Mixpanel as a data source on Kondado
Connect your Mixpanel account to Kondado to replicate event data into your data warehouse or data lake.
Access Mixpanel project settings
Log in to your Mixpanel account and click the gear icon in the top right bar to open PROJECT SETTINGS, then select the project you want to pull data from.
Copy your API Secret
On the project settings page, locate the ACCESS KEYS section and copy the value of API Secret — this credential is required for Kondado to authenticate with Mixpanel.
Add Mixpanel on the Kondado platform
On the Kondado platform, navigate to the add new sources page and select the Mixpanel data source connector.
Configure and save the data source
Give your data source a name and paste the API Secret copied earlier into the corresponding field. Save the source to begin replicating Mixpanel events into your destination.
Frequently asked questions
event, time, distinct_id, insert_id, and nested _properties with key-value pairs. This lets you analyze user behavior from web and mobile applications in your data warehouse.