Before you start the final exam, make sure you download the Excel file below. Many questions will be based on this file.
- Hello!
Before you start the final exam, make sure you download the Excel file below. Many questions will be based on this file.
0 of 39 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 39 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Bummer, you didn’t pass the final exam. That’s okay, try taking it again! You can do it!
Congrats on passing the final exam! You can download your certificate which is found on the My Courses page and also on this screen. You can also access the solution Excel file below:
Marketing Analytics Final Exam Workbook – Wisdify (Solution)
On Google Analytics, you see that of the 3,000 daily visitors to your sight, 90% are coming from one source. Is this a good or bad thing?
Looking at your Google Analytics, you notice that people are only spending 45 seconds on a key page and the bounce rate is 80%. Why might this be the case? (Select all that apply)
Below is a screen shot of the Google Analytics for one of our blog posts. What is the bounce rate for the webpage.
Below is a screen shot of the Google Analytics for one of our blog posts. How would you say the bounce rate is for this page?
What is the definition of net promoter score (NPS)?
Using the post below, what is the click-through-rate?
You ran an ad on Facebook and the results are shown below. What was the total amount spent on this ad?
You ran an ad on Facebook and the results are shown below. Let’s suppose you gained 5 new leads (email addresses) from the campaign. What was the cost-per-lead?
Last month, you gained 20 new customers. You spent $3,000 in Facebook ads, $500 in marketing software, and allocated $750 in salary expenses to the efforts. What was the total customer acquisition cost?
Refer to the Final Exam Workbook. For the month of September, how many clicks did the ad receive?
Refer to the Final Exam Workbook. What was the amount spent on the paid-per-click campaign?
Refer to the Final Exam Workbook. For this PPC campaign, what was the cost-per-click for the month of September?
Refer to the Final Exam Workbook. How many new customers did we acquire from this PPC campaign?
Refer to the Final Exam Workbook. What % of the clicks converted into a customer?
Refer to the Final Exam Workbook. What was the cost to acquire a new customer (customer acquisition cost)?
Refer to the Final Exam Workbook. Under Historical Data, we see that the average customer spends $242.20 each year. What is the gross profit on this?
Refer to the Final Exam Workbook. Under Historical Data, what is the customer lifetime value?
What is the definition of customer acquisition cost (CAC)?
What is the most effective metric to use to understand the return of a marketing initiative?
A recent net promoter score study of Gandalf the White returned the following ratings:
What is the company’s net promoter score (NPS)?
What would a negative net promoter score for a product indicate?
What will be the result if the customer acquisition cost is perpetually higher than the customer lifetime value?
How should, theoretically, a high net promoter score (NPS) affect the customer acquisition cost (CAC) and customer lifetime value (CLV)?
If you don’t know the company’s discount rate to calculate the customer lifetime value (CLV), which rate is a good rule-of-thumb?
A marketing campaign cost $100,000 in ads, $25,000 in consultants, and $25,000 in allocated personnel costs. As a result of this campaign, the company generated $500,000 in revenue. What was the marketing return on investment (ROI)?
Using the post below, what is the engagement rate?
Why should you never, ever manually type in (hard-code) a number into a formula when building a model? (Select all that apply)
What is the purpose of a dashboard?
What is the definition of customer lifetime value (CLV)?
Why is it absolutely essential you know what your customer lifetime value (CLV) is?
Having a high net promoter score (NPS) helps you gain:
Rearrange the below formula to create the correct formula to calculate the customer retention rate.
View Answers:
The average customer spend $400 and the average gross profit at the company is 70%. What were the total cost of sales?
Based on the below information, what is the customer lifetime value?
What does break even tell us?
In order to cover the company’s overhead expenses, what should be the minimum ROI of a marketing initiative?
What does creating a Data Table (sensitivity analysis) allow us to do?
A company has a yearly churn rate of 25%. What does this mean?
What should the font color of any cell that is an assumption (which can be changed) or hard input be?