Learn
Two days later, CoolTShirts.com runs an ad on June’s Facebook page. June remembers how much she wanted that Ninja Turtles t-shirt, and follows the ad back to CoolTShirts.com.
She now has the following rows in page_visits
table:
user_id | timestamp | page_name | utm_source |
---|---|---|---|
10069 | 2018-01-02 23:14:01 | 1 - landing_page | buzzfeed |
10069 | 2018-01-02 23:14:01 | 2 - shopping_cart | buzzfeed |
10069 | 2018-01-04 08:12:01 | 3 - checkout | |
10069 | 2018-01-04 08:13:01 | 4 - purchase |
- June’s last touch — the exposure to CoolTShirts.com that led to a purchase — is attributed to
facebook
- She visited the checkout page at
08:12:01
and the purchase page at08:13:01
Instructions
1.
Find all of of June’s rows, using a WHERE
clause with just user_id
.
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.