Mixpanel is a business analytics platform. It tracks user interactions with web and mobile applications and provides tools for targeted communication with them.

Its toolset contains in-app A/B tests and user survey forms. Data collected is used to build custom reports and measure user engagement and retention. Mixpanel works with web applications, in particular SaaS, but also supports mobile apps.

Connecting to Mixpanel API

Mammoth allows you to connect to Mixpanel API and get the data into Mammoth.

  1. Select API & Databases from the add menu and click on Mixpanel.

    Mixpanel selection
  2. Click on New Connection and enter your API secret key, project timezone and name.

    Mixpanel login
  3. Select the account and click on Next.

    Mixpanel profile

Once your Mixpanel account is connected with Mammoth, you will be presented with a list of metrics in that database.

  • Select the metrics you want to add to your Dataset.

  • Click on Next .

    Mixpanel profile

After you have selected metrics, you get options to configure it as follows -

  • Rename it in the data pull scheduling window.

  • Save it in a desired location in the Data Library from Adding file to option.

Scheduling your Data Pulls

You can start retrieving the data now or at a specific time according to your choice. You can specify the starting date and end date of data retrieval. By default, starting date is set to present date and end date is set to the latest data available.

You can also schedule the data pull in order to get the latest data from your Database at a certain time interval - daily, weekly or monthly.

On every data pull from your Database, you also have an option to either replace the older data or combine with older data.

Mixpanel data pull

On choosing Combine with older data option, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.