Peter Haas

My Blog

  • Home
  • About Me
  • Blog
  • Contact

Codecademy Project: CoolTshirts Marketing Attribution

November 26, 2019 Peter Haas Leave a Comment

CoolTShirts sells T-shirts. They are running digital marketing campaigns to increase site visits and purchases. Using touch attribution, I sought to map customer journeys from first visit to purchase. I will use this data to recommend 5 campaigns for re-investment.

CoolTShirts has 8 campaigns, 6 traffic sources, and 4 website pages. I calculated first and last touches for each campaign and also calulcated the last touches that drove purchases. Some campaigns function well for driving first time visits (first touch), some function well for driving return visits and purchases (last touch). Some function well for both, driving purchase conversion on the first visit.

After analyzing the data, the following campaigns are ripe for optimization and re-investment: ‘weekly-newsletter’, ‘retargetting-ad’, ‘getting-to-know-cool-tshirts’, ‘ten-crazy-cool-tshirts-facts’, and ‘interview-with-cool-tshirts-founder’.

Github link to SQL file

Filed Under: SQL

« Codecademy Project: Codeflix Churn Rate

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Disclaimer
  • Refund Policy
  • Privacy Policy
  • Terms of Service

© 2021 Peter Haas · Rainmaker Platform