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 Week 1 32,269 2 31,951 128,169 127,876 Sponsored Organic Table 2: Weekly traffic from Bing by origin of click Week 1 2 Sponsored Organic 3,965 15,805 3 32,143 125,717 3,984 15,964 3 3,960 15,815 4 5 31,417 31,194 126,264 123,871 4 3,952 15,810 5 3,874 15,633 6 31,576 124,053 6 3,932 15,797 7 30,951 126,105 7 3,890 15,462 8 30,611 123,064 8 3,883 15,309 9 30,401 121,637 150,188 10 0 9 3,843 15,499 10 3,815 15,185 11 148,658 11 3,754 15,159 12 0 146,584 12 3,754 15,036