Data Analysis & SQL
2012-2014 - Hailo (ridesharing app)
As a small, young company, Hailo didn’t have a ton of 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 create customer segments and pull data, combining it with numbers from other sources to create reports for the marketing team. It was fun!
A few queries I wrote and used regularly:
Active passengers - for general reporting.
Inactive drivers - to target re-engagement campaigns.
“Twitter totals” - cost per acquisition, all the way from a click on a Twitter ad through first completed ride.
“CODE HOUNDS” - users who took advantage of a particular promotion to unfairly give themselves large amounts of ride credit.
Skills: Mixpanel, Google Analytics, bit.ly, SQL, Excel.