Question: 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, FY20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
