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?
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 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.
Athough 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 .
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:
- Enrich Mixpanel with data coming from other sources.
- Extract the data Mixpanel holds for you and load it on a data warehousing repository. This is what we are going to review here.
Two months ago, as Apirise, we attended APIdays in Berlin. APIdays is a conference held in cities like Barcelona, Berlin, Moscow, Paris, San Francisco and Tokyo. The range of topics covered is really wide and include almost everything about APIs. In APIdays you may meet with vendors, developers, companies like Apigee, Facebook, Heroku, Intel, Netflix, Salesforce, Soundcloud, Stripe, Twitter, Zappier and people like Kin Lane or Mike Amundsen to mention only a few… you got the idea.
There is a big trend of API awareness and creating thriving communities that is being supplemented by regional efforts like the NordicAPIs. This creates a parallel networking effect that works in the background. For example, we met with people from Greece that we didn’t know before, but they participated in APIdays Barcelona or older APIdays conferences.
We spoke with them and we saw that there is common ground and will to create a similar community in Greece.
For this reason we created the API Athens Meetup. We start small and expect to «hear» the vibe of the local community. We want to make it a place where we all learn, exchange real life experience, have conversations with startups, companies and developers and hear the challenges they face in getting the word out about APIs in their context of work.
On June 25th we had our kickoff meetup.
Wow what a ride it’s been, after tons of pitching, phone calls, iterations, updates, meetings, coffees and beers, we are overjoyed to announce that we are going live with our private beta of Apirise and the first invites are out of the door.
This is my most recent venture. As this is only a beta and we are still testing, trying stuff (and breaking too), we seek early adopters who:
- Want to use our platform
- Have a small idea what an API is
- Are willing to send us feedback and work with us with making a better product that will provide value to them.
OK George but what is Apirise?
Today developers are using multiple APIs for their applications. That number will keep increasing in the next few years with the wide adoption of wearable devices, IoT, M2M and the likes. The use of so many APIs creates a lot of dependencies and increases complexity. For this reason as developers ourselves we wanted to make our job easier, faster and cleaner.
With Apirise you do not have to waste your precious development resources and time. Integrating APIs and maintaining them can be much simpler.
Apirise was built to help you work with and integrate multiple APIs. Simply, fast and efficiently!