Connecting to Mixpanel

Authentication

To authenticate to Mixpanel and access your analytics data, use Basic authentication with your Mixpanel service account credentials.

Using Basic Authentication

To connect to Mixpanel using Basic authentication, you will need your Mixpanel service account credentials. These can be obtained from your Mixpanel organization settings under Service Accounts.

After setting the following connection properties, you are ready to connect:

AuthScheme: Set this to Basic.
User: Set this to your Mixpanel service account username.
Password: Set this to your Mixpanel service account secret.
Domain: Set this to your regional endpoint (default: mixpanel).

Example connection string

Profile=C:\profiles\Mixpanel.apip;ProfileSettings="Domain=mixpanel";AuthScheme=Basic;User=your_user_name;Password=your_password;

Available Tables

The Mixpanel API Profile provides access to comprehensive analytics and event data across 28 specialized tables:

Events - Access event data analysis with date aggregations and time series data.
EventActivity - Query specific event activity records and details.
EventProperties - Access event property definitions and metadata.
Segmentation - Retrieve event segmentation analysis with property breakdowns.
SegmentationAverage - Query average value segmentation data.
SegmentationBucket - Access bucket-based segmentation analysis.
SegmentationSum - Query sum value segmentation data.
FrequencyReport - Query frequency of actions report for retention analysis.
Funnels - Access funnel analysis data with step-by-step conversions.
FunnelsList - Query available funnel definitions and metadata.
Insights - Access custom insights and saved query results.
Cohorts - Query user cohort definitions and membership data.
FeatureFlags - Access feature flag definitions and configurations.
FeatureFlagAssignments - Query feature flag assignment data for users.
Annotations - Access timeline annotations and event markers.
AnnotationTags - Query annotation tag definitions and categories.
LexiconSchemas - Access data schema definitions and structure.
LexiconSchemasByEntity - Query schemas organized by entity type.
LexiconSchemaByEntityName - Access schemas by specific entity names.
LookupTable - Query lookup table data for enrichment.
PipelineJobs - Access data pipeline job definitions and status.
PipelineLogs - Query pipeline execution logs and debugging data.
PipelineStatus - Access pipeline health and execution status.
ServiceAccounts - Query service account definitions and permissions.
ProjectServiceAccounts - Access project-specific service account data.
GDPRDeletions - Query GDPR data deletion requests and status.
GDPRRetrievals - Access GDPR data retrieval requests and results.
TodayTopEvents - Query today's top performing events.

Usage Examples

Event Analysis

Query event data with required parameters:

SELECT * FROM Events
WHERE ProjectId = 123456
  AND Event = 'page_view'
  AND Type = 'general'
  AND Unit = 'day'
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'

Query event activity records:

SELECT * FROM EventActivity 
WHERE ProjectId = 123456
    AND FromDate = '2024-01-01'
    AND ToDate = '2024-01-31'
    AND DistinctIds = '12345'

Query event properties:

SELECT * FROM EventProperties 
WHERE ProjectId = 123456
    AND FromDate = '2024-01-01'
    AND ToDate = '2024-01-31'
    AND Event = 'page_view'
    AND Type = 'general'
    AND Unit = 'day'
    AND Name = 'purchase'

Segmentation Analysis

Query event segmentation with required parameters:

SELECT * FROM Segmentation
WHERE ProjectId = 123456
  AND EventName = 'purchase'
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'

Query segmentation averages:

SELECT * FROM SegmentationAverage
WHERE ProjectId = 123456
  AND EventName = 'purchase'
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'
  AND OnProperty = 'properties.amount'

Query segmentation sums:

SELECT * FROM SegmentationSum
WHERE ProjectId = 123456
  AND EventName = 'revenue'
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'
  AND OnProperty = 'properties.amount'

Frequency Reports

Query frequency report for retention analysis:

SELECT * FROM FrequencyReport
WHERE ProjectId = 123456
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'
  AND Unit = 'day'
  AND AddictionUnit = 'day'

Funnel Analysis

Query funnel data with required parameters:

SELECT * FROM Funnels
WHERE ProjectId = 123456
  AND FunnelId = 987654
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'

Query available funnels:

SELECT * FROM FunnelsList WHERE ProjectId = 123456

Cohort Analysis

Query cohort data:

SELECT * FROM Cohorts WHERE ProjectId = 123456

Feature Flags

Query feature flag definitions:

SELECT * FROM FeatureFlags WHERE ProjectToken = 'abc123def456'

Query feature flag assignments:

SELECT * FROM FeatureFlagAssignments WHERE ProjectToken = 'abc123def456'

Annotations

Query annotations with date range:

SELECT * FROM Annotations
WHERE ProjectId = 123456
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'

Query annotation tags:

SELECT * FROM AnnotationTags WHERE ProjectId = 123456

Schema and Data Structure

Query lexicon schemas:

SELECT * FROM LexiconSchemas WHERE ProjectId = 123456

Query schemas by entity type:

SELECT * FROM LexiconSchemasByEntity
WHERE ProjectId = 123456
  AND EventType = 'events'

Query lookup table data:

SELECT * FROM LookupTable
WHERE ProjectId = 123456

Pipeline Management

Query pipeline jobs:

SELECT * FROM PipelineJobs WHERE ProjectId = 123456

Query pipeline execution logs:

SELECT * FROM PipelineLogs
WHERE ProjectId = 123456
  AND Name = 'daily_import'

Query pipeline status:

SELECT * FROM PipelineStatus
WHERE ProjectId = 123456
  AND Name = 'daily_import'

Account Management

Query service accounts:

SELECT * FROM ServiceAccounts
WHERE OrganizationId = 123456

Query project service accounts:

SELECT * FROM ProjectServiceAccounts WHERE ProjectId = 123456

Insights and Reports

Query saved insights:

SELECT * FROM Insights
WHERE ProjectId = 123456
  AND BookmarkId = 789456

Query today's top events:

SELECT * FROM TodayTopEvents
WHERE ProjectId = 123456
  AND Type = 'events'

Bucket Segmentation Analysis

Query bucket-based segmentation analysis:

SELECT * FROM SegmentationBucket
WHERE ProjectId = 123456
  AND EventName = 'purchase'
  AND FromDate = '2024-01-01'
  AND ToDate = '2024-01-31'
  AND OnProperty = 'properties.amount'

Entity-Specific Schema Queries

Query schema by specific entity name:

SELECT * FROM LexiconSchemaByEntityName
WHERE ProjectId = 123456
  AND EntityName = 'purchase'
  AND EventType = 'events'

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

Property	Description
AuthScheme	The scheme used for authentication. Accepted entries are Basic or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT
Domain	Determines the domain where API calls will be sent to for regional data residency. Allowed values are: MIXPANEL, EU.MIXPANEL, IN.MIXPANEL, COM, EU, COM.AU, IN