Mixpanel

Connect Querri to Mixpanel and ask questions about your product events, users and retention in plain language.

Overview

The Mixpanel connector uses a Mixpanel service account to read one project, and copies its data into Querri. Each kind of Mixpanel data becomes a source in your Library. It’s listed under Analytics.

Setup

Before you start

• A Mixpanel service account with access to the project. Service accounts live in Mixpanel under Organization Settings > Service Accounts. Copy the secret when you create it: Mixpanel shows it only once.
• The project’s URL. Open any page in the project and copy the address from your browser.

Connecting to Mixpanel

1. Open the connector. Click Connect in the app rail and pick Mixpanel in Add data, or click Connect on Mixpanel in Settings → Connectors (admins).

2. Enter your details:

   Field	What to enter
   Service Account Username	The service account’s username
   Service Account Secret	The secret you copied when you created the service account. If you’ve lost it, create a new service account
   Project URL	Any URL from inside the project. Querri reads the project ID from it and shows “Project ID {id} detected”

3. Save. Click Save. There’s no separate test step: Querri checks the credentials with Mixpanel first, and creates the connector only if they work. If they don’t, nothing is saved and the dialog shows the reason. When it works, the dialog closes and you’ll see “Mixpanel connected”.

4. Load your data. Open the connector in the Library by clicking it under Connectors in the browse panel. If nothing has loaded yet, you’ll see “Mixpanel is connected, but no data has loaded yet.” Click Load data now. Only the connector’s owner can start a load.

1. Service Account Username: which service account Querri signs in with.
2. Project URL: paste a project URL, and Querri finds the project ID in it.

Caution

Pressing Enter anywhere in the connector dialog saves it.

What syncs

The first load brings in all of these:

Data	What it holds
Events	Raw event data exported from the project
User Profiles	User profiles with their properties
Cohorts	Cohort definitions and membership
Retention	User retention over time
Insights	Top events by total count

Events and retention cover the last 30 days. Each sync fetches the most recent 30 days, not the project’s full history.

Keeping data fresh

The connector’s owner can set a schedule on its Schedule tab. Mixpanel doesn’t support incremental syncs, so use Full Refresh. A daily schedule keeps the 30-day window rolling forward.

Scheduled syncs use credits when they run; syncs you start by hand don’t. See Sync Scheduling and Credits.

Troubleshooting

”Couldn’t find a project ID in that URL”

Copy the URL from a page inside your Mixpanel project, such as a report, rather than from the organization settings.

The credentials are rejected

Check the service account’s username and secret. If you don’t have the secret any more, create a new service account in Mixpanel and use its secret. Make sure the service account can access the project.

Older events are missing

Querri fetches the last 30 days of events. Older events won’t appear.

Syncs take a long time

Mixpanel limits how often its query API can be called, and Querri waits between requests to stay within those limits.

Security & permissions

• Service account, not a person’s login. Querri connects with a service account you manage in Mixpanel, not with anyone’s own username and password.
• One project. The connector reads only the project in the URL you gave it.
• Querri keeps a copy. Synced data is stored in Querri. Disconnecting deletes the data the connector synced.
• Sharing the connector is up to its owner, on the connector’s Sharing tab.

Next Steps

• Sync Scheduling: full refresh schedules
• Managing Connections: change, refresh and remove connectors
• Data Connectors Overview: every connector Querri offers