Assignment

Your manager $is$ interested $in$ the performance $of$ the Google Merchandise Store's search ads purchased through Google Ads for the last month $(see$ data $in$ the attached chart$).$ Your manager has asked you $to$ answer the following questions using the Google Ads data.

$1.$ What was the total cost $of$ Google Merchandise Store's Google Ads for last month?

$2.$ What was the Google Ads overall cost per conversion for last month? Use the metrics Google Ads Cost and Conversions $to$ calculate cost per conversion.

$3.$ What was the total Google Ads revenue for last month?

$4.$ Without including campaign $ad$ spend costs, there $isa60$ percent margin $(60$ percent $of$ revenues are profits$)on$ products sold through the Google Merchandise Store. What were the total marketing profits before $ad$ spend costs last month from Google Ads?

$5.$ What was the Google Ads ROAS $(returnonad$ spend$)$ for last month? Use the metrics Google Ads Cost and marketing profits before $ad$ spend costs $(from$ question $4)to$ calculate ROAS. Write your answer $as$ a percentage.

$6.$ Which Google Ads campaign had the highest $CPC(cost$ per click$)$ last month?

$7.$ Which Google Ads campaign had the most clicks last month?

$8.$ Which campaign received the most conversions last month?

$9.$ Did any Google Ads campaigns yield a positive ROAS last month? $If$ yes, which campaign$(s)?$ Calculate ROAS using the same method described $in$ question $5.$

$10.$ Your manager indicates that the Google Ads campaigns should support the goal $of$ increasing profitability $of$ the Google Merchandise Store. Given this goal and last month performance, should the Google Merchandise Store continue $to$ run the Google Ads campaigns under the current setup? Why $or$ why not?

Submit document with above $10$ questions and your answers via Canvas.