1) Show your calculation on Bob's ROI Calculation 2) Prepare a Table 3 that shows the Average...
Question:
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%.
Elementary Statistics Picturing the World
ISBN: 978-0321911216
6th edition
Authors: Ron Larson, Betsy Farber