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.