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







A. Using the data included in the spreadsheet, rate the overall efficacy of the campaign by any criteria you deem relevant. Where possible, apply specific numbers to the criteria.
B. Given what you have learned from the data, what ideas do you have for Squatty Pottys future promotional campaigns?
C. Based on the excel market data, are there any groups either not targeted or under-represented in the targeting?
\begin{tabular}{|l|l|r|} \hline & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c|}{ B } \\ \hline 1 & Social Media Metrics: October 2015 to December 2016 \\ \hline 2 & & \\ \hline 3 & Facebook Views: & 125,475,750 \\ \hline 4 & Facebook Shares: & 1,680,020 \\ \hline 5 & Facebook Reactions: & 2,976,198 \\ \hline 6 & Facebook Comments: & 1,832,689 \\ \hline 7 & View to Share Ratio: & 74.7 \\ \hline 8 & & 31,443,004 \\ \hline 9 & YouTube Views: & 719,321 \\ \hline 10 & YouTube Shares: & 83,519 \\ \hline 11 & YouTube Likes: & 6,205 \\ \hline 12 & YouTube Comments: & 43.7 \\ \hline 13 & View to Share Ratio: & \\ \hline 14 & & \end{tabular} \begin{tabular}{|l|l|r|} \hline & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c|}{ B } \\ \hline 1 & Social Media Metrics: October 2015 to December 2016 \\ \hline 2 & & \\ \hline 3 & Facebook Views: & 125,475,750 \\ \hline 4 & Facebook Shares: & 1,680,020 \\ \hline 5 & Facebook Reactions: & 2,976,198 \\ \hline 6 & Facebook Comments: & 1,832,689 \\ \hline 7 & View to Share Ratio: & 74.7 \\ \hline 8 & & 31,443,004 \\ \hline 9 & YouTube Views: & 719,321 \\ \hline 10 & YouTube Shares: & 83,519 \\ \hline 11 & YouTube Likes: & 6,205 \\ \hline 12 & YouTube Comments: & 43.7 \\ \hline 13 & View to Share Ratio: & \\ \hline 14 & & \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
