The CRM Reports Every Sales Leader Should Be Looking at Weekly

Most sales leaders check too many reports or too few. The ones who check too many spend time on data that does not drive decisions. The ones who check too few fly blind on things that are quietly going wrong. Neither extreme serves the team or the business.

A weekly CRM review discipline is not about volume of data — it is about signal. What specifically tells you that the quarter is on track, that a rep needs support, that a deal is at risk? Those are the reports worth building a weekly habit around.

Here is the short list that matters, with the reasoning behind each one.

1. Pipeline by Stage with Velocity

What it shows: The number and total value of opportunities in each pipeline stage, plus how long deals have been in each stage.

Why it matters weekly: A pipeline snapshot tells you what exists. Velocity tells you what is moving. A deal in “Negotiation” for 90 days is a very different situation than one that moved from “Demo Scheduled” to “Proposal Sent” in 10 days. Stage age is the metric most leaders look at too infrequently.

What to look for: Deals accumulating in middle stages without movement. A bulge of stale deals in a specific stage often indicates a process problem at that stage — a common objection that is not being resolved, a resource bottleneck (a technical reviewer, a legal team, a procurement process), or a rep who is not advancing deals proactively.

Frequency: Weekly minimum. Review stage age not just current count.

2. Deals with No Recent Activity

What it shows: Opportunities where no activity — call, email, meeting, note — has been logged within a defined window, typically 7 to 14 days for active deals.

Why it matters weekly: This is the earliest signal of a deal going quiet. Deals do not die loudly. They go cold gradually, through inaction, until both sides have mentally moved on. A weekly review of no-activity deals lets you intervene before the deal is truly dead.

What to look for: Deals with high value that have been untouched for more than two weeks. Reps with consistently high counts of no-activity deals — this is a coaching signal, not just a data cleanup item.

Deal Stage	Max Acceptable Days Without Activity
Prospecting	14 days
Discovery / Qualification	10 days
Proposal / Demo	7 days
Negotiation / Procurement	5 days
Closing	3 days

These thresholds are a starting point. Adjust them based on your average sales cycle length.

3. Forecast vs. Target with Close Date Tracking

What it shows: The total pipeline value expected to close in the current period, compared to the team’s target, with close date changes highlighted.

Why it matters weekly: Close dates are the most frequently manipulated field in a CRM, not necessarily out of bad faith but because reps adjust them as deals shift. Tracking close date changes week over week tells you whether your forecast is genuinely converging toward close or being maintained artificially through date pushes.

What to look for: Deals that have had their close date moved more than twice in the last 60 days. A deal that keeps slipping is either misqualified, stuck on a decision the rep cannot influence, or reflective of a prospect who is not actually buying in this period.

Specific action: Discuss close date pushes in your weekly pipeline review. Not to challenge reps, but to understand what is driving the slip and whether there is something you can do to help advance the deal.

4. New Opportunities Created This Week

What it shows: Opportunities entered into the CRM in the past seven days, including owner, source, and estimated value.

Why it matters weekly: New opportunities are the leading indicator for future revenue. Quota coverage — having enough pipeline to realistically hit your target — requires a specific rate of new opportunity creation. If that rate drops for two or three weeks running, you have a forward-looking problem that needs attention now, not at quarter end.

What to look for: Whether each rep is creating new opportunities at a rate consistent with their historical average. Whether the source distribution of new deals is shifting in ways that might indicate a channel problem or opportunity. Whether deal sizes are trending up, down, or flat.

5. Win/Loss Summary for Closed Deals

What it shows: Deals closed in the past week — both won and lost — along with close reason, deal value, and owner.

Why it matters weekly: Win/loss data is most valuable when reviewed close to the close event. Memory is better. The rep can speak to what happened with more accuracy. Patterns in loss reasons are most actionable when looked at week by week rather than aggregated quarterly.

What to look for: Loss reasons that cluster around a specific objection (pricing, competitor, timing, internal champion lost). Win reasons that you can replicate and reinforce. Deals closed to specific stages beyond “Closed Lost” that can be reviewed in future periods if circumstances change.

Common mistake: Reviewing wins more carefully than losses. Losses are where the most useful intelligence lives.

6. Rep-Level Activity Summary

What it shows: Per-rep counts of calls, emails, meetings, and new opportunities for the week, compared to the prior week and a target baseline.

Why it matters weekly: Activity volume is a process indicator, not a performance indicator. But a rep whose activity has dropped significantly — and whose pipeline is not moving — is a rep who needs attention before the problem shows up in numbers.

What to look for: Significant week-over-week drops in a rep’s activity. Reps with high activity but low pipeline progress (may indicate targeting or qualification issues). Reps with low activity but advancing deals (sometimes a sign of quality over quantity — do not reflexively treat this as a problem).

Important caveat: Activity data is only as clean as your CRM’s logging practices. If reps do not log everything, this report understates their actual work. Use it as a relative indicator between periods and reps rather than an absolute measure.

Building the Weekly Habit

Looking at these reports once and then forgetting them is not a discipline — it is a data pull. The value comes from the cadence: same reports, same time, every week. This reveals trends that are invisible in a single snapshot.

A practical approach:

• Reserve 30 minutes on Monday morning for CRM review before the weekly team call.
• Build a dashboard that contains all six report types in one view, so you are not navigating between screens.
• For each report, note one specific thing to act on or ask about in the team call.
• Keep a running note of what you observed each week — this creates the trend context that makes individual data points meaningful.

The team call becomes more useful when the leader has already reviewed the data and is asking specific questions rather than reviewing numbers cold in real time.

What These Reports Do Not Cover

These six reports cover the operational health of your current pipeline and team activity. They do not cover everything a sales leader needs. Separately, on a monthly or quarterly basis, you should be reviewing:

• Win rate trends over time (not just this week)
• Average deal size by segment, product, or rep
• Sales cycle length changes
• Source-level performance (which channels produce the most valuable deals)

Those are strategic metrics that require more time horizon to be meaningful. The weekly reports are the pulse check. The monthly and quarterly reviews are the health assessment.

Keep the weekly discipline tight and focused. The value of a weekly report is in its signal-to-noise ratio — if you are spending more than 30 minutes in the data each week, you are probably looking at too much.