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 data source on Kondado
Step-by-step guide to connect your Mixpanel account to the Kondado platform by retrieving your API Secret and configuring the data source.
Log in to Mixpanel and access settings
Log in to your Mixpanel account and click on the gear icon in the top right bar.
Select your project
In PROJECT SETTINGS, select the project you want to pull data from.
Locate ACCESS KEYS
On the project settings page, locate the ACCESS KEYS section.
Copy API Secret
In ACCESS KEYS, copy the value of API Secret.
Select Mixpanel on Kondado
On the Kondado platform, go to the add new sources page and select the Mixpanel data source.
Configure and save
Give your data source a name and paste the API Secret value in the API Secret field, then save the data source.