This guide contains all permissions and requirements for connecting your Mixpanel data to Supermetrics.
You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.
After you connect to the data source on the Hub, you can use the data source connection in the available destinations.
Required permissions
A Mixpanel service account is required to query the data in Supermetrics, and you must identify which Data Residency your Mixpanel project uses.
How to find your project's Data Residency
- Log in to your Mixpanel Dashboard.
- In the bottom left corner, click the cogwheel icon. Hover over Settings and select Project settings.
- In the Project Details table, the Data Residency will be visible.
How to create a service account
- Log in to your Mixpanel Dashboard.
- In the bottom left corner, click the cogwheel icon. Hover over Settings and select Project settings.
- Select Service accounts from the navigation menu on the left side.
- In the top right corner, click Add service account.
- Enter a name for your new service account, for example "Supermetrics".
- Select Consumer as the Project role.
- Click Add.
- Copy the Service account name and Service account secret to a secure location.
Learn more about service accounts in Mixpanel's documentation.
Query types
If prompted, you need to select a query type to pull data.
- Events: Get event data to track interactions between a user and your product.
Connection instructions
When connecting to Mixpanel, you need to provide your account name and secret and select the data residency to use.
- Select the Mixpanel data source on the Supermetrics Hub or in the data destination.
- Select the Data residency of your Mixpanel Project.
- Enter your Mixpanel service account name and secret.
- Give your login a name to recognize the login later in case you have multiple logins.
- If prompted, choose to make this connection shared or private.
- Click Start.
- In your data destination, select the data residency and a query type to use in your report, if prompted.
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Mixpanel from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer