I'd love feedback on the Analyze Data with SQL - Marketing Attribution project

board9959954527 · October 13, 2020, 1:19am

Hi everyone. This is my first time posting any SQL project. Not only am I new to coding, but I’m new to Google slides and PowerPoint, so all feedback is useful. Thanks!

This is the Google slides presentation:

And these are the queries:

gist.github.com

https://gist.github.com/kukev/cb07d1a71a14865f3f79c16aa9cc523a

test.sqlite


---How many distinct utm-campaigns and sources are there?
SELECT COUNT(DISTINCT utm_campaign), COUNT(DISTINCT utm_source)
FROM page_visits;

---How do the campaigns and the sources relate?
SELECT DISTINCT utm_campaign, utm_source
FROM page_visits;

---What are the web pages on the CTS website?

This file has been truncated. show original

Topic		Replies	Views
Skill Path - Marketing Attribution Skill Path Projects	0	318	May 20, 2020
Marketing Attribution Project - For Peer Review Skill Path Projects	2	643	February 23, 2020
DataScience Project - First and Last Touch Attribution Queries Projects	0	1122	November 15, 2019
Analyze SQL Assignment - Marketing Attribution - Cool T-Shirts Feedback Projects	6	1354	November 2, 2023
Skill path - SQL - Marketing attribution project Skill Path Projects	1	438	June 1, 2020

I'd love feedback on the Analyze Data with SQL - Marketing Attribution project

Related topics