In this article, we'll use our Mixpanel data source to display data from your Mixpanel account on your Geckoboard dashboard.
A paid Mixpanel plan is required to access Mixpanel data within Geckoboard.
Step 1: Create a service account in Mixpanel
Geckoboard requires a service account to access your Mixpanel project. Service Accounts are special types of Mixpanel users that can be granted access to projects.
In Mixpanel, go to the Project Settings for the project you want to 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.
Note your Service Account Username and Secret. After creating your service account, you won't be able to access these again.
Step 2: Create a connection with Mixpanel
In Geckoboard, add a new Mixpanel widget to your dashboard.
Name the connection in the configuration panel.
Next, using the credentials created in step 1, enter your Service Account Username and Secret.
Enter your Project ID.
You can find this in Mixpanel within the Overview tab of your Project's settings. From the list of project details, copy and paste the Project ID into Geckoboard.
Click the Connect button.
Mixpanel metrics supported in Geckoboard
Geckoboard supports the following areas of Mixpanel:
Funnels
Retention
Trends
Revenue
Events Number: Shows the total, unique or average number of events.
Events Line Chart: Shows trends for an event or property over time.
Trends Bar Chart: Shows a breakdown of properties for an event.
Top Event Property List: Displays a list of the top properties for an event.
Retention Column Chart: Shows the retention trend between two events over time.
Funnel: Shows funnel steps with conversion.
Funnel Completion Number: Shows the number of conversions, conversion, or drop-off rates for a funnel.
Funnel Completion Line Chart: Shows 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.
Example Mixpanel widget configurations
Events Number widget
We can use the Events Number widget to show the number of people who signed up for a product during the last 7 days and compare it to the same period.
Example widget configuration
Funnel Completion Rate Line Chart widget
We can use the Funnel Completion Rate Line Chart widget to visualize the number of customers completing the funnel 'Page viewed -> Signup' in the last 31 days and compare this to the last 31 days.
Example widget configuration
