Skip to main content

Mixpanel

Availability
Available CoreAvailable StandardAvailable PlusAvailable ProAvailable Enterprise FlexAvailable Self-Managed EnterpriseAvailable PyAirbyte
Support Level
Marketplace
Connector Version
3.6.3 (last updated 23 days ago)
CDK Version
6.45.0
Definition ID
12928b32-bf0a-4f1e-964f-07e12e37153a

This page contains the setup guide and reference information for the Mixpanel source connector.

Prerequisites​

To set up the Mixpanel source connector, you need:

  • A Mixpanel Service Account with access to your project. You need the service account username and secret.
  • Your Project ID, found in your Mixpanel project settings.
  • Your Project Timezone, found in your Mixpanel project settings.
  • Your project's data residency region (US or EU).
note

The connector also supports Project Secret authentication, but 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 Mixpanel connector in Airbyte​

  1. Log into your Airbyte Cloud or navigate to the Airbyte Open Source dashboard.
  2. Click Sources and 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 from the dropdown and enter your service account Username and Secret.
  6. For Project ID, enter your Mixpanel Project ID.
  7. For Attribution Window, enter the number of days for the attribution window. The default is 5 days.
  8. For Project Timezone, enter the timezone for your Mixpanel project. The default is US/Pacific.
  9. For Select Properties By Default, leave enabled to capture new properties on events and Engage records automatically. Disable to ignore new properties.
  10. For Start Date, enter the date in YYYY-MM-DD format. Data on and after this date is replicated. If left blank, the connector replicates data from up to one year ago by default.
  11. For End Date, optionally enter a date in YYYY-MM-DD format. Data after this date is not replicated. Leave blank to always sync to the most recent date.
  12. For Region, select the region for your Mixpanel project (US or EU).
  13. For Date slicing window, enter the number of days per request window. The default is 30 days. Reduce this value if you encounter memory issues due to large volumes of data per window.
  14. For Page Size, enter the number of records to fetch per request for the Engage stream. The default is 1000.
  15. For Export Lookback Window, enter the number of seconds to look back from the last synced timestamp during incremental syncs of the Export stream. This helps avoid missed data due to delays in event recording. The default is 0 seconds.
  16. For Number of concurrent workers, enter the number of worker threads for the sync. The default is 3. Higher values may improve performance but are constrained by your Mixpanel plan's rate limits.
  17. Click Set up source.

Supported sync modes​

The Mixpanel source connector supports the following sync modes:

note

Incremental syncs may return duplicate records for the state date because the Mixpanel API filters are granular to the whole day only.

Supported streams​

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

Primary key for the Export stream​

The Export stream has no default primary key. Mixpanel recommends using insert_id, time, event, and distinct_id together as the primary key. Some rows may lack an insert_id, so verify that your chosen key combination uniquely identifies your data.

Performance considerations​

Mixpanel enforces separate rate limits for different API endpoints:

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

Syncing large date windows may take longer due to these rate limits. You can adjust the Date slicing window and Number of concurrent workers settings to tune performance within your plan's limits.

Reference​

Config fields reference

Field
Type
Property name
object
credentials
integer
attribution_window
integer
date_window_size
string
end_date
integer
export_lookback_window
integer
num_workers
integer
page_size
string
project_timezone
string
region
boolean
select_properties_by_default
string
start_date

CHANGELOG​

Expand to review
VersionDatePull RequestSubject
3.6.22026-04-0376039Replace deprecated MessageRepresentationAirbyteTracedErrors with AirbyteTracedException in tests
3.6.32026-04-1376276Rename "concurrent workers" to "concurrent threads" in connector spec
3.6.22026-04-0276039Replace 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
Was this page helpful?