Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I just need a step-by-step on how to complete question 2 for excel. I'm having some issues. 2. Analyze the digital ad spend by
Hi, I just need a step-by-step on how to complete question 2 for excel. I'm having some issues.
2. Analyze the digital ad spend by channel (see Ex. 9) for fiscal years 2019 and 2020. Use the existing data in Ex. 9 to create any new variable(s) you believe adds insight to your summary. View this exhibit as a digital marketing "funnel" where Leads are top of funnel (ToF) and Enrollment are bottom of funnel (BoF). What conclusions can you draw about the funnel's performance each year, and how (if at all) has that performance changed in 2020 versus 2019? 3. Analyze the digital ad spend by course (see Ex. 10a and Ex. 10b) for fiscal years 2019 and 2020. Use the existing data in Ex. 10a and Ex. 10b to create any new variable(s) you believe add insight to your summary. View this exhibit as a digital marketing "funnel" where Paid Leads are top of funnel (ToF) and Paid Enrollment are bottom of funnel (BoF). What conclusions can you draw about the funnel's performance each year, and how (if at all) has that performance changed in 2020 versus 2019 ? 4. Based on the above, what recommendation(s) can you give to Mohsen regarding how best to allocate the FY21 digital marketing budget across various digital channels (Ex. 9) and course offerings (Ex. 10)? 5. Share any additional insights or recommendations. Ex 9a: Digital Ad Spend by Channel, FY20 2. Analyze the digital ad spend by channel (see Ex. 9) for fiscal years 2019 and 2020. Use the existing data in Ex. 9 to create any new variable(s) you believe adds insight to your summary. View this exhibit as a digital marketing "funnel" where Leads are top of funnel (ToF) and Enrollment are bottom of funnel (BoF). What conclusions can you draw about the funnel's performance each year, and how (if at all) has that performance changed in 2020 versus 2019? 3. Analyze the digital ad spend by course (see Ex. 10a and Ex. 10b) for fiscal years 2019 and 2020. Use the existing data in Ex. 10a and Ex. 10b to create any new variable(s) you believe add insight to your summary. View this exhibit as a digital marketing "funnel" where Paid Leads are top of funnel (ToF) and Paid Enrollment are bottom of funnel (BoF). What conclusions can you draw about the funnel's performance each year, and how (if at all) has that performance changed in 2020 versus 2019 ? 4. Based on the above, what recommendation(s) can you give to Mohsen regarding how best to allocate the FY21 digital marketing budget across various digital channels (Ex. 9) and course offerings (Ex. 10)? 5. Share any additional insights or recommendations. Ex 9a: Digital Ad Spend by Channel, FY20Step 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