Marketing Attribution, codeflix Question 7

themattyice · September 26, 2020, 9:35pm

gist.github.com

https://gist.github.com/codecademydev/a60fd105ba39eb9a44af6411e866281a

test.sqlite

/*
Here's the first-touch query, in case you need it
*/
/*
WITH first_touch AS (
    SELECT user_id,
        MIN(timestamp) as first_touch_at
    FROM page_visits
    GROUP BY user_id)
SELECT ft.user_id,

This file has been truncated. show original

Topic		Replies	Views
Marketing Attribution : Attribution Queries Skill Path Projects	1	393	July 17, 2020
Skill Path - Marketing Attribution Skill Path Projects	0	318	May 20, 2020
First & Last touch Capstone Projects	0	374	September 30, 2020
Marketing Attribution Project - Analyze Data with SQL Skill Path Projects	0	538	May 5, 2021
Marketing Attribution - CoolTShirts.com SQL Skill Path Projects	2	876	February 6, 2020

Marketing Attribution, codeflix Question 7

Related topics