Marketing Attribution for CoolTShirts.com
This research project was implemented using SQL.
The project primarily revolves around the utilization of attribution queries.
CoolTShirts.com is a webshop specialized in selling TShirts.
First of all, I analyzed which sources attract the biggest amount of customers as the first and last touch. I have also analyzed which last touch sources are responsible for the biggest amount of purchases.
The analysis revealed the most successful marketing campaigns that CoolTShirts should reinvest in. Two top first touch campaigns are responsible for almost 2/3 of the whole first touch traffic.
The top 3 last-touch campaigns account for more than 3/4 of total sales.
The in-depth analysis allowed to create a more efficient marketing campaign for CoolTSirts.com to maximize the company's profit.
You may check the code and PDF presentation following the link below.