Question :
2 tables, containing website sessions data:
Sessions - session_id (PK), session_date, traffic_source PageViews - event_id (PK), session_id, timestamp, page_name
1)Summarize all traffic to the “Home Page” on a given day, by traffic source
2) Get number of sessions for a given day summarized by landing page (first page seen in the session)
3) Get distribution of next pages, after a user lands on the home page
4) Get daily summary of % of sessions where the user saw the “Sign Up” page Get bounce rate for a given day by traffic source (bounce rate defined as % of sessions in which only 1 page is seen)
Answers
Answered by
0
Answer:
1
Explanation:
Similar questions