CRT-251 practice question 20 of 25

In a recent management meeting, the VP of sales voiced concern over the current economic environment. To better understand the effectiveness of its marketing efforts, the VP expressed a need to monitor and reduce churn going forward. Which strategy should a consultant recommend to address the VP's concern?

Full set: 190 questions
Answer options
A: Create a year over year sales by Account report.
B: Create an average stage duration by Opportunity report.
C: Create a Historical Trending report. Correct answer
Correct Answer:
C. Create a Historical Trending report.
Explanation

A Historical Trending report is specifically designed to monitor changes in key business metrics over time. To address the VP's concern about churn, a consultant can configure historical trending on the Opportunity object. This allows for a report that tracks changes in the Opportunity Stage and Amount over the last three months. Management can use this report to identify trends, such as an increase in the number of opportunities moving to 'Closed Lost' or a decrease in the pipeline's value, which are direct indicators of churn and sales effectiveness.

Why Incorrect

A. Create a year over year sales by Account report: This report shows past performance (a lagging indicator) but does not provide insight into the current pipeline's health or recent changes related to churn.
B. Create an average stage duration by Opportunity report: This measures sales velocity and process efficiency. It does not directly monitor the volume or value of churned (lost) opportunities over time.

References

1. Salesforce Help. (2023). Reports and Dashboards. "Track Changes in Your Business with Historical Trend Reporting". This document explicitly states that historical trending allows you to "report on changes to key business metrics over time," citing opportunities as a primary use case.

2. Salesforce Help. (2023). Set Up Historical Trend Reporting. This guide details the setup process, noting that for Opportunities, you can track historical data for Amount, Close Date, Forecast Category, Probability, and Stage. Tracking Stage changes is key to monitoring churn.

Scroll to Top