SALES-CLOUD-CONSULTANT practice question 24 of 25
Universal Containers has implemented Salesforce for all of its sales reps. All sales reps are required to select the win or loss stage on every closed opportunity. Managers like to measure the win ratio for all of the sales reps. How should a consultant meet the requirement?
Full set: 190 questionsThe requirement is to calculate an aggregate metric—the win ratio—across a set of opportunity records for sales reps. The standard and most effective tool in Salesforce for such aggregate calculations is a report with a custom summary formula. This allows for the creation of a formula (e.g., WON:SUM / RowCount on a report filtered for closed opportunities) that dynamically calculates the ratio across the grouped records (e.g., by sales rep). This provides managers with a direct and accurate measurement without manual effort.
A. Ensure that all managers have access to the standard Win report. Standard reports show counts of won and lost deals but do not inherently calculate a ratio. This would require managers to perform manual calculations, failing to meet the requirement directly.
C. Create 3 custom formula field on Opportunity to capture the win ratio for opportunities. A formula field calculates a value for a single record. A win ratio is an aggregate metric across many records and cannot be calculated at the individual opportunity level.
1. Salesforce Help Documentation, "Calculate Ratios in Reports": This document provides a direct example of creating a win rate percentage. It states, "To find your sales team's win rate, create a summary formula that divides the number of won opportunities by the total number of opportunities closed." This confirms that a custom summary formula in a report is the correct method.
2. Salesforce Help Documentation, "Evaluate Reports with Formulas": This guide explains the different types of report formulas. It clarifies that "Summary formulas can be complex. You can build a summary formula that...calculates a percentage of a total." This distinguishes summary formulas, used for aggregate calculations like ratios, from row-level formulas.
3. Trailhead, "Reports & Dashboards for Lightning Experience" Module, "Use Summary Formulas and Bucket Fields" Unit: This educational module teaches that summary formulas are used to "calculate additional totals based on the numeric fields in your report." It provides examples of creating percentage calculations, which aligns directly with the requirement for a win ratio.
Keep practicing
Take the free SALES-CLOUD-CONSULTANT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SALES-CLOUD-CONSULTANT practice questions
- Question 1Universal Containers uses Sales Territories and is working with a consultant to reassign …
- Question 2The project at Universal Containers is almost finished and now it is time to test the cha…
- Question 3A consultant for Universal Containers is preparing to migrate the company's legacy CRM to…
- Question 4Cloud Kicks wants to set up contacts and accounts, where contacts can be associated to mu…
- Question 5Universal Containers has a fiscal year that starts in February and ends in January. The S…
- Question 6Universal Containers (UC) hired a consulting company to implement Sales Cloud. This will …
