Hey everyone,
I just finished the marketing attribution project for coolTshirts and wanted to submit my presentation for your feedback. ( drive link )
Hope it’s good.
- babylongbot
Hey everyone,
I just finished the marketing attribution project for coolTshirts and wanted to submit my presentation for your feedback. ( drive link )
Hope it’s good.
Hi babylongbot!
Thanks for sharing your project! It was really cool to learn from your work.
We mostly had similar answers. So I will just mention the differences I observed.
Question 1: I counted 4 sources which I learnt from your work that mine was wrong. You counted 8 sources - but since the question asked for unique sources, you needed to use count(distinct) in your code to get to the right answer which is 6 unique sources.
Question 6: I found that all 8 campaigns led to a purchase.
This was code:
GROUP BY user_id)
SELECT
page_name,
pv.utm_campaign,
COUNT (lt.last_touch_at) AS ‘Number of last touches’ FROM last_touch lt
JOIN page_visits pv
ON lt.user_id = pv.user_id
AND lt.last_touch_at = pv.timestamp GROUP BY 2;