Mixpanel (Edge)

Configure Mixpanel as a Source in your Pipeline

Perform the following steps to configure your Mixpanel Source:

1. Click Pipelines in the Navigation Bar.

2. Click + Create Pipeline in the Pipelines List View.

3. On the Select Source Type page, select Mixpanel.

4. On the Select Destination Type page, select the type of Destination you want to use.

5. On the Select Pipeline Type page, click Edge, and then click Continue.

   

   Note: This page appears only if both the Source and the Destination type you selected are supported in Edge. Otherwise, the Configure Source page appears.

6. On the Configure Source page, specify the following:

   

   • Source Name: A unique name for your Source, not exceeding 255 characters. For example, Mixpanel Source.

   • In the Connect to Mixpanel section:

     • Service Account Username: The username of the Mixpanel service account. For example, my-service-account.ab12cd.mp-service-account.

     • Service Account Secret: The secret that Mixpanel showed when you created the service account.

     • Project ID: The ID of the Mixpanel project from which you want to ingest events, from Project Settings > Overview in Mixpanel. The service account must have access to this project.

   • In the Sync Settings section:

     • Historical Sync Time Frame: The events that Hevo ingests in the first run of the Pipeline. Select one of the following options:

       • Sync all available data: Hevo ingests all the events available in the project, from March 1, 2019. This is the default option.

       • Sync data from selected date: Hevo ingests the events from the date that you specify.

         • Backward Sync Limit Date: The date (in UTC) from which Hevo ingests events. The earliest date that you can select is March 1, 2019.

7. Click Test & Continue to test the connection to your Mixpanel Source. Once the test is successful, you can proceed to set up your Destination.

---

Data Replication

Hevo replicates data for all the objects selected on the Configure Objects page during Pipeline creation. By default, all supported objects and their available fields are selected. However, you can modify this selection while creating or editing the Pipeline.

Hevo ingests the following types of data from your Source objects:

• Historical Data: The first run of the Pipeline ingests the events of the period that you selected in the Historical Sync Time Frame field, and loads them into the Destination.

• Incremental Data: Once the historical load is complete, Hevo ingests the new events as per the sync frequency. Incremental changes are detected using the time field of each event.

Mixpanel returns events by date (in UTC). In each run, Hevo ingests the events of the current day again, until the day is over, so that the events received later in the day are also ingested. In addition, about once every 24 hours, Hevo ingests the events of the last 8 days again, instead of the new events. As a result, Hevo ingests the events that reach Mixpanel up to 8 days after they occur, such as events sent with a delay from mobile apps. Hevo identifies each event by its name, distinct ID, time, and insert ID, so an event that is ingested again updates its existing record in the Destination.

Mixpanel currently enforces a rate limit of 60 queries per hour and 3 queries per second for the Raw Event Export API. If this limit is exceeded, a rate limit exception occurs. To understand how Hevo handles such scenarios, read Handling Rate Limit Exceptions.

Note: You can create a Pipeline with this Source only using the Merge load mode. The Append mode is not supported for this Source.

---

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination. For a detailed view of the objects, fields, and relationships, click the ERD.

---

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

---