Home › Blog › The five Salesforce reports every CRO should bookmark on Monday

The five Salesforce reports every CRO should bookmark on Monday

Five Salesforce reports are enough to run a Monday operating meeting. The Tableau dashboard the BI team built is good at explaining last quarter, but it will not tell you which deals need a call this week. Below are the five, how to build each one, and the mistake that most often makes each one wrong.

1. Pipeline coverage by segment

Pipeline coverage measures open pipeline in the current and upcoming quarter relative to quota for those periods. Target coverage is 3x to 4x quota for the current quarter and 3x for the next. Coverage below 2.5x indicates that the revenue target is mathematically at risk regardless of subjective sales sentiment.

Build: Report on Opportunities grouped by Segment, then by Close Quarter, summing Amount. Compare this against quota targets stored in a Quota object or custom field. Display the coverage ratio (Pipeline ÷ Quota) per segment per quarter, with conditional formatting thresholds at 2.5x, 3x, and 3.5x.

What to look at first: Any segment below 2.5x coverage in the next quarter. Current-quarter shortfalls cannot be resolved with newly generated pipeline because those opportunities will not close in time. Next-quarter deficits identify where prospecting effort must increase immediately.

Trap: Including Closed Won deals or Stage 1 (Prospecting) deals in the calculation. Closed Won deals overstate open pipeline, while Stage 1 deals with sub-10% historical conversion distort coverage with unvalidated volume. Filter the report for Stage greater than or equal to 2 and Stage less than 7 (Closed) to restrict the calculation to qualified opportunities.

2. Deals aged out of stage

Average stage duration varies by segment. When a Stage 4 opportunity remains stationary for 90 days against a segment benchmark of 35 days, the deal is stalled in procurement or effectively lost. Reviewing aged opportunities weekly exposes stagnant pipeline before reps commit and subsequently slip the revenue.

Build: Filter an Opportunities report to open deals, incorporating a formula field for Days In Current Stage (TODAY() - LastStageChangeDate). Group by Stage and Segment. Filter for records where Days In Current Stage exceeds 1.5x the segment-stage benchmark. A 20 to 50 rep organization can store benchmark averages either in a custom object or as hardcoded constants directly in the formula.

What to look at first: The highest-value opportunity with the highest stage duration. A single outsized deal often represents over half of the stalled pipeline value and requires immediate review between sales leadership and the account executive.

Trap: Calculating duration using CreatedDate rather than LastStageChangeDate. Overall deal age does not reflect stage velocity. An opportunity that moved through stages quickly is fundamentally different from one that has remained stuck in a single stage for months. Always calculate duration from LastStageChangeDate.

3. Win rate by source by ICP

Aggregate company-wide win rates obscure funnel performance. Conversion rates diverge across lead sources, market segments, industries, and deal sizes. Segmenting win rate by lead source and ideal customer profile (ICP) tier isolates the combinations that convert efficiently from those that consume sales capacity without producing results.

Build: Create a matrix report on Opportunities with Lead Source as rows, ICP Tier (1, 2, or 3) as columns, and Win Rate (Closed Won ÷ Total Closed) across the trailing 12 months in the summary cells. Filter for cells with at least 20 closed deals to prevent sample-size distortion. Use a full 12-month trailing window, as shorter periods introduce excessive noise.

What to look at first: Combinations showing high volume alongside high win rates, which indicate where to increase lead-generation investment. Next, evaluate high-volume combinations with low win rates, which identify where sales effort is being spent on opportunities that do not close.

Trap: Weighting all deals equally regardless of size. A 70% win rate on $20,000 deals and a 30% win rate on $200,000 deals are not equivalent. Build a parallel report that measures revenue-weighted win rate (Closed Won Revenue ÷ Total Closed Revenue). Comparing transaction count win rates against revenue-weighted win rates highlights whether sales execution succeeds primarily on small transactions while failing on core revenue targets.

4. Churn pipeline

Renewals require unifying data across departmental silos. Customer Success tracks account health, Sales monitors contract expiration dates, and Finance manages recurring revenue. The churn pipeline report unifies these inputs into a single operating view: every active customer expiring within 120 days, their health score, the renewal contract value, and the status of the renewal opportunity.

Build: Report on Accounts filtered for active customers with contract end dates within 120 days. Join the CSM health score field, the renewal opportunity ID, and the most recent CSM activity log. Sort ascending by health score to place highest-risk accounts at the top of the report.

What to look at first: High-value accounts (Tier 1 ARR) showing low health scores where no renewal opportunity has been created in the pipeline. Accounts in this state represent imminent revenue attrition where sales intervention has not yet begun. Assign an account executive immediately.

Trap: Excluding contracts with auto-renewal clauses. Auto-renew contracts churn at higher rates than expected because customers frequently cancel within the final 30 days upon reviewing invoice terms. Maintain all expiring contracts on this report regardless of auto-renew status.

5. Rep activity vs quota attainment scatter

Evaluating sales rep performance requires measuring effort alongside results. Plotting activity volume (calls, emails, or meetings over the trailing 30 days) on the horizontal axis against quarterly quota attainment percentage on the vertical axis segments the sales team into four distinct performance profiles: high activity with high attainment, high activity with low attainment, low activity with high attainment, and low activity with low attainment.

Build: Create a report on Users with calculated fields for trailing 30-day activity (aggregated from Tasks and Events) alongside current-quarter quota attainment percentage. Display the results using a scatter chart. While native Salesforce charts do not label quadrants explicitly, the four sectors segment the team visually.

What to look at first: Any rep who has been in the high-activity, low-attainment quadrant for more than two quarters. Sustained high effort paired with low conversion indicates execution or qualification breakdowns rather than motivation deficits. Place these reps into a four-week MEDDPICC inspection program managed directly by sales leadership.

Trap: Evaluating activity volume without measuring engagement efficiency. A rep logging 80 calls a week at a 10% reach rate has 8 conversations. A rep logging 50 calls at a 25% reach rate has about 12. The first rep looks busier on the activity axis, and the second is getting more done. Incorporate reach-rate or response-rate metrics before drawing conclusions from activity volume alone.

What goes on the Monday agenda

The five reports above address five operational questions in sequential order:

1. Are upcoming quarters mathematically covered? (Pipeline coverage)
2. Which specific deals have stalled and risk slipping? (Aged out of stage)
3. Where is the funnel converting efficiently? (Win rate by source by ICP)
4. Which renewal accounts present immediate churn exposure? (Churn pipeline)
5. Which sales reps require tactical coaching or pipeline inspection? (Activity vs attainment)

Allocating three minutes to each report provides a comprehensive operational assessment in fifteen minutes. Reviewing these five views prior to the 9am operating meeting establishes a factual baseline for deal inspection, resource allocation, and forecast validation.