Extract data from Mixpanel API

 

mixpanel-postAthough I love Mixpanel, there are cases that you would like to extract data from it. Then load your data to a data warehouse like Amazon Redshift for further analysis. This post is a small overview off Mixpanel’s API and how to access and extract data from it. purpose of this guide is to help you define a process or pipeline .

About Mixpanel

For those that do not know Mixpanel, it helps you make your product better by measuring actions, instead of page views. Mixpanel gives you the ability to measure what people are doing in your app on iOS, Android, and web.

Extract data from Mixpanel

Mixpanel is an analytics as-a-service application. We usually think of it as place to see my data and not a place where I would get data from. Why? I may need to perform analysis that involves data from other sources.

Mixpanel collects data related to how your customers use your product. In case you need to have more sources you may:

  1. Enrich Mixpanel with data coming from other sources.
  2. Extract the data Mixpanel holds for you and load it on a data warehousing repository. This is what we are going to review here.

Continue reading

Advertisements