Mixpanel
This page contains the setup guide and reference information for the Mixpanel source connector.
Prerequisites
- Mixpanel API Secret
- Project region
US
orEU
Setup guide
Step 1: Set up
Please read Find API Secret, and get your API key.
Select the correct region (EU or US) for your Mixpanel project. See detail here
Step 2: Set up the Mixpanel connector in Airbyte
Choose start date, from which data will be synced
Note: If start_date
is not set, the connector will replicate data from up to one year ago by default.
For Airbyte Cloud:
- Log into your Airbyte Cloud account.
- In the left navigation bar, click Sources. In the top-right corner, click +new source.
- On the Set up the source page, enter the name for the Mixpanel connector and select Mixpanel from the Source type dropdown.
- Select
start_date
, from which your data will need to be synced
Supported sync modes
The Mixpanel source connector supports the following sync modes:
Please note, that incremental sync could return duplicated (old records) for the state date due to API filter limitation, which is granular to the whole day only.
Supported Streams
- Export (Incremental)
- Engage (Full table)
- Funnels (Incremental)
- Revenue (Incremental)
- Annotations (Full table)
- Cohorts (Full table)
- Cohort Members (Full table)
Performance considerations
- Due to quite low API rate-limits (60 reqs per hour), syncing of huge date windows may be quite long
- If you're struggling with high RAM usage, try to decrease
date_window_size
parameter in config
CHANGELOG
Version | Date | Pull Request | Subject |
---|---|---|---|
0.1.17 | 2022-06-01 | #12801 | Acceptance tests fix, fixing some bugs for beta release |
0.1.16 | 2022-05-30 | #12801 | Add end_date parameter |
0.1.15 | 2022-05-04 | #12482 | Update input configuration copy |
0.1.14 | 2022-05-02 | 11501 | Improve incremental sync method to streams |
0.1.13 | 2022-04-27 | 12335 | Adding fixtures to mock time.sleep for connectors that explicitly sleep |
0.1.12 | 2022-03-31 | 11633 | Increase unit test coverage |
0.1.11 | 2022-04-04 | 11318 | Change Response Reading |
0.1.10 | 2022-03-31 | 11227 | Fix cohort id always null in the cohort_members stream |
0.1.9 | 2021-12-07 | 8429 | Updated titles and descriptions |
0.1.7 | 2021-12-01 | 8381 | Increased performance for discovery stage during connector setup |
0.1.6 | 2021-11-25 | 8256 | Deleted date_window_size and fix schemas date type issue |
0.1.5 | 2021-11-10 | 7451 | Support start_date older than 1 year |
0.1.4 | 2021-11-08 | 7499 | Remove base-python dependencies |
0.1.3 | 2021-10-30 | 7505 | Guarantee that standard and custom mixpanel properties in the Engage stream are written as strings |
0.1.2 | 2021-11-02 | 7439 | Added delay for all streams to match API limitation of requests rate |
0.1.1 | 2021-09-16 | 6075 | Added option to select project region |
0.1.0 | 2021-07-06 | 3698 | Created CDK native mixpanel connector |