Advanced Analytica Advanced Analytica: IBOM
← All connectors
Mixpanel logo

Source connector

Mixpanel

Set up Mixpanel as a source and move its data into your chosen destination.

Version 4.0.3 community generally available

Mixpanel

Use this page to set up the Mixpanel source connector and find reference information.

Prerequisites

To set up the Mixpanel source connector, you need:

  • A Mixpanel Service Account with access to your project. You’ll need the service account username and secret. To create a service account, you must have Owner or Admin permissions in Mixpanel.
  • Your Project ID, available in your Mixpanel project settings.
  • Your Project Timezone, available in your Mixpanel project settings.
  • Your project’s data residency region: US or EU.

:::note The connector also supports Project Secret authentication. However, Mixpanel has deprecated this method, with an end-of-life date of March 3, 2027. Use Service Account authentication for new configurations. :::

Set up the connector

  1. Log into your Airbyte Cloud or go to the Airbyte Open Source dashboard.
  2. Click Sources, then click + New source.
  3. On the Set up the source page, select Mixpanel from the Source type dropdown.
  4. Enter a name for the Mixpanel connector.
  5. For Authentication, select Service Account. Then enter your service account Username and Secret.
  6. In the same Service Account section, enter your Mixpanel Project ID for Project ID. This field is required for Service Account authentication.
  7. For Attribution Window, enter the attribution window in days. The default is 5 days.
  8. For Project Timezone, enter the timezone for your Mixpanel project. The default is US/Pacific.
  9. Keep Select Properties By Default enabled to capture new properties on events and Engage records automatically. Disable it to ignore new properties.
  10. For Start Date, enter the date in YYYY-MM-DD format. The connector replicates data from this date onwards. If left blank, it replicates up to one year of data by default.
  11. For End Date, you can enter a date in YYYY-MM-DD format. The connector won’t replicate data after this date. Leave it blank to always sync to the most recent date.
  12. For Region, select your Mixpanel project’s region: US or EU.
  13. For Date slicing window, enter the number of days in each request window. The default is 30 days. Reduce this value if large data volumes per window cause memory issues.
  14. For Page Size, enter the number of Engage stream records to fetch per request. The default is 1000.
  15. For Export Lookback Window, enter the incremental Export stream lookback period in seconds. The lookback starts from the last synced timestamp. It helps prevent missed data caused by event recording delays. The default is 0 seconds.
  16. For Number of concurrent threads, enter the number of worker threads for the sync. The default is 3. Higher values may improve performance but remain constrained by your Mixpanel plan’s rate limits.
  17. Click Set up source.

Supported sync modes

The Mixpanel source connector supports these sync modes:

:::note Incremental syncs may return duplicate records for the state date. This happens because Mixpanel API filters only support whole-day granularity. :::

Supported streams

StreamSync modePrimary key
ExportIncrementalUser-defined (see below)
EngageIncrementaldistinct_id
FunnelsIncrementalfunnel_id, date
AnnotationsFull Refreshid
CohortsIncrementalid
Cohort MembersIncrementaldistinct_id, cohort_id

Export stream primary key

The Export stream has no default primary key. Mixpanel recommends combining insert_id, time, event and distinct_id as the primary key. Some rows may not include an insert_id. Check that your chosen key combination uniquely identifies your data.

Performance

Mixpanel applies separate rate limits to different API endpoints:

  • Query API (Cohorts, Engage, Funnels, Annotations, Cohort Members): 5 concurrent queries and 60 queries per hour.
  • Raw Data Export API (Export): 100 concurrent queries, 60 queries per hour and 3 queries per second.

Large date windows may take longer to sync because of these rate limits. Adjust Date slicing window and Number of concurrent threads to tune performance within your plan’s limits.

Limitations

