Answered step by step
Verified Expert Solution
Question
1 Approved Answer
TutorMed is looking to spend $8,000 over the next 2 weeks on targeted advertisements to generate more sales leads, with a target return on ad
TutorMed is looking to spend $8,000 over the next 2 weeks on targeted advertisements to generate more sales leads, with a target return on ad spend (ROAS) of 300%. Your manager has tasked you to analyze current tutoring student data to determine the top three student demographics to target, as well as a proposed budget allocation plan.
no longer than one page
should have the following sections: demographic #1, demographic #2, demographic #3
Tutor Paid Actual Demographic Test Tutor Other Student # Hours Current Baselin Start End Load Target Score e Date Score Date Feedback Information Information Matching Information 4 V V V V V 4 4 V 4 V 4 1000001 Dallas Der TRUE 24.00 0.00 515 498 9/13 1/15 1-14-2021 2-15-2021 FALSE 509 11 4 1000002 Dallas Der TRUE 54.00 0.00 512 199 10/13 1/14 1-20-2021 2-22-2021 FALSE 505 6 4 1000003 Dallas Der TRUE 12.00 0.00 520 509 8/24 9/11 9-11-2021 10-12-2021 TRUE 518 9 1000004 Dallas Der TRUE 12.00 0.00 513 508 8/19 9/11 9-11-2021 10-12-2021 FALSE 514 6 4 1000005 Dallas Der TRUE 12.00 0.00 510 485 8/16 9/11 9-11-2021 10-12-2021 FALSE 490 4 1000006 Dallas Der FALSE 24.00 0.00 520 8/17 3/14 FALSE 4 1000007 Dallas Der TRUE 12.00 0.00 506 492 8/9 9/11 9-11-2021 10-12-2021 FALSE 504 12 4 1000008 Matthew Seeba TRUE 12.00 0.00 520 517 12/29 1/15 1-15-2022 2-15-2022 TRUE 522 5 4 1000009 Matthew Seeba TRUE 12.00 0.00 520 506 1 1/8 1/15 1-15-2022 2-15-2022 TRUE 526 20 4 1000010 Dallas Der TRUE 20.00 0.00 520 509 11/3 1/15 1-15-2022 2-15-2022 TRUE 522 13 1000011 Azaii Calderon TRUE 12.00 0.0 510 485 9/22 1/15 1-21-2022 2-22-2022 FALSE 484 -1 4 1000012 Marcy Forti TRUE 13.50 0.00 512 496 2/15 5/27 FALSE 4 1000013 Molly Hudash TRUE 7.00 .00 515 495 1 1/22 3/12 FALSE 3 1000014 Phil Hawkins TRUE 12.00 0.00 515 505 9/22 1/16 1-14-2022 2-15-2022 FALSE 3 1000015 Shane Khalid TRUE 6.00 0.33 510 506 3/4 3/12 3-12-2022 4-12-2022 FALSE w 1000016 Jordan Eidlisz TRUE 12.00 .00 520 513 12/13 3/8 3-12-2022 4-12-2022 FALSE 3 1000017 Matthew Seeba TRUE 6.00 0.00 505 491 1 1/30 1/22 3-12-2022 4-12-2022 FALSE 3 1000018 Jordan Eidlisz TRUE 12.00 0.00 520 512 11/15 3/12 3-12-2022 4-12-2022 FALSE 3 1000019 Matthew Seeba TRUE 12.00 0.00 510 11/10 1/21 3-12-2022 4-12-2022 FALSE 3 1000020 Warren Luc TRUE 12.00 0.00 515 503 10/21 3/12 3-12-2022 4-12-2022 FALSE 3 1000021 Matthew Seeba TRUE 12.00 0.00 515 505 12/13 1/14 3-25-2022 4-25-2022 FALSE 1000022 Dallas Der TRUE 8.00 0.00 515 80 3/18 3/25 3-25-2022 4-26-2022 FALSE w w 1000023 Alex Starks TRUE 21.00 0.00 516 507 3/14 3/25 3-25-2022 4-26-2022 FALSE W 1000024 Shane Khalid FALSE 6.00 0.0 512 509 3/9 3/25 3-25-2022 4-26-2022 FALSE 3 1000025 Kaylee Grant FALSE 6.00 0.00 515 513 3/1 3/25 3-25-2022 4-26-2022 FALSETest Student # End Actual Paid Current Baselin Tutor Other Tutor Hours Target Start Score Date Feedback Score Demographic Load Date Information Information Matching Information e V V A V 1 V 29 3 1000028 Kaylee Grant TRUE 12.00 .00 508 495 2/27 1/21 3-25-2022 4-26-2022 TRUE 30 3 1000029 Kaylee Grant TRUE 12.00 0.00 510 501 12/17 3/25 3-25-2022 4-26-2022 FALSE 3 1000030 Dallas Der TRUE 36.00 0.00 515 489 8/16 1/15 3-25-2022 4-26-2022 FALSE 31 32 3 1000031 Matthew Seeba FALSE 24.00 0.19 520 512 2/2 4/8 4-8-2022 5-8-2022 FALSE 33 1000032 Shane Khalid TRUE 12.00 .05 515 504 2/3 4/8 4-8-2022 5-10-2022 TRUE 34 3 1000033 Kaylee Grant TRUE 18.00 0.00 512 504 3/15 4/8 4-8-2022 5-10-2022 FALSE 35 3 1000034 Shane Khalid TRUE 12.00 0.00 515 513 3/3 4/8 4-8-2022 5-10-2022 FALSE 36 3 1000035 Sydney Whaler TRUE 12.00 0.00 512 509 2/16 4/8 4-8-2022 5-10-2022 FALSE 37 3 1000036 Brandon Seegn TRUE 81.00 0.00 508 485 2/1 1 4/8 4-8-2022 8-10-2022 FALSE 38 3 1000037 Kaylee Grant FALSE 12.00 .00 516 506 3/9 4/8 4-9-2022 5-10-2022 FALSE 39 3 1000038 Warren Luo FALSE 12.00 .00 515 507 2/16 3/25 4-9-2022 5-10-2022 FALSE 40 3 1000039 Shane Khalid FALSE 24.00 ).00 518 514 3/14 4/9 4-9-2022 5-10-2022 FALSE 41 3 1000040 Sydney Whalen TRUE 24.00 0.00 510 498 2/15 4/9 4-9-2022 5-10-2022 FALSE 42 3 1000041 Shane Khalid FALSE 12.00 0.00 508 491 1/10 4/29 4-29-2022 5-31-2022 FALSE 4/29 4-30-2022 5-30-2022 FALSE 43 3 1000042 Matthew Seeba TRUE 24.00 .00 510 500 3/25 5-29-2022 FALSE 44 3 1000043 Matthew Seeba FALSE 12.00 0.00 515 503 3/22 4/30 4-29-2022 45 3 1000044 Kaylee Grant TRUE 24.00 0.0 517 494 3/17 5/13 5-13-2022 6-14-2022 FALSE 46 3 1000045 Matthew Seeba FALSE 12.00 0.00 515 486 3/11 4/30 4-30-2022 5-30-2022 FALSE 47 3 1000046 Kaylee Grant TRUE 26.00 0.00 510 500 3/11 5/19 5-19-2022 6-21-2022 FALSE 48 3 1000047 Matthew Seeba TRUE 12.50 0.56 520 509 3/7 4/30 4-29-2022 5-29-2022 FALSE 49 3 1000048 Warren Luo FALSE 20.00 .00 510 504 3/7 5/27 5-27-2022 6-28-2022 FALSE 50 3 1000049 Sydney Whaler TRUE 24.00 ).26 515 513 3/3 5/23 5-19-2022 6-21-2022 FALSE 51 3 1000050 Kaylee Grant TRUE 36.00 0.00 515 513 3/1 6/4 6-4-2022 7-6-2022 FALSE 3 1000051 Kaylee Grant TRUE 39.00 2.09 505 484 12/13 7/30 8-5-2022 9-7-2022 FALSE 52 53 3 1000052 Kaylee Grant FALSE 24.00 0.00 512 499 12/8 5/13 5-13-2022 6-14-2022 FALSE 54 3 1000053 Dallas Der TRUE 24.00 0.00 514 501 9/3 4/30 4-30-2022 5-31-2022 FALSE 7-19-2022 FALSE 55 3 1000054 Dallas Der TRUE 30.00 0.00 518 482 8/19 6/17 6-17-2022 56 3 1000055 Shane Khalid FALSE 14 0.00 515 506 4-12-2022 21:33:57 2022-04-29 4-29-2022 5-31-2022 FALSE 57 2 1000056 Joseph Toth TRUE 24.00 0.00 515 500 3/24 4/30 FALSE 58 2 1000057 Matthew Seeba TRUE 12.50 0.00 505 496 3/24 6/18 FALSE 59 2 1000058 Taylor Nicholls FALSE 28.00 .00 505 497 3/23 5/14 FALSEBaselin Tutor Hours Current Demographic Test Tutor Other Student # Paid Target Start End Actual Score Date Feedback Score +/- Load Date Information Information Matching Information V V V V V V V V V V V V 59 2 1000058 Taylor Nicholls FALSE 28.00 0.00 505 497 3/23 5/14 FALSE 60 2 1000059 Kaylee Grant FALSE 20.00 0.00 512 484 3/23 6/4 FALSE 61 2 1000060 Taylor Nicholls TRUE 12.00 0.00 515 502 3/22 5/13 FALSE 62 2 1000061 Shane Khalid FALSE 48.50 11.66 510 498 3/22 6/30 FALSE 63 1000062 Kirsti Kaptein FALSE 48.50 0.00 510 496 3/22 6/4 FALSE NN 64 1000063 Dallas Der TRUE 1.00 0.00 515 493 3/16 7/29 FALSE 65 IN 1000064 Dallas Der TRUE 1.00 0.00 515 507 3/10 4/9 FALSE 66 1000065 Matthew Seeba FALSE 12.00 0.00 508 498 3/10 5-14 FALSE 67 NNN 1000066 Shane Khalid TRUE 12.00 0.00 510 502 2/28 4/9 FALSE 68 1000067 Matthew Seeba TRUE 24.50 0.00 512 500 2/28 4/29 FALSE 69 1000068 Matthew Seeba FALSE 24.00 0.28 505 498 2/28 5/13 FALSE 70 1000069 Shane Khalid FALSE 12.00 0.00 512 504 NNN 2/22 3/25 FALSE 71 1000070 Jordan Eidlisz FALSE 24.00 0.00 510 487 2/22 6/15 FALSE 72 IN 1000071 Matthew Seeba FALSE 12.00 0.00 515 2/10 3/25 FALSE IN 73 1000072 Taylor Nicholls TRUE 12.00 0.00 510 490 2/4 4/29 FALSE 74 2 1000073 Dallas Der TRUE 2.00 0.00 518 2/3 8/5 FALSE 75 2 1000074 Matthew Seeba TRUE 16.00 0.00 512 505 2/3 3/12 FALSE 76 2 1000075 Matthew Seeba FALSE 12.00 0.00 518 2/2 3/25 FALSE 77 2 1000076 Matthew Seeba FALSE 24.00 0.00 512 492 2/2 5/13 FALSE 78 1000077 Shane Khalid TRUE 12.00 .00 520 507 1/18 6/4 FALSE 79 1000078 Shane Khalid TRUE 24.00 5.60 520 511 1/13 6/24 FALSE NNNN 80 1000079 Shane Khalid FALSE 36.00 0.00 512 491 1/6 5/13 FALSE 81 1000080 Shane Khalid TRUE 36.50 .68 1/ 4 1/15 FALSE 82 1000081 Molly Hudash TRUE 1.00 0.00 524 480 1/4 5/27 FALSE IN 83 1000082 Matthew Seeba FALSE 24.00 2.90 524 509 12/31 7/30 FALSE NN 84 1000083 Jordan Eidlisz TRUE 43.00 0.00 518 499 12/30 /29 FALSE 85 IN 1000084 Jordan Eidlisz TRUE 24.00 0.00 510 12/29 5/19 FALSE 86 1000085 Molly Hudash TRUE 24.00 0.00 516 12/29 3/25 FALSE NN 87 1000086 Shane Khalid TRUE 48.00 1.04 516 483 12/16 5/27 FALSE 88 2 1000087 Molly Hudash TRUE 48.00 0.00 515 495 12/2 4/29 FALSE 89 IN 1000088 Jordan Eidlisz TRUE 24.00 0.00 518 488 11/16 4/30 FALSE 90 2 1000089 Shane Khalid FALSE 12.00 0.00 518 505 11/11 6/1 FALSEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started