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.

Hi, I just need a step-by-step on how to complete question 2for excel. I'm having some issues. 2. Analyze the digital ad spend

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

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!