Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Treasury And Cash Management

Authors: Robert Cooper

1st Edition

1349512699, 9781349512690

More Books

Students also viewed these Finance questions

Question

Be prepared to address excessive absenteeism

Answered: 1 week ago