Question: QUESTION : What does the Facebook Targeting information in the Excel spreadsheets reveal about Squatty Pottys market? Are there any groups either not targeted or

QUESTION: What does the Facebook Targeting information in the Excel spreadsheets

QUESTION: What does the Facebook Targeting information in the Excel spreadsheets reveal about Squatty Pottys market? Are there any groups either not targeted or under-represented in the targeting?

Can you help to answer this question by looking at the facebook targeting sheet image in the excel file?

B D E F G H A 1 Reporting Starts 2 2015-10-01 3 2015-10-01 4 2015-10-01 5 2015-10-01 6 2015-10-01 7 2015-10-01 8 2015-10-01 9 2015-10-01 10 2015-10-01 11 2015-10-01 12 2015-10-01 13 2015-10-01 14 2015-10-01 15 2015-10-01 16 2015-10-01 17 2015-10-01 18 2015-10-01 19 2015-10-01 20 2015-10-01 21 2015-10-01 22 2015-10-01 23 2015-10-01 24 2015-10-01 25 26 Glossary/Notes 27 RESULT: 28 RESULT RATE: 29 IMPRESSION: 30 **WEBSITE CHECKOUTS: 31 LOOK-A-LIKE: 32 33 34 Reporting Ends 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 Targeting Interest in Essential Oils, Female Interest in Veganism, Female Fans of Jessica Alba Interest in Yoga, Female Interest in Chiropractic Medicine, Female Interest in Yoga, Male Look-a-Like Purchasers of Squatty Potty Look-a-Like Purchasers of Squatty Potty > 30 years old All Males All people aged 18-40 Interest in Chiropractic Medicine, Male Arabic Language Look-a-Like Purchasers of Squatty Potty 18-54 years old Hindi Language Fans of Gwyneth Paltrow, Female Interest in Veganism, Male Korean Language All Females Look-a-Like Purchasers of Squatty Potty, Aged 18-54 Fans of Howard Stern, Male Fans of Gwyneth Paltrow, Male Fans of Howard Stern, Female Current Squatty Potty Customers Impressions Results Result Rate Cost per Results Daily Budget Total Promotional Spend 225.809 81.851 2,759 $ 0,0112 $ 500,00 $ 916,10 283.249 92.629 3,058 $ 0,0163 $ 100,00 $ 1.510,66 217.923 69.102 3,154 $ 0,0166 $ 200,00 $ 1.149,17 3.043.974 933.091 3,262 $ 0,0185 $ 200,00 $ 17.263,31 910.183 311.253 2,924 $ 0,0221 $ 200,00 $ 6.881,66 2.423.123 776.148 3,122 $ 0,0223 $ 100,00 $ 17.269,42 227.505 95.875 2,373 $ 0,0285 $ 400,00 $ 2.728,41 45.490 17.372 2,619 $ 0,0294 $ 500,00 $ 510,41 462.368 127.148 3,636 $ 0,0296 $ 2.000,00 $ 3.767,20 14.784.475 4.128.907 3,581 $ 0,0300 $ 500,00 $ 123.891,97 670.622 209.588 3,200 $ 0,0327 $ 200,00 $ 6.855,16 94.756 25.705 3,686 $ 0,0353 $ 200,00 $ 907,36 814.369 330.181 2,466 $ 0,0373 $ 100,00 $ 12.309,84 84.279 24.058 3,503 $ 0,0378 $ 200,00 $ 908,79 469.989 133.254 3,527 $ 0,0394 $ 200,00 $ 5.244,87 4.118.028 1.090.514 3,776 $ 0,0405 $ 200,00 $ 44.165,73 103.631 25.404 4,079 $ 0,0423 $ 200,00 $ 1.075,45 301.577 87.279 3,455 $ 0,0432 $ 2.000,00 $ 3.770,87 788.598 310.745 2,538 $ 0,0455 $ 100,00 $ 14.139,61 427.373 89.527 4,774 $ 0,0634 $ 200,00 $ 5.678,94 97.795 30.453 3,211 $ 0,0739 $ 400,00 $ 2.250,44 120.141 29.427 4,083 $ 0,0784 $ 400,00 $ 2.306,34 27.833 1.984 14,029 $ 0,1946 $ 100,00 $ 386,15 J K L M Squatty Potty.com Checkouts Cost per Squatty Potty.com Checkout 60 $ 15,27 110 $ 13,73 60 $ 19,15 1330 $ 12,98 480 $ 14,34 1870 $ 9,23 190 $ 14,36 30 $ 17,01 70 $ 53,82 7920 $ 15,64 420 $ 16,32 10 $ 90,74 940 $ 13,10 30 $ 30,29 270 $ 19,43 3330 $ 13,26 30 $ 35,85 90 $ 41,90 180 $ 78,55 460 $ 12,35 50 $ 45,01 60 $ 38,44 60 $ 6,44 A view, like, comment or share of the video on Facebook The ratio of results to impressions Number of times an ad was exposed to a person Tracked result converting to a purchase using Facebook pixels (NOT capturing Amazon purchases, so the true number of resulting sales is likely significantly higher) Profiles of users who behave similarly to other groups, in this case purchasers of Squatty Potty, created by Facebook analytics B D E F G H A 1 Reporting Starts 2 2015-10-01 3 2015-10-01 4 2015-10-01 5 2015-10-01 6 2015-10-01 7 2015-10-01 8 2015-10-01 9 2015-10-01 10 2015-10-01 11 2015-10-01 12 2015-10-01 13 2015-10-01 14 2015-10-01 15 2015-10-01 16 2015-10-01 17 2015-10-01 18 2015-10-01 19 2015-10-01 20 2015-10-01 21 2015-10-01 22 2015-10-01 23 2015-10-01 24 2015-10-01 25 26 Glossary/Notes 27 RESULT: 28 RESULT RATE: 29 IMPRESSION: 30 **WEBSITE CHECKOUTS: 31 LOOK-A-LIKE: 32 33 34 Reporting Ends 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 2015-12-31 Targeting Interest in Essential Oils, Female Interest in Veganism, Female Fans of Jessica Alba Interest in Yoga, Female Interest in Chiropractic Medicine, Female Interest in Yoga, Male Look-a-Like Purchasers of Squatty Potty Look-a-Like Purchasers of Squatty Potty > 30 years old All Males All people aged 18-40 Interest in Chiropractic Medicine, Male Arabic Language Look-a-Like Purchasers of Squatty Potty 18-54 years old Hindi Language Fans of Gwyneth Paltrow, Female Interest in Veganism, Male Korean Language All Females Look-a-Like Purchasers of Squatty Potty, Aged 18-54 Fans of Howard Stern, Male Fans of Gwyneth Paltrow, Male Fans of Howard Stern, Female Current Squatty Potty Customers Impressions Results Result Rate Cost per Results Daily Budget Total Promotional Spend 225.809 81.851 2,759 $ 0,0112 $ 500,00 $ 916,10 283.249 92.629 3,058 $ 0,0163 $ 100,00 $ 1.510,66 217.923 69.102 3,154 $ 0,0166 $ 200,00 $ 1.149,17 3.043.974 933.091 3,262 $ 0,0185 $ 200,00 $ 17.263,31 910.183 311.253 2,924 $ 0,0221 $ 200,00 $ 6.881,66 2.423.123 776.148 3,122 $ 0,0223 $ 100,00 $ 17.269,42 227.505 95.875 2,373 $ 0,0285 $ 400,00 $ 2.728,41 45.490 17.372 2,619 $ 0,0294 $ 500,00 $ 510,41 462.368 127.148 3,636 $ 0,0296 $ 2.000,00 $ 3.767,20 14.784.475 4.128.907 3,581 $ 0,0300 $ 500,00 $ 123.891,97 670.622 209.588 3,200 $ 0,0327 $ 200,00 $ 6.855,16 94.756 25.705 3,686 $ 0,0353 $ 200,00 $ 907,36 814.369 330.181 2,466 $ 0,0373 $ 100,00 $ 12.309,84 84.279 24.058 3,503 $ 0,0378 $ 200,00 $ 908,79 469.989 133.254 3,527 $ 0,0394 $ 200,00 $ 5.244,87 4.118.028 1.090.514 3,776 $ 0,0405 $ 200,00 $ 44.165,73 103.631 25.404 4,079 $ 0,0423 $ 200,00 $ 1.075,45 301.577 87.279 3,455 $ 0,0432 $ 2.000,00 $ 3.770,87 788.598 310.745 2,538 $ 0,0455 $ 100,00 $ 14.139,61 427.373 89.527 4,774 $ 0,0634 $ 200,00 $ 5.678,94 97.795 30.453 3,211 $ 0,0739 $ 400,00 $ 2.250,44 120.141 29.427 4,083 $ 0,0784 $ 400,00 $ 2.306,34 27.833 1.984 14,029 $ 0,1946 $ 100,00 $ 386,15 J K L M Squatty Potty.com Checkouts Cost per Squatty Potty.com Checkout 60 $ 15,27 110 $ 13,73 60 $ 19,15 1330 $ 12,98 480 $ 14,34 1870 $ 9,23 190 $ 14,36 30 $ 17,01 70 $ 53,82 7920 $ 15,64 420 $ 16,32 10 $ 90,74 940 $ 13,10 30 $ 30,29 270 $ 19,43 3330 $ 13,26 30 $ 35,85 90 $ 41,90 180 $ 78,55 460 $ 12,35 50 $ 45,01 60 $ 38,44 60 $ 6,44 A view, like, comment or share of the video on Facebook The ratio of results to impressions Number of times an ad was exposed to a person Tracked result converting to a purchase using Facebook pixels (NOT capturing Amazon purchases, so the true number of resulting sales is likely significantly higher) Profiles of users who behave similarly to other groups, in this case purchasers of Squatty Potty, created by Facebook analytics

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

