In this article, we'll use our Mixpanel data source to display data from your Mixpanel account on your Geckoboard dashboard.
Create a connection with Mixpanel
When adding your first Mixpanel widget, you'll be asked to create a connection and authenticate your Mixpanel account so that we're able to collect your data and display it on the dashboard. You only need to create this connection once – we'll take care of the rest.
To connect your Mixpanel account with Geckoboard, follow these steps:
The authentication box will ask you to Name this connection. This will help you distinguish between multiple connections.
You'll then need to enter a Service Account Username and Password. These are required by Geckoboard to access your Mixpanel project. To do this, you'll need to create a Service Account in Mixpanel. Service Accounts are special types of Mixpanel users that can be granted access to projects.
To begin, go to the Project Settings for the project you want connect to Geckoboard.Open the Service Account tab.
Click Add Service Account.
Select a Project Role. Geckoboard doesn't require a specific role to connect.
Copy and paste your Service Account Username and Secret into Geckoboard. You won't be able to access these again after creating your Service Account.
To obtain your Project ID, click the Overview tab.
From the list of project details, copy and paste the Project ID into Geckoboard.
Finally, click on the Connect button and you'll be ready to configure your first Mixpanel widget.
You can connect as many Mixpanel accounts as you need, but you'll only need to authenticate once per account.
Mixpanel metrics we support
Geckoboard supports the following areas of Mixpanel:
Funnels
Retention
Trends
Revenue
Events Number
Show the total, unique or average number of events.Events Line Chart
Show trends for an event or property over time.Trends Bar Chart
Show a breakdown of properties for an event.Top Event Property List
Display a list of the top properties for an event.Retention Column Chart
Show retention trend between two events over time.Funnel
Shows funnel steps with conversion.Funnel Completion Number
Show number of conversions, conversion rate or drop-off rate for a funnel.Funnel Completion Line Chart
Show funnel trends over time.
Note: We use the event names as unique identifiers for Mixpanel events. This means that if multiple events have the same name they'll only be fetched once.
How comparison periods work for Mixpanel widgets
When setting comparison periods for Mixpanel widgets it compares the previous period to "right now".
For example, when comparing the past 7 days to the previous 7 days, we want to be comparing the data right now to what it was right now 7 days ago.
Data history limits on free and startup plans
Mixpanel’s free and startup plans have set data history limits. If you're on their free plan, any time ranges and comparison periods you set must be equal to, or less than, 60 days. For startup plan customers, this is set to 12 months.
Example Mixpanel widget configurations
Configuring an example Trends Number widget
The Trends Number widget displays the count for a specific event or property in a specific period with optional comparison period.
We can use the Trends Number widget to show the number of people who have added Custom CSS to their dashboards using Chrome during the last 7 days, and compare it to the same period last month.
The setup screen of the widget will look like this:
Configuring an example Funnel Completion Rate Line Chart widget
The Funnel Completion Rate Line Chart widget helps us visualize the completion rate of a funnel over time as a Line Chart.
We can use the Funnel Completion Rate Line Chart widget to visualize the number of customers who are completing the funnel 'Adding Widgets' in the last 45 days, and compare this to last year's same time interval. The goal is to have 100 customers per day completing the funnel.
The shaded area represents our goal of 100 customers that have completed the funnel.
The setup screen of the widget will look like this: