Already have an account? Sign in

Mixpanel (v1)

Mixpanel integration summary

Stitch’s Mixpanel integration replicates data using theMixpanel Event Export API and Mixpanel Query API. Refer to theSchema section for a list of objects available for replication.

Mixpanel feature snapshot

A high-level look at Stitch's Mixpanel (v1) integration, including release status, useful links, and the features supported in Stitch.

Connecting Mixpanel

Mixpanel setup requirements

To set up Mixpanel in Stitch, you need:

• Admin privileges. These are required to retrieve your API secret in your Mixpanel account.

Step 1: Retrieve your Mixpanel project timezone and API secret

1. Login to your Mixpanel account.
2. In the dropdown menu in the upper left corner of the page, select the project you want to replicate data from.
3. Hover over theSettings icon in the upper right corner. In thePROJECT SETTINGS portion of the dropdown menu, click on the link with the name of your project.
4. Copy theProject Timezone andAPI Secret, and paste those values someplace safe to use for the next step.

Step 2: Add Mixpanel as a Stitch data source

1. Sign into your Stitch account.

2. On the Stitch Dashboard page, click theAdd Integration button.

3. Click theMixpanel icon.

4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

   For example, the name “Stitch Mixpanel” would create a schema calledstitch_mixpanel in the destination.Note: Schema names cannot be changed after you save the integration.

5. In theAPI Secret field, paste theAPI Secret you retrieved fromStep 1.
6. In theAttribution Window field, enter the number of days you want your tables’ attribution window to be. For more information on attribution windows, refer to theReplication section.

7. In theDate Window Size field, enter the number of days desired for a date looping window for theexports,funnels, andrevenues tables.

   Date looping will return records whosefrom_date andto_date fall between the number of days in the defined window size.

   Note: If your project has large volumes of events, you may want to set the number of days to14,7, or even to1 or2 days.

8. Optional: To fetch specific events, enter a comma-separated list of events in theExport Events field. For example:Page Viewed, Signed Up.
9. In theProject Timezone field, paste theProject Timezone you retrieved fromStep 1.
10. Optional: To capture new properties automatically in theevents andengage tables, check theSelect Properties By Default box. Otherwise, new properties will be ignored.

Step 3:

The Sync Historical Data setting defines the starting date for your Mixpanel integration. This means that dataequal to or newer than this date will be replicated to your data warehouse.

For a detailed look at historical replication jobs, check out theSyncing Historical SaaS Data guide.

Note: Mixpanel limits the number of days historical data may be accessed, depending on your Mixpanel plan. If you select a Start Date greater than what your Mixpanel account has access to, Stitch may encounter issues with Mixpanel’s API.

For example: If you have a Starter Free Mixpanel plan, you have access to 90 days of historical data (as of 06/5/2020). If you select a Start Date greater than 90 days, Mixpanel’s API may return an error.

Additionally, the Start Date must be less than or equal to365 days. If a Start Date greater than 365 days is selected, Stitch will reset the Start Date to 365 days during Extraction.

Refer toMixpanel’s documentation for more info and to check your Mixpanel account’s historical data access limit.

Step 4: Create a replication schedule

In theReplication Frequency section, you’ll create the integration’sreplication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Mixpanel integrations support the following replication scheduling methods:

• Replication Frequency

• Anchor Scheduling

• Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See theUnderstanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

The last step is to select the tables and columns you want to replicate.Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

• Selection options
• Individual tables and columns
• All tables and columns

Initial and historical replication jobs

After you finish setting up Mixpanel, itsSync Status may show asPending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, aPending status indicates that Stitch is in the process of scheduling the initial replication job for the integration.This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Mixpanel replication

Attribution windows and data extraction

When Stitch runs a replication job for Mixpanel, it will use the value of theAttribution Window setting to query for and extract data for tables using Key-based Incremental Replication. An attribution window is a period of time for attributing results to ads and the lookback period after those actions occur during which ad results are counted.

For example: If set to5 days, Stitch will replicate the past five days’ worth of data for applicable tables every time a replication job runs. While Stitch replicates data in this way to account for updates to records made during the attribution window, it can have asubstantial impact on your overall row usage.

Note: If the beginning of the attribution window is earlier than the selected Start Date, the replication will start from the Start Date and no data before that date will be fetched. For example, if you set the Start Date to five days ago and the attribution window to ten days, only the past five days’ worth of data will be replicated.

In the sections below are examples of how attribution windows impact how Stitch extracts data during historical and ongoing replication jobs.

• Historical and full re-replications
• Ongoing replications

SELECT*FROMmixpanel.revenueWHEREdate>='2017-07-03 00:00:00'/* Start Date */ORDERBYdate

SELECT*FROMrevenueWHEREdate>='2017-09-26 00:00:00'/* max Replication Key value - Attribution Window */ANDdate<='2017-10-01 00:00:00'/* max Replication Key value from previous job */ORDERBYdate

Attribution windows and row count impact

Due to the Attribution Window, a high Replication Frequency may not be necessary. Because Stitch will replicate data from the pastN days during every replication job, recent data will be re-replicated and count towards your row quota.

To reduce your row usage and replicating redundant data, consider setting the integration to replicate less frequently. For example: every 12 or 24 hours.

Hidden fields in Mixpanel

The Stitch Mixpanel integration is not able to discover fields marked as hidden in your Mixpanel account. To ensure the fields you want replicated will be available in Stitch, double-check that they aren’t hidden in your Mixpanel account.

Mixpanel table reference

annotations.project_id = cohorts.project_id

cohort_members.cohort_id = cohorts.id

cohorts.id = cohort_members.cohort_id

cohorts.project_id = annotations.project_id

Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.