In future promotions, what data should they begin capturing to drive better results? What does the Facebook targeting information in the Excel spreadsheets reveal about Squatty Potty's market? Are...

Although Squatty Potty did and admirable job 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...

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

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. Using the data in the...

Squatty Potty: Assessing Digital Marketing Campaign Data a) Using the data included in the spreadsheet, rate the overall efficacy of the campaign by any criteria you deem relevant. Where possible,...

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

Squatty Potty: Assessing Digital Marketing Campaign Data A. Using the data included in the spreadsheet, rate the overall efficacy of the campaign by any criteria you deem relevant. Where possible,...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Please Read And Summarize Thank You!! Editor's note: Michael Latta is executive dircctor of YTMBA Research, and Dr. Murray Simon is president of D/R/S HealthCare Consultants. For more information...

For the exclusive use of S. Setiawan, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

The number of times interest charges are earned is computed as: a. Net income plus interest charges, divided by interest charges b. Income before income tax plus interest charges, divided by interest...

The weights (in pounds) of a sample of five boxes being sent by UPS are 12, 6, 7, 3, and 10. a. Compute the range. b. Compute the standard deviation.

Task 5 : Implement the position _ warren _ truss _ vertices function in the code cell below. # This function determines the x , y coordinates of each of the vertices in the top row and bottom row of...

Within a continuously competitive global business environment, publicly held companies face constant pressure to generate and report positive financial results. Unfortunately, some leaders may be...

Which of the potential advantages and disadvantages of group problem solving and decision-making do you think arise most frequently?

Are creativity and innovation really that important to all types of businesses?

What is the difference between a rule and a norm? Do norms help or hurt groups? Is it ethical to make group members comply with group norms? Can groups stop having norms?