HELLO TO EVERYONE; I URGENTLY NEED ANSWERS TO THE FOLLOWING QUESTIONS. THANK YOU FROM NOW..

SQUATTY POTTY: ASSESSING DIGITAL MARKETING CAMPAIGN DATA

QUESTION 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

QUESTION 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.

QUESTION 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?

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

QUSETION 5:Given what you have learned from the data, what ideas do you have for Squatty Pottys future promotional campaigns? Explain five ideas.