CoolTShirts
Project
The project is from Codecademy's Analyze Data with SQL course. CoolTShirts sells shirts of all
kinds, as long as they are T-shaped and cool. Recently, CTS started a few marketing campaigns
to increase website visits and purchases. Using touch attribution, they’d like to map their
customers’ journey: from initial visit to purchase.
In this project, I will show how information can be used to optimize marketing campaigns.
As always, I start by getting a look at the data. In this project, there is only one table it's
named page_visits and it has five columns.
The first five queries are really just looking for the basics in terms of unique campaigns and sources. Here are the results:
A good way of knowing how visitors initially discover a website is called the first-touch attribute.
Next I'll run a query to take a look at this information.
Based on the query results, we can see medium, nytimes and buzzfeed as the major players for first-touch. This is a good query to run if you're deciding how you want to advertise For today, I think it's important to look at last touch to establish how marketing helped users get to the finish line and complete the sale.
As you can see, email was the number one last touch. Have you ever received an email saying you forgot something in your cart, come back and checkout? Those emails are a way of pulling you back to complete the sale. Seems pretty successful in this case, right?