I am missing a query and output of how many visitors make a purchase on the website. There should have been code that looked something like this:
SELECT pv.page_name,
COUNT(DISTINCT pv.user_id ) AS users
FROM page_visits pv
GROUP BY 1;
Or this:
SELECT pv.page_name,
COUNT(DISTINCT pv.user_id ) AS users
FROM page_visits pv
WHERE page_name = '4 - purchase';
And I should have seen a table that shows me a list of each page name and how many users visited each page. This would show that 1979 users started on landing_page, but only 361 users made it to purchase page. This means that only 18.2% of users made a purchase. I am missing all of this information in both your code and your presentation.
I am missing a query and output of how many visitors make a purchase on the website. There should have been code that looked something like this:
Or this:
And I should have seen a table that shows me a list of each page name and how many users visited each page. This would show that 1979 users started on
landing_page
, but only 361 users made it topurchase
page. This means that only 18.2% of users made a purchase. I am missing all of this information in both your code and your presentation.