Assumptions for the forecast based on the historical data

Assignment Help Marketing Management

Reference no: EM132009132

Questions: 1. Using the data included in the spreadsheet, rate the overall efficacy of the campaign by any criteria you deem relevant. Where possible, apply specific

2. Using the data in the Excel spreadsheets, create a 12-month forecast for a new, follow-up vi-ral video from Squatty Potty to be released January 1, 2017. List your assumptions for the forecast based on the historical data and any other information you can find. Additionally, calculate what you believe are the relevant marketing and financial metrics for this forecast.

3. Although Squatty Potty did an admirable job of creating feedback mechanisms to tie sales to views of the video, how could Squatty Potty have improved that effort? What data should the company attempt to capture through its next viral video promotion?

4. What does the Facebook Targeting information in the Excel spreadsheets reveal about Squat-ty Potty's market? Are there any groups either not targeted or under-represented in the target-ing?

5. Given what you have learned from the data, what ideas do you have for Squatty Potty's future promotional campaigns? Explain five ideas.

Reference no: EM132009132

Questions Cloud

Evaluate your capsim teams experience : Evaluate your Capsim team's experience by applying the five stages of the model, and provide recommendations for further improvements in team performance.

What percentage of drivers have a reaction time : What percentage of drivers have a reaction time more than 1.88 seconds? What percentage of drivers have a reaction time less than 1.46 seconds?

What is the yield maintenance penalty : Interest rate on the mortgage is 8% and current five year treasury is 2.50% and the 2 year treasury is 1.25%. What is the yield maintenance penalty.

What is the total cash flow in year eight of project : What is the Total Cash Flow in Year 8 of the project if the equipment can be sold for $5,711 and the tax rate is 25%?

Assumptions for the forecast based on the historical data : List your assumptions for the forecast based on the historical data and any other information you can find. Additionally, calculate what you believe.

Planning the purchase of new equipment : ABC, Inc is planning the purchase of new equipment that costs $103,414. Assuming a tax rate of 36%, what is the operating cash flow?

Briefly discuss one recommendation that should be followed : Identify and briefly discuss one recommendation that should be followed when using a corporate blog for branding, marketing, or public relations purposes.

What type of businesses we can compare with the army : Reading the course objectives that you would need two or three of them to be successful in management. For instinct I'm in the Recruiting world.

Analyze data sets and uncover important information used : During the course, you have applied a variety of methods to analyze data sets and uncover important information used in decision making.

User Account

All Pages