Here is the background information on your task

A big part of any marketing campaign is data. Your team is constantly collecting data on products, trends, competitors, and consumers, and this information is critical to any successful marketing operation. As a junior$-$level team member, you are responsible for helping to analyze data and draw conclusions based on your findings.

Some of the data most important to marketers are:

Customer conversion rates, customer acquisition costs, return on investment, cost per lead, customer lifetime value, click$-$through rate, bounce rate, session time, unsubscribe rate, and more.

Check out this link if you would like to learn more about these metrics.

It's important to know what metrics are most important to your campaign. For example, if you are doing a website overhaul, you would care about metrics such as session time and conversion rate. If you're trying to optimize email campaigns, you would want to track items such as click$-$through rate, bounce rate, and unsubscribe rate.

For this task, we are going to be focused on conversion rates, customer acquisition costs, and return on investment.

Here is your task

Before finalizing the new local ambassador program, your manager has asked you to review data from last quarter's ambassador efforts. You will find the data you'll need to review for this task in the $$Ambassador Marketing Sheet.$$ Please note: this data is fictional.

Using this information, please calculate the customer conversion rates, customer acquisition costs, and return on investment. You should also calculate the averages and the minimum and maximum for these metrics. Note these cells are highlighted in grey in the spreadsheet.

Submit your Excel sheet below.