90.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer