How to Setup Mixpanel Integration

This integration will allow you to connect with Mixpanel and start collecting your data. It is a matter of minutes to send your data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

    1. Connecting Mixpanel
    2. Set the Replication Frequency
    3. Load your Mixpanel data into your data warehouse
    4. Mixpanel expected Data Model and schema

Getting Started

To add this integration, go to Blendo Home page. Click Add a Source.

Connect to Mixpanel

Settings you need from Mixpanel

We will need the: API Key and API Secret from our Mixpanel project along with the Project’s Timezone in our Mixpanel setup.

Let’s find our Project’s Timezone in Mixpanel first. 

1. Login to your Mixpanel account from a new tab

2. Select your project from the drop-down list on your left.

Load data from mixpanel

Select your Mixpanel project

3. Click on the drop down next to your name on top right.

Load data from mixpanel

4. Here is the Timezone of you project. Keep it in mind to use it inside Blendo’s Mixpanel integration.

Load data from mixpanel

Mixpanel Project Timezone

Let’s find our API Key and API Secret now.

5. Click the drop down next to your name on top right navigation bar and then click on Account.

Load data from mixpanel

6. Click Projects

Mixpanel Interface

Click “Projects”

7. Copy the API Key and API Secret for the Project you need.

Mixpanel Interface

Copy the API Key and API Secret for the Project you need

8. Paste both into the boxes provided in Blendo. Change your Project Timezone according to step #4.

9. Choose how further back you want Blendo to go at its first connection. This will get you your historical Mixpanel data.

10. Add a table prefix if you like. Click Validate & Save.

Load data from mixpanel

Export data from Mixpanel

11. Now that you have your Mixpanel data source in Blendo its time to export your data and import them to Blendo. You may trigger it by yourself or Blendo will do it automatically.

12. Click on your newly created Mixpanel data source.

Export Mixpanel data

 

Import data from Mixpanel

Expected Mixpanel Data

Getting your Mixpanel data is one thing. What about these data though? Let’s see:

      1. How Blendo syncs Mixpanel data
      2. The tables with Mixpanel data that we create in your destination data warehouse

How Blendo syncs Mixpanel data

Historical Data

When Blendo first connects to Mixpanel Data source, will pull all your historical data (events) generated up to a configurable date:
import mixpanel historical data

Sync Schedule

Blendo syncs Mixpanel events based on the schedule and frequency you choose. Events can now be imported up to once per 15 minutes, by setting the frequency in the Schedule section.

Replication Process

After your initial import, your events are replicated incrementally, meaning that Blendo will only replicate events generated since your last import.
All imports will fetch events up to 15 minutes ago, to ensure Mixpanel has all requested events available.

What Mixpanel data do I have available?

Bellow are the tables with Mixpanel data that we create in your target data warehouse.

Expected Mixpanel Data Model & Schema Information

For a complete view of the data model of your expected data click here.

Mixpanel Data Model & Schema

Events

Table Name: events

This table contains raw event data. These data include the event along with its properties.

Primary Key: blendo_id

Columns of this table include:
distinct_id,name,time, arbitrary number of columns with the prefix: properties_. These are the custom properties that you might have added to your events, together with the defaults that Mixpanel has.

Questions? Contact us!

in Connecting SaaS Data Sources