1) Show your calculation on Bob's ROI Calculation

2) Prepare a Table 3 that shows the Average weekly total traffic from Google for Weeks 1-9 and Weeks 10-12 and provide the % of reduction on ads.

3) Prepare a Table 4 that shows the Average weekly total traffic from Google for Weeks 1-9 and Weeks 10-12 and provide the % of reduction on ads.

4) Prepare a Table 5 that shows the Actual and Projected Weekly Average Total Traffic in Weeks 1-9 and 10-12 and provide the difference between those two values for Google and Bing. It should be one %

5) Provide the Actual ROI on Ad Spend and determine if Brazzar.com is profiting off sponsored searches.

We know the average cost per click for a sponsored click is $0.60. Once consumers land on Brazaar.com, their average probability of making a purchase from our website is 12% and our average margin per conversion is $21. So that leads to an average revenue per click of 0.12 x $21, or $2.52, which implies an ROI of ($2.52-$0.60)/($0.60), or 320.0%.

Table 1: Weekly traffic from Google by origin of click (for branded keywords searches only)
Week	1	2	3	4	5	6	7	8	9	10	11	12
Sponsored	32,269	31,951	32,143	31,417	31,194	31,576	30,951	30,611	30,401	0	0	0
Organic	127,876	128,169	125,717	126,264	123,871	124,053	126,105	123,064	121,637	150,188	148,658	146,584
Total	160,145	160,120	157,860	157,681	155,065	155,629	157,056	153,675	152,038	150,188	148,658	146,584

Table 2: Weekly traffic from Bing by origin of click (for branded keywords searches only)
Week	1	2	3	4	5	6	7	8	9	10	11	12
Sponsored	3,965	3,984	3,960	3,952	3,874	3,932	3,890	3,883	3,843	3,815	3,754	3,754
Organic	15,805	15,964	15,815	15,810	15,633	15,797	15,462	15,309	15,499	15,185	15,159	15,036
Total	19,770	19,948	19,775	19,762	19,507	19,729	19,352	19,192	19,342	19,000	18,913	18,790

Table 3: Average weekly total traffic from Google
Weeks 1-9	Weeks 10-12
?	?	#DIV/0!

Table 4: Average weekly total traffic from Bing
Weeks 1-9	Weeks 10-12
?	?	#DIV/0!

Table 5: Actual and Projected Weekly Average Total Traffic in Weeks 1-9 and 10-12
	Weeks 1-9	Weeks 10-12	Reduction in traffic (Diff 1)
Google	0	0	#DIV/0!
Bing	0	0	#DIV/0!
		Normalized reduction in traffic (Diff 2)	#DIV/0!