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:01and 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.