Data Analysis & SQL
2012-2014 - Hailo (ridesharing app)
Hailo was a small startup without many pre-existing dashboards for reporting on marketing campaigns. As such, I stepped in to become the North America marketing team's go-to data person. I taught myself basic SQL to define customer segments and pull reports, combining data from Hailo’s internal database with other sources (i.e. Mixpanel, Google Analytics, TW/FB ads) to create easy-to-read dashboards and reports. It was surprisingly fun!
A few queries I relied on:
Weekly active passengers - for general reporting.
Inactive drivers - to target reactivation messages.
“Twitter totals” - cost per acquisition, from a click on a promoted tweet through first completed ride.
“PROMO HOUNDS” - users whose behavior suggested abuse of promo codes, to help identify and stop fraud.
Skills: Mixpanel, Google Analytics, bit.ly, SQL, Excel.