Data Analysis & SQL
2012-2014 - Hailo (ridesharing app)
As a young startup, Hailo didn’t have easy-to-read marketing dashboards; 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 reporting from other sources (i.e. Mixpanel, Google Analytics, TW/FB ads) to create reports for the marketing team. It was surprisingly fun!
A few sample queries I wrote and used regularly:
Active passengers - for general reporting.
Inactive drivers - to target re-engagement campaigns.
“Twitter totals” - cost per acquisition, from a click on a Twitter ad 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.