$2.$ Was the campaign profitable?

a$.$ How much more money did TaskaBella make by running the campaign $($excluding ad costs$)?$

b$.$ What was the cost of the campaign?

c$.$ Calculate the ROI of the campaign.

d$.$ What was the opportunity cost of including a control group?

$3.$ How did the number of impressions seen by each user influence the effectiveness of advertising $($use Impression Summary tab in the Excel file$).$

a$.$ What are the conversion rates for each category for the test and control group $($you can complete the table in the Excel file and copy to answer this question$)?$

b$.$ Create a clustered column bar chart based on total impressions and the resulting conversion rates.

c$.$ What do you learn from this analysis?

$4.$ How does the consumer response to advertising vary across:

a$.$ The different days of the week $($Day Summary tab in Excel file$)?$

i$.$ Calculate the conversion rates for the control group and the test group for each day of the week $($you can complete the table in the Excel file and copy to answer this question$).$

ii$.$ Create a clustered bar chart to show the differences between each group by day of the week.

iii. What do you learn from this analysis?

b$.$ The different time of day $($Time Summary tab in Excel file$)?$

i$.$ Calculate the conversion rates for the control group and the test group for each hour of the day $($you can complete the table in the Excel file and copy to answer this question$).$

ii$.$ Create a clustered bar chart to show the differences between each group by time of day.

iii. What do you learn from this analysis?

$5.$ Taking all the information from the prior questions, summarize what you learned from the analysis.

a$.$ What is working?

b$.$ What recommendations do you have for the firm moving forward $($grounded in the analysis$)?$