The Mixpanel source connector supports the US and EU data residency regions. It doesn’t support Mixpanel’s India data residency endpoints.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
4.0.32026-11-0390931Raise the minimum supported Python version to 3.11
4.0.22026-10-1989045Fix crash when the Mixpanel API responds with a Retry-After header during rate limiting
4.0.12026-07-0281392Bump h11 0.14.0 to 0.16.0 to resolve GHSA-vqfr-h8mv-ghfj
4.0.02026-05-2278271Removed the Revenue stream because Mixpanel no longer provides a documented or working revenue Query API endpoint.
3.6.32026-04-1376276Rename “concurrent workers” to “concurrent threads” in connector spec
3.6.22026-04-0376039Replace deprecated MessageRepresentationAirbyteTracedErrors with AirbyteTracedException in tests
3.6.12025-08-0264298Update dependencies
3.6.02025-07-3064122Promoting release candidate 3.6.0-rc.4 to a main version.
3.6.0-rc.42025-07-1763351Reduce default number of concurrent workers
3.6.0-rc.32025-07-0962845Add back python implementation of export stream
3.6.0-rc.22025-04-1758116Update backoff strategy
3.6.0-rc.12025-04-1455189Update airbyte-cdk, set up concurrency
3.5.42025-04-1257893Update dependencies
3.5.32025-04-0557101Update dependencies
3.5.22025-03-2956663Update dependencies
3.5.12025-03-2255429Update dependencies
3.5.02025-03-1055673Add Export Lookback Window
3.4.212025-03-0655224Migrate streams to latest endpoint
3.4.202025-03-0154769Update dependencies
3.4.192025-02-2254319Update dependencies
3.4.182025-02-1553852Update dependencies
3.4.172025-02-0152787Update dependencies
3.4.162025-01-2552261Update dependencies
3.4.152025-01-1151216Update dependencies
3.4.142025-01-0450891Update dependencies
3.4.132024-12-2850596Update dependencies
3.4.122024-12-2150095Update dependencies
3.4.112024-12-1449249Starting with this version, the Docker image is now rootless. Please note that this and future versions will not be compatible with Airbyte versions earlier than 0.64
3.4.102024-12-1248948Update dependencies
3.4.92024-11-0447098Update dependencies
3.4.82024-10-1246792Update dependencies
3.4.72024-10-0546428Update dependencies
3.4.62024-09-2845747Update dependencies
3.4.52024-09-1445473Update dependencies
3.4.42024-09-0745264Update dependencies
3.4.32024-08-3145059Update dependencies
3.4.22024-08-2444643Update dependencies
3.4.12024-08-1744274Update dependencies
3.4.02024-07-1641969Update to v4 CDK
3.3.32024-08-1043575Update dependencies
3.3.22024-08-0343182Update dependencies
3.3.12024-07-2742391Update dependencies
3.3.02024-07-1541754Add engage page size to configuration
3.2.42024-07-1341754Update dependencies
3.2.32024-07-1041420Update dependencies
3.2.22024-07-0941289Update dependencies
3.2.12024-07-0640806Update dependencies
3.2.02024-06-2640607Make engage stream really incremental
3.1.52024-06-2640549Migrate off deprecated auth package
3.1.42024-06-2540376Update dependencies
3.1.32024-06-2240138Update dependencies
3.1.22024-06-1838710Update authenticator CDK package
3.1.12024-06-0439006[autopull] Upgrade base image to v1.2.1
3.1.02024-05-3038757change format for start_date and end_date from date to date-time
3.0.02024-05-2238066Changed key to distinct_id, cohort_id and changed state to per-patition format for CohortMembers stream; fixed pagination for Engage stream; fixed incorrect client-side filtering for semi-incremental streams when data comes not in chronological order; semi-incremental Cohorts, CohortMembers and Engage streams with client-side filtering extract records since user provided or default (1 year old) start_date
2.3.12024-05-2038267Replace AirbyteLogger with logging.Logger
2.3.02024-04-1236724Connector migrated to low-code
2.2.22024-04-1936651Updating to 0.80.0 CDK
2.2.12024-04-1236651Schema descriptions
2.2.02024-03-1936267Pin airbyte-cdk version to ^0
2.1.02024-02-1335203Update stream Funnels schema with custom_event_id and custom_event fields
2.0.22024-02-1235151Manage dependencies with Poetry
2.0.12024-01-1134147prepare for airbyte-lib
2.0.02023-10-3031955Delete the default primary key for the Export stream
1.0.12023-10-1931599Base image migration: remove Dockerfile and use the python-connector-base image
1.0.02023-09-2730025Fix type of datetime field in engage stream; fix primary key for export stream.
0.1.412023-09-2630149Change config schema; set checkpointing interval; add suggested streams; add casting datetime fields.
0.1.402022-09-2030090Handle 400 error when the credentials become expired
0.1.392023-09-1530469Add default primary key distinct_id to Export stream
0.1.382023-08-3130028Handle gracefully project timezone mismatch
0.1.372023-07-2027932Fix spec: change start/end date format to date
0.1.362023-06-2727752Partially revert version 0.1.32; Use exponential backoff
0.1.352023-06-1227252Add should_retry False for 402 error
0.1.342023-05-1521837Add “insert_id” field to “export” stream schema
0.1.332023-04-2525543Set should_retry for 104 error in stream export
0.1.322023-04-1125056Set HttpAvailabilityStrategy, add exponential backoff, streams export and annotations add undeclared fields
0.1.312023-02-1322936Specified date formatting in specification
0.1.302023-01-2722017Set AvailabilityStrategy for streams explicitly to None
0.1.292022-11-0218846For “export” stream make line parsing more robust
0.1.282022-10-0617699Fix discover step issue cursor field None
0.1.272022-09-2917415Disable stream “cohort_members” on discover if not access
0.1.262022-09-2817304Migrate to per-stream states
0.1.252022-09-2717145Disable streams “export”, “engage” on discover if not access
0.1.242022-09-2616915Added Service Accounts support
0.1.232022-09-1816843Add stream=True for export stream
0.1.222022-09-1516770Use “Retry-After” header for backoff
0.1.212022-09-1116191Improved connector’s input configuration validation
0.1.202022-08-2215091Improve export stream cursor support
0.1.192022-08-1815739Update titile and description for Project Secret field
0.1.182022-07-2114924Remove additionalProperties field from schemas and specs
0.1.172022-06-0113372Acceptance tests fix, fixing some bugs for beta release
0.1.162022-05-3012801Add end_date parameter
0.1.152022-05-0412482Update input configuration copy
0.1.142022-05-0211501Improve incremental sync method to streams
0.1.132022-04-2712335Adding fixtures to mock time.sleep for connectors that explicitly sleep
0.1.122022-03-3111633Increase unit test coverage
0.1.112022-04-0411318Change Response Reading
0.1.102022-03-3111227Fix cohort id always null in the cohort_members stream
0.1.92021-12-078578Updated titles and descriptions
0.1.72021-12-018381Increased performance for discovery stage during connector setup
0.1.62021-11-258256Deleted date_window_size and fix schemas date type issue
0.1.52021-11-107451Support start_date older than 1 year
0.1.42021-11-087499Remove base-python dependencies
0.1.32021-10-307505Guarantee that standard and custom mixpanel properties in the Engage stream are written as strings
0.1.22021-11-027439Added delay for all streams to match API limitation of requests rate
0.1.12021-09-166075Added option to select project region
0.1.02021-07-063698Created CDK native mixpanel connector
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.