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 sells Google-branded products. Use the GMS demo account (the dataset) that you connected to Google Analytics (the analysis software/tool) for this analysis. Objective(s) . Demonstrate how to do website analysis for a specific objective with descriptive analytics (what happened?) Identify an insight (1, maybe 2) in what you see with diagnostic analytics (why did it happen? why is something important?) Communicate the analysis concisely using data-supported narrative and/or clear data visualization Reminders . Change the timeframe to curate data for the period you want to analyze To determine increase/decrease you need to compare vs. a previous timeframe . Minimize visual noise for nominal amounts: o Round any $ to the nearest whole dollar (i.e. $467.67 becomes $468) Round any # of something to the nearest whole number (i.e. 567.4 becomes 567) However, for 6 percent keep it consistent and round any % to two decimal places (i.e. 1.11%) even if it's whole (i.e. 2.20% or 3.00%) Instructions Download a copy of this document to work with and submit Complete parts 1-2 by responding in this document Answers can be in clear, succinct bullet point-style sentences vs. long paragraphs o Use data-supported objective statements Keep this document to 2 pages total following the page breaks for each part Don't change formatting (font, size, margins, bullets) or this document won't be marked . Under Evaluation, you have a choice of how much effort to invest and what to submit for this assignment based on the mark you want to try to achieve 1) Your Information Your Name (First and Last) GBC Student Number GBC Email address Course CRN2) Analysis Question(s) When thinking of a website with eCommerce functionality, and the marketing communication objective of conversions, one thing you want to analyze is which products (or services) did people buy/purchase: . What were our top selling products/SKUs in terms of $ revenue? What were our top selling products/SKUs in terms of # of units? Note: SKU = Commonly used abbreviation for Stock Keeping Unit when talking about individual physical products listed for sale What were the top 10 products sold by $ revenue on the GMS in 2019? Your answer 1. What were the top 10 products/SKUs sold by $ revenue on the GMS in 2019? 2. Organize the top 10 products/SKU's in a table along with columns showing the following data for each one: Revenue $, Quantity #, Avg. Price, Avg. Quantity 3. What % percent of total revenue do these top 10 products represent? What does this tell you?What were the top 10 products sold by # of units/quantity on the GMS in 2019? Your answer 4. What were the top 10 products/SKUs sold by # units/ quantity on the GMS in 2019? 5. Organize the top 10 products/SKU's in a table along with columns showing the following data for each one: Quantity #, Revenue $, Avg. Price, Avg. Quantity 6. What % percent of total quantity sold do these top 10 products represent? What does this tell you? Do you notice anything interesting when comparing top 10 products sold by $ revenue vs. # units/quantity? What insights emerge for you when evaluating this data