Display Mixpanel metrics in Geckoboard

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:

  1. The authentication box will ask you to Name this connection. This will help you distinguish between multiple connections.
  2. 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.
  3. Open the Service Account tab.service account tab on Mixpanel's project settings menu
  4. Click Add Service Account.
  5. Select a Project Role. Geckoboard doesn't require a specific role to connect.Add a service account in Mixpanel
  6. 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.copy and paste your new service account username and secret into Geckoboard
  7. To obtain your Project ID, click the Overview tab.
  8. From the list of project details, copy and paste the Project ID into Geckoboard.copy and paste your project ID into Geckoboard
  9. 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.Trends_Number_Widget.png

The setup screen of the widget will look like this:

Trends_Number_Setup.png

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.Funnel_Line_Widget.png

The shaded area represents our goal of 100 customers that have completed the funnel. 

The setup screen of the widget will look like this:

Funnel_Line_Setup.png

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.