How to extract data from Mailchimp API

How to extract data from Mailchimp API

Our favorite email marketing monkey. Mailchimp is the heart of our marketing campaigns. But it generates data and sometimes these data are important to be together with data from services like billing or social. How can you get them and then load them to a data warehouse like Amazon Redshift for further analysis?

About Mailchimp

Mailchimp helps businesses observe their subscribers’ activities, send automated emails to them based on their behavior and preferences, optimize and target the appropriate audience for each campaign using specific tools, and monitor sales and website activity with revenue reports. Companies can add content and collaborate on campaigns that fit their brand using MailChimp’s Email Designer; edit campaigns, collaborate with their teams using MailChimp Editor; send one-to-one messages using Mandrill; collect signups from their tablet using Chimpadeedoo; and access all the services via mobiles using MailChimp Mobile.

About Mailchimp API

[update 18/2] Mailchimp updated its API to v3, for more information visit MailChimp API v3.0 documentation.

mailchimp api

MailChimp was always a promoter of APIs and encouraged integration with other systems. It has a rich API that exposes a large number of endpoints for interacting with the resources of the applications.

Continue reading

Advertisements

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