Mixpanel Connection

The Mixpanel connection integrates your Mixpanel project with OpsTower, giving agents access to event analytics data including event trends, funnels, retention cohorts, and segmentation breakdowns. Once connected, you can use Mixpanel data in scheduled reports and in agent chat queries.

Prerequisites

You need a Mixpanel account with access to the project you want to connect. You will also need the ability to create Service Accounts in your Mixpanel organization settings.

Credentials Required

To set up a Mixpanel connection, you need three pieces of information:

• Service Account Username — the username for a Mixpanel Service Account
• Service Account Secret — the secret for the Service Account (shown only at creation time)
• Project ID — the numeric identifier for the Mixpanel project to query

You also need to select your Data Residency Region (United States, Europe, or India) to match where your Mixpanel data is stored.

How to Create a Mixpanel Service Account

1. Log in to Mixpanel at mixpanel.com.
2. Click the gear icon in the top bar to open Organization Settings.
3. In the left sidebar, click Service Accounts.
4. Click Add Service Account.
5. Give the service account a descriptive name (e.g., “OpsTower”).
6. Select a role with read access to the project you want to connect. A “Viewer” or “Analyst” role is sufficient.
7. Under project access, grant the service account access to the specific project(s) you want to query.
8. Click Create.
9. Copy the Username and Secret immediately — the secret is only shown once and cannot be recovered later.

Store these credentials securely. If you lose the secret, you will need to create a new service account.

How to Find Your Project ID

1. In Mixpanel, click the gear icon and navigate to your project settings.
2. Under the Access Keys section, the Project ID is displayed as a numeric value.

Setting Up the Connection in OpsTower

1. In OpsTower, navigate to Connections in the sidebar.
2. Click Add Connection and select Mixpanel.
3. Enter your Service Account Username, Service Account Secret, and Project ID.
4. Select your Data Residency Region (US, EU, or India) to match where your Mixpanel data is hosted.
5. Optionally, add a Custom Analytics Prompt — additional instructions for how the agent should analyze your Mixpanel data (max 2000 characters). For example, you might specify which events are most important, key funnels to track, or metrics to prioritize.
6. Click Test Connection to verify your credentials are valid.
7. Click Save to create the connection.

What Agents Can Do with Mixpanel

Once connected and enabled on an agent, the agent can:

• Query event segmentation data with daily, weekly, or monthly breakdowns
• List and analyze top events by volume
• Query funnel conversion data for saved funnels
• Analyze retention cohorts to measure user return rates
• Retrieve saved Insights reports
• Generate scheduled analytics reports with trend analysis and anomaly detection

Usage

Mixpanel connections are used in two primary contexts:

• Scheduled Reports — automated analytics summaries delivered on a recurring schedule, covering key metrics, period-over-period comparisons, and detected anomalies.
• Agent Chat — real-time queries during conversations with your agents, where the agent calls Mixpanel’s API to fetch and analyze data on demand.

Data Residency

Mixpanel stores data in region-specific data centers. When setting up your connection, select the region that matches your Mixpanel project’s data residency:

Region	Description
US	United States (default)
EU	European Union
India	India

Using the wrong region will result in authentication errors, since your credentials are scoped to the region where your data is stored.

Rate Limits

Mixpanel’s Query API allows 60 queries per hour and 5 concurrent queries. OpsTower’s daily reports typically make 10-20 queries, which is well within these limits. If you encounter rate limit errors, space out report generation across your connections.

Troubleshooting

• Authentication errors: Verify that your Service Account credentials are correct and the service account has not been deleted. Ensure the selected region matches your Mixpanel project’s data residency.
• Permission errors: Confirm that the Service Account has been granted access to the specific project you are trying to query. Check the role permissions in Mixpanel Organization Settings.
• No data returned: Confirm that the Project ID is correct and the project has recent events ingested.
• Rate limit errors: Mixpanel allows 60 queries per hour. If you have multiple connections generating reports simultaneously, consider staggering their schedules.