This task is based on the 'Google Merchandise Store', a real ecommerce store that sells Google-branded merchandise. The questions you'll be answering should provide some insights on the performance of the store and how users interact with it. You will be using Google BigQuery to investigate a data sample of one day (2017-08-01).

Dataset: bigquery-public-data:google_analytics_sample

Table: ga_sessions_20170801

Before you start, here are some links and references that you might find useful:: Google BigQuery Console BigQuery Export schema Some documentation on standard and legacy SQL Note: Feel free to use either Standard or Legacy SQL dialect to answer the questions.

1. How many minutes on average did it take the users to reach the checkout confirmation page (title = 'Checkout Confirmation')?

2. The website tracks add and remove from cart interactions using two events (Action = 'Add to Cart' and Action = 'Remove from Cart' ). Please use that information and investigate the data further to answer the following questions: a. How many products in total did users add to cart? b. In sessions where users actually added products to their carts, how many products were added per session on average? c. What is the most added-to-cart product and what is the most removed-from-cart product (mention the product name)?

3. Did you find any insights / observations while you were investigating the data that you think are interesting to share?

4. Do you have any thoughts, notes, doubts or suggestions on the data structure?