logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Earle BirdsellBusiness
(5/5)

959 Answers

Hire Me
expert
Anmol AroraGeneral article writing
(5/5)

767 Answers

Hire Me
expert
Maurice DugganNursing
(5/5)

716 Answers

Hire Me
expert
Ramish RazzaScience
(4/5)

694 Answers

Hire Me
Others

Based on the data sets “Model_Contributions_FitnesComp” prepare a Tableau Dashboard talking about the past company and marketing performance

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Your manager asks you to prepare following analysis:

1. Based on the data sets “Model_Contributions_FitnesComp” prepare a Tableau Dashboard talking about the past company and marketing performance. Prepare visualizations to answer questions regarding and showcase:
a. Company performance over time (new memberships and revenues). Please limit this analysis to maximum of year on year comparisons on quarterly level, which reflect and showcase the changes in the media mix over the past two years.
b. Influences of competitors, new membership plans and seasonality. Please limit this analysis to maximum of year on year comparisons on quarterly level, which reflect and showcase the changes in the media mix over the past two years.
c. Analysis of the channel efficiency (ROAS) and effectiveness (marketing contributions in terms of new memberships and revenues) over the past two years. Please limit this analysis to year on year comparisons, which reflect and showcase the changes in the media mix over the past two years.
2. Based on the analysis, you have performed present your general summary of the efficiency and effectiveness of every media channel.
a. The BI Unit of FitnesComp+ reports that the Customer Lifetime Value of a new subscriber is 280,- €. How does that change your evaluation of the efficiency and effectiveness of every media channel? Please base and consider for the following computations on the notion of CLV per new subscriber of 280,- € instead the average price of 120,- €.
3. Given the Media Plan 2020 and the given efficiency curvesin Section 2 & Section 3 please compute a prediction of the marketing contribution to sales in 2020. Please assume that the reported contributions include AdStock Effects and reflect the full contribution per spend week.
4. Given your prediction, what is the effect of the budget increase on the performance of different marketing channels compared to the past years?
5. Given the efficiency curves, please derive and showcase a new media strategy, leading to more incremental marketing contribution compared with your prediction (more new members and more CLV). Showcase the improvements, you have achieved. For this please consider following:
a. You cannot extend or shorten the length of the flight per channel. Please stay with the same number of weeks on air per channel, unless you exclude entire channel and spread the investment across other channels.
b. For more simplicity, you can reduce or increase the spend for every media channel per given flighting proportionally for the number of weeks.
c. You can exclude completely channels, but you cannot add additional channels based on assumptions regarding their efficiency.
d. Please make sure, that the entire budget of 16 billion Euro is spent within the year.

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme