analyzing mixpanel data with sql
TRANSCRIPT
![Page 1: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/1.jpg)
Analyzing Mixpanel Data With SQL
![Page 2: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/2.jpg)
● Shaun will lead Q&A at the end of the presentation
● Tag your tweets with #mixpanelsql
● We’re recording the show
● We’ll send an email follow up to everyone with the recording & slides
● Stick around for the cupcake giveaway at the end
Details
![Page 3: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/3.jpg)
How analysts can build a lean data stack that will take them from consolidation to visualization
The quickest way to start running SQL queries on raw Mixpanel data
What you’re going to learn
1
2
3 Examples of the rich insights you can uncover when analyze the data about your users' interactions alongside data from your other sources
![Page 4: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/4.jpg)
Who’s presenting?
Shaun McAvinneyLead Sales Engineer
RJMetrics
@Smcavinney
Andy GranowitzEngineer
Wagon
@agrano
![Page 5: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/5.jpg)
Intro to Wagon
Wagon is a modern SQL editor: write SQL, analyze data, and share charts.
![Page 6: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/6.jpg)
Intro to Pipeline
![Page 7: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/7.jpg)
A quick introduction and explanation of Mixpanel
![Page 8: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/8.jpg)
Mixpanel
![Page 9: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/9.jpg)
3 Methods for Analyzing Mixpanel Data
![Page 10: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/10.jpg)
Poll question
How does your company analyze Mixpanel data today?
1. Mixpanel’s in-app reporting2. Writing JQL queries inside the MIxpanel interface3. Loading the data into a data warehouse for analysis4. Other
![Page 11: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/11.jpg)
1. Mixpanel reports
![Page 12: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/12.jpg)
2. JQL queries
![Page 13: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/13.jpg)
3. The best way to do this
![Page 14: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/14.jpg)
3. The best way to do this
![Page 15: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/15.jpg)
All your data in one place
![Page 16: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/16.jpg)
Mixpanel + SQL
![Page 17: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/17.jpg)
Connecting Wagon
![Page 18: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/18.jpg)
Examples
Using Mixpanel data, we can analyze:
1. Events over time2. Events over time grouped by event type 3. Events over time, grouped by monthly cohort4. 30-day active users 5. 30-day active users by monthly cohort
![Page 19: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/19.jpg)
Events over time
![Page 20: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/20.jpg)
Events over time
![Page 21: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/21.jpg)
Events over time grouped by event type
![Page 22: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/22.jpg)
Events over time grouped by event type
![Page 23: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/23.jpg)
Events over time, grouped by monthly cohort
![Page 24: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/24.jpg)
Events over time, grouped by monthly cohort
![Page 25: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/25.jpg)
30-day active users
![Page 26: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/26.jpg)
30-day active users
![Page 27: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/27.jpg)
30-day active users by monthly cohort
![Page 28: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/28.jpg)
30-day active users by monthly cohort
![Page 29: Analyzing Mixpanel Data with SQL](https://reader034.vdocuments.us/reader034/viewer/2022052405/586fddb51a28ab18428b68d7/html5/thumbnails/29.jpg)
Data Source