The dataset found in the excel sheet attached provides 1-month sample of obfuscated Google Analytics 360 data from the Google Merchandise Store, a real ecommerce store that sells Google-branded merchandise. Please see the ‘definition of terms’ tab for a complete list of all of the types of data in the “results…” tab. The data is typical of what an ecommerce website would see and includes the following information:
Traffic source data: information about where website visitors originate, including data about organic traffic, paid search traffic, and display traffic
Transactional data: information about the transactions on the Google Merchandise Store website.
From the given data, map out the following KPIs:
Revenue per city
Channel Grouping count
Revenue per category
Visits per visitor
(Note: there are 3 tabs in the attached document), be creative and do good quality here please!