Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PFA, two excel sheets with data from google demo account. Below are the sheet details: A. GA-Demo-Data-Oct20-Mar21-Country - This is country level data across various

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
PFA, two excel sheets with data from google demo account. Below are the sheet details: A. GA-Demo-Data-Oct20-Mar21-Country - This is country level data across various traffic sources for Oct20 Mar21 date range. 1. Source/Medium - This represents the channel from where the traffic came to the site; 2. Wherever you see "medium" either of cpc, cpm, ppc, paid, affiliate, please know that these channels are all various types of paid media channels. For e.g. "google/cpc" - this source medium means that the channel is paid google ads. Please answer the following from above: 1. Top 3 performing (Source/Medium) across India and US (separately) basis the revenue contribution. Also mention their revenue contribution against overall country sales.. 2. Top performing paid media channel (ppe/cpc/paid/cpm/affiliate) in the US. 3. Which country should we pause paid ads (ppc/cpc/paid/cpm/affiliate) on? and why? 4. Represent the complete data consolidated at the country level for top 5 countries by revenue with all sources put together, in a tabular format. PFA, two excel sheets with data from google demo account. Below are the sheet details: A. GA-Demo-Data-Oct20-Mar21-Country - This is country level data across various traffic sources for Oct20 Mar21 date range. 1. Source/Medium - This represents the channel from where the traffic came to the site; 2. Wherever you see "medium" either of cpc, cpm, ppc, paid, affiliate, please know that these channels are all various types of paid media channels. For e.g. "google/cpc" - this source medium means that the channel is paid google ads. Please answer the following from above: 1. Top 3 performing (Source/Medium) across India and US (separately) basis the revenue contribution. Also mention their revenue contribution against overall country sales.. 2. Top performing paid media channel (ppe/cpc/paid/cpm/affiliate) in the US. 3. Which country should we pause paid ads (ppc/cpc/paid/cpm/affiliate) on? and why? 4. Represent the complete data consolidated at the country level for top 5 countries by revenue with all sources put together, in a tabular format

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Manufacturing And Service Applications

Authors: Arnold Schneider, Harold M. Sollenberger

4th Edition

0759350426, 978-0759350427

More Books

Students also viewed these Accounting questions

Question

Define rapport as it relates to a clinical interview.

Answered: 1 week ago

Question

Are there any changes you would recommend in the selection process?

Answered: 1 week ago