Answer the questions below after downloading the and reviewing the simple case study and the Handbags Co. scenario. Use attached Handbags DATA for pivot table creation, excel calculations.Marketing ROI for Handbags DATA-1.xlsxDownload Marketing ROI for Handbags DATA-1.xlsx
Marketing ROI for Handbags DATA.xlsx
I HAVE INSERTED THE DATA AND CASE STUDY IN ATTACHED FILES AS WELL AS A SCREENSHOT OF THE INSTRUCTIONS!
ANSWER THE FOLLOWING QUESTIONS
- Was the online ad campaign effective? Did additional customers convert as a result of the campaign?
- Was the campaign profitable?
- How much more money did Handbags Co. make by running the campaign (excluding costs)?
- What was the cost of the campaign?
- Calculate the ROI of the campaign. Was the campaign profitable?
- How did the number of impressions seen by each user influence the effectiveness of the advertising?
- Create a chart of conversion rates as a function of the number of ads displayed to users. Plot conversion rates for those in the control group and for those who were exposed to the ads