How to Export Raw Mixpanel Data to Your Database

February 23, 2018

Mixpanel is great, but it’s very helpful to have your raw event data in your database so you can use SQL to extract insights. In this post, I’ll show you how you can accomplish that. We’ll be using Ruby on Rails and PostgreSQL, but the general approach of pulling data from Mixpanel, inserting it into the database, and scheduling a background job on an interval should work with any language and database.

Read More