First & Last touch

bindiyaroy5607579134 · September 30, 2020, 2:50pm

Is there any other efficient way to query this data?

gist.github.com

https://gist.github.com/codecademydev/086bce4feb198226dd283540fabe968b

test.sqlite

SELECT COUNT(DISTINCT utm_campaign)
FROM page_visits;

SELECT COUNT(DISTINCT utm_source)
FROM page_visits;

SELECT DISTINCT utm_campaign,utm_source
FROM page_visits;

SELECT DISTINCT page_name

This file has been truncated. show original

gist.github.com

https://gist.github.com/codecademydev/086bce4feb198226dd283540fabe968b

test.sqlite

SELECT COUNT(DISTINCT utm_campaign)
FROM page_visits;

SELECT COUNT(DISTINCT utm_source)
FROM page_visits;

SELECT DISTINCT utm_campaign,utm_source
FROM page_visits;

SELECT DISTINCT page_name

This file has been truncated. show original

Topic		Replies	Views
Skill Path - Marketing Attribution Skill Path Projects	0	318	May 20, 2020
Marketing Attribution, codeflix Question 7 Skill Path Projects	0	415	September 26, 2020
CoolTShirts- first & last touch Capstone Projects	2	386	October 1, 2020
I'd love feedback on the Analyze Data with SQL - Marketing Attribution project Skill Path Projects	0	377	October 13, 2020
Marketing Attribution : Attribution Queries Skill Path Projects	1	393	July 17, 2020

First & Last touch

Related topics