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

DAU

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!