9 SZREZ 555 - IT ET W Date Day of Week 1111 Monday 11 Monday 1/1/21 Monday 5 1/12 Monday 1/2/21 Tuesday 7 12/21 Tuesday 8 1221 Tuesday 12/21 Tunday 10 1/1/21 Wednesday 13/21 Wednesday 12 1121 Wednesday 1121 We 14 3/4/21 Thursday 15 1,411 v 16 1/21 Thursday 17 1/21 Thunday 18 1/5/01 Friday 19 1/5/01 Fow 20 1/51 Friday 21 1/5/01 22 1/6/21 23 Saturday 24 1/6/21 Saturday 101 26 1/2 su 23 171/21 Saw 12/21 30 1. Men 11 My 7 Monday 10 M 34 1/12 Tum 36 17 / We BW W www Channel Impressions Clics Transactions Revenge Facebook 46115 541 36 $ 4.428.00 instagram LORSR 320 42 $ 3,100.00 TikTok 11164 1480 48 $ 5.136.00 Twitter 14475 1341 17 $ 2,720.00 Facebook 11473 377 48 S 5.664.00 Instagram 45711 1735 5.400 TITOR 47676 SER 4 $ 5,232.00 Twitter 28 5 132.00 Facebook 48183 100 19 $8.624.00 12485 291 25 $ 2.170.00 Viktor 120261258 17 $1,71700 Twitter 11058 1345 11 5 1.199.00 Facebook 21533 4 5 5,176.00 Inst 15515 15 97 $ 1.532.00 TikTok 45667 50 21 5 1460 Twitter 11660 215 134,752.00 Facebook 212581667 19 SL. Inn 593 13 5 1,9320 Tatok 3 DO Twitt 1125 136 37 4716.00 Facebook 4613 17 5,115 th 17410 370 9 100 359921339 1.NO Twitter 413 52 Facebook 1101112 20 35.56 33097 756 TATOR 154 1440 1209 1805 2 5413600 WO 301 1900 22 54 THAT 0904 4310 Twitter 21414141 12 520.00 re 17 10 Se 335 100 3572 LESBE OTE 900 UNE OOTS un tout PYS IES 11 BE ELERE 09 NETS EL SE DO TE LE ALTOR 000 WE BESTE BE GE O // Sorot 11 TS 43 IM - KE 1 36000 NORTS ES ES th 175 AO Ora # # 3 $ 4 N Q W E fab aste 3 BIU 50 D E H putut SOS 47453 1616 40339 663 11661 15007 1116 2771 862 300 446 1138 23124 1942 1 1453 28543 207 41900 1564 125791 SREE $ A C 1/11/21 Thursday Twitter 12 Facebook 1/12/21 rid 112121 1/12/2 Pray Twith 1/13/1 Saturday book 1/11/25 1/1921 Saturday Tak 1 Saturday TW 1/1411 Facebook 5 1/341 und 1/14/21 1/1421 Tate 5 1/2501 Monty Yach 59 1 Mend 175.21 Monday TI 1/23/2 Twitter 62 RT Facebook 61 1/25/23 64 LADI ES T2 Tu TW 112 We W1 W 1 W TH 11. We 70 4th 71 LO They 72 Thury TOR 73 Seite SO 50.200.00 11 5 1,021.00 a $ 7,056.00 36 52/412.00 18 $ 2.265.00 31 S260400 105 2,500.00 10 5 1,250.00 20 53.800.00 39 40 16 S 1,799.00 45 $90.00 52.00 27 $2,025.00 12 $ 1.500.00 49 $3.675.00 1015 15.00 105,00 25 50.00 22 12 2 16.00 12 16.00 NEO 11020 23664 112 973 SERE 18 a 1000 21016102 29 384 114 1782 178 1918 213 100 340 753 16 4714 TE EZSE OSE S CE SOS nik BES PE TOR mm 1982 41011 00012 100 1900 ON 2 SENES ME LIDE 77 TE 73 TEN DE 30 T CE CORTE INTELE TE OTH 1111 11 TOOL 411 M Mb hay (0 . 2 3 4 Q w E R. R C TikTok TE OLE E6 B 3 122/21 Monday 9 1721 Monday 30 17321 Tuesday 11 Tuesday 32 1/23/21 Tuesday 1/2371 Tuesday 94 1/24/21 Wednesday 95 1/24/21 Wednesday 96 1/24/21 Wednesday 1/24/21 Wednesday 1/25/21 Thursday 99 1/25/21 Thursday 100 1/25/21 Thursday 1/25/21 Thunday 1/26/21 Friday 103 1/25/2 Frio 104 176/21 Friday 105 1/2/21 Friday 106 27/27/21 Saturday 107 1/27/21 Saturday 308 1/27/21 109 1/27/21 130 1/20/21 Sunday 111 10 Sun 112 193 1201 Sunday 114 1 Monday 115 1001 May 146 12/21 M 113 1/29121 M 110 D 27055 836 13614 1546 32106 1230 48981 1090 30698 26614 1124 15663 958 16508 590 43793 1455 375971613 32404 1832 39967 126 23676 1512 31792 912 45036 186 12000 785 33583 1831 349701072 41331 Facebook Instagram Tek Twitter Facebook Instagram Tiktok Twitter Facebook Instagram Tacok Twitter Facebook Instagram TILTE Twitter Facebook gum TIT Twitter Facebook 26 85 39 $ 4,758.00 10 $ 1,020.00 11 $ 946.00 41 $ 3,403.00 50 $4,000.00 26 $ 3,848.00 45 S 690.00 20$ 3,920.00 16 $ 1,856.00 35 5 5,285.00 30 $4,740.00 35 5 5,500.00 11$ 1.991.00 46 5.6.026.00 50 $5.350.00 31 $5,811.00 SO $ 7.000.00 46 5.646.00 TOT TOT 00 OLESZ O 019 THE spielt 37616 997 MAN 200 19214 236 14590 1920 27911 569 127 2.96141220 WE Tato Twitter Foto 44 5.4.444.00 az $ 3.776.00 26:52,012.00 10 $ 170.00 20 52.00000 20 5 2 11000 30 $4,050.00 255.00 65396.00 19 21100 30 $2,000 OLSO IT Twitter 10 572 US 1999 OEST SEE 001907 $1.00 HESE 02 T 120 121 322 120 12 Tud 10 1/1/21 W UU W 110.00 0001 1001 1993 1439 10 1971 20171 3. The Tam 101 TRW to WTS 36 12 BRE SC Awal de DOCE 2 # 3 4 Q lab w M E You are a digital marketing Intern at a small footwear company located in Portland, OR YOU have been asked to evaluate the financial performance of your social media advertising campaigns and make recommendations about how to allocate your digital advertising budget Your manager gave you the following information: Online sales carn a 12% profit margin. Your monthly social media advertising bodget is $20,000 . You currently allocate 30% to Facebook, 30% to Instagram, 2018 to TikTok and 2014 to Twitter Part 1: Data Analysis Download the Compaion Data e attached to the Assignment Dropbox. At a minimum, calculate the following values al hu 8? BE GU Perhaps most importantly, you should also a Return On Andressed in bother you will need to add several new column, form, and to the sprache many of these values and you will need to consider when it's apporto cater and Forele, e perdid Dove will tell you how much you can for each der but it won't you will momento diretor more ne per W E E 20 T Y S D F G H N z X C C V B alt Teh stion command Part 2: Executive Summary Now that you have completed your Marketing Data Analysis, consolidate your findings into a 1- page executive summary. I have provided a couple examples attached to the Assignment Dropbox You should at least answer the following questions in your executive summary: How is our social media adwerting performing? Should we Increase our social media advertising budget? Why/sy not? . Should we allocate more of our budget to a specific platform? Which onefaj? Why? Should we allocate last of our budget to a specie platform? Which onets? Why? Should we allocate more of our budget to specific days of the week? Which one? Why Should we locaties of our budget to a specife day of the week? Which ones? Why? Bonus QuestionIf we didn't increase ou total budget, but we located the funds from the worst performing platform to our best performing platform to the best performing day of the wee how would impact ou total OS pro Tip: You will males copy of the original data, mely the databased on your finding and recette ROAS Final Deverb MacBook Air P co 2 3 5 7 2 w E R R T Y C S D F F G H I N N C