Question: 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

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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

answer the question based of the pargrpah above marketing 360 Insert Draw Design Layout References Mailings Review Vie Google Analytics Exercise In this exercise, you will be examining the Google...

In this exercise, you will be examining the Google Analytics demo account to find various metrics youve learned in class. The data in this demo account comes from the Google Merchandise Store, an...

To answer this question, you need to experiment with data from the Google Merchandise Store. It is a real ecommerce store which sells Google-branded merchandise. For this, get an access to the Google...

Assignment: Website Analysis for Product Purchase on Google Merchandise Store (GMS) Try to think like the you're the Marketing Manager who works on the Google Merchandise Store eCommerce shop that...

Deliverables [100 marks]. This assignment in essence is a 'condensed' research and data analysis project. So, we will create the report based on a simplified research report template. Your report...

Strategic Management Frank Rothaermel,6eRelease: 6th Edition Please include a word count of your post (excluding citations and references), no matter whether it is an initial post or a reply, at the...

i need question 1 and 7 need questions 1 and 7 labor; but right now, the workforce needs more support to do its retailers globally can improve their operations. This year's study most critical task:...

3,4 PART 8 Comprehensive Case Achieving Excellence in Retailing E-commerce business. This has also fundamentally changed how store associates need to think about their customers. Introduction...

\f \f11TH EDITION STRATEGIC MANAGEMENT THEORY 11TH EDITION Strategic Management THEORY Charles W. L. Hill University of Washington - Foster School of Business Gareth R. Jones Melissa A. Schilling New...

The graph shows average and marginal cost curves for a typical firm in a perfectly competitive industry in LONG-RUN equilibrium The long-run equilibrium price of the product is $ In long-run...

Which of the following would we say will definitely fall under Natural Language Processing? Group of answer choices Translation Reinforcement Learning Speech Recognition Fake News

Question 2 2 pts Companies HD and LD have identical amounts of assets, investor - supplied capital, operating income ( EBIT ) , tax rates, and business risk. Company HD , however, has a higher debt...

Larry has bought a house for $390,000. The lender has made him a 30 year loan at 2.61% interest rate with annual payments. How much interest will Larry pay the first year on his loan? $16, 536.97...

LO7.1 Define and explain the relationship between total utility, marginal utility, and the law of diminishing marginal utility.

LO7.2 Describe how rational consumers maximize utility by comparing the marginal utility-toprice ratios of all the products they could possibly purchase.

3. Calculate total-revenue data from the demand schedule in review question 1. Graph total revenue below your demand curve. Generalize about the relationship between price elasticity and total...