Get valuable insights into your product analytics by connecting your Mixpanel account to Power My Analytics. This guide will walk you through setting up Mixpanel as a data source and creating reports to track your funnels, conversion rates, and time-to-convert velocity.

Prerequisites

Before connecting Mixpanel to Power My Analytics, ensure you have:

• An active Mixpanel account with at least one project
• A Mixpanel Service Account (username and secret)
• Your Mixpanel Project ID

Find Your Mixpanel Service Account Credentials

Mixpanel authenticates with a Service Account rather than a standard sign-in. You will create the Service Account in Mixpanel and enter its credentials in Power My Analytics when adding Mixpanel as a data source.

• Create a Service Account under Organization Settings > Service Accounts in Mixpanel, then copy the Service Account Username and Service Account Secret.
• Find your Project ID under Project Settings in Mixpanel.

Your Mixpanel Service Account secret is shown only once, at the moment you create the Service Account. Copy it right away and store it somewhere safe. If you lose it, simply create a new Service Account in Mixpanel.

Adding Mixpanel as a Data Source

1. Go to your Power My Analytics hub and select Sources from the main menu.
2. Click + Add new source and choose Mixpanel from the gallery of data sources.
3. Enter your Service Account Username, Service Account Secret, and Project ID.
4. Click Connect to authenticate and finish adding your Mixpanel account as a data source.

For step-by-step connection instructions, see How to Connect to Mixpanel.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your Mixpanel data:

1. In the PMA hub, navigate to Reports > Data Studio.
2. Select Mixpanel under Create Data Studio Report (this will open the official Data Studio application in a new window).
   • Step 1: Name your data source (e.g., "Mixpanel - Business Name"); choose your PMA hub from the Power My Analytics Hub dropdown; under Projects to report, select your Mixpanel Project ID (you can select more than one); optionally allow "Projects" to be modified in reports; optionally leave "Use report template for new reports" checked to use the PMA demo template; then click Next.
   • Step 2: Under User Account, select your Mixpanel account (for real data) or "Sample Account" (for sample data), then click Next.
   • Step 3: Click Connect (top right) to complete the data source configuration.
   • Step 4: Click Create Report (top right).

You can also start from the ready-made Mixpanel Data Studio demo template.

Key Reports and Fields

The Mixpanel connector provides access to your product analytics through the Funnels table, including:

• Key Performance Metrics: Funnel Starting Amount, Funnel Completion Ratio, Overall Conversion Ratio, and Average Time From Start, plus Count by Step Label
• Funnel Metrics: Funnel Starting Amount, Funnel Completion Ratio, and Overall Conversion Ratio by Funnel Name; Step Conversion Ratio by Step Label; and Count, Step Conversion Ratio, Overall Conversion Ratio, and Average Time From Start by Step Index, Step Label, and Event
• Time to Convert Velocity Metrics: Average Time by Step Label, Average Time From Start by Step Label, and Average Time From Start trended over time
• Multi-Funnel Comparison Metrics: Funnel Completion Ratio by Funnel Name, Funnel Starting Amount by Funnel Name, and Funnel Starting Amount, Funnel Completion Ratio, and Overall Conversion Ratio by Funnel Name

For a full list of available Mixpanel fields in Power My Analytics, visit the Schema Explorer.

Limitations and Important Considerations

• Backfilling: Up to 366 days (1 year) of historical data. PMA pulls approximately 6 months of history when you first connect your Mixpanel account, so your reports are not starting from scratch. To extend coverage up to the 366-day maximum, run a manual backfill from Sources > Action > Backfill data range.
• Supported tables: The Mixpanel connector currently provides the Funnels table; other Mixpanel reports are not yet available.
• Beta connector: The Mixpanel connector is currently in beta. If you spot anything unexpected, we would love to hear from you.

Unavailable Data

If there are additional Mixpanel fields or reports you would like to see in Power My Analytics, let us know at beta@powermyanalytics.com.

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the Mixpanel connector.