What should a weekly sales report actually include so I can tell if my team is making real progress, not just staying busy?
The short answer
A useful weekly report has five numbers: new qualified opportunities created, total pipeline value and stage movement, activity-to-meeting conversion rate, deals closed won/lost with reasons, and forecast change versus last week. Activity counts (calls made, emails sent) belong in a dashboard, not the report leadership reads.
Why activity counts lie
Most weekly sales reports fail for one reason: they measure effort instead of movement. A rep who made 80 calls this week looks productive on paper even if zero deals advanced. Activity metrics (calls, emails, demos booked) are useful for coaching an individual rep, but they tell a founder or VP nothing about whether the business is closer to hitting its number. The fix is separating two reports: an activity dashboard for managers coaching reps day to day, and a weekly business report for leadership that only tracks outcomes.
The five numbers that actually matter
A weekly report worth reading in under three minutes includes these five things, in this order.
New qualified pipeline created this week — dollar value of net-new opportunities that cleared your qualification bar (budget, authority, need, timeline confirmed), not every lead that entered the CRM. If this number is flat or declining for two consecutive weeks while activity stays high, you have a conversion problem, not an effort problem.
Stage-to-stage movement — how many deals moved forward a stage versus stalled or moved backward. A pipeline where deals sit in the same stage for three-plus weeks is a pipeline that looks healthy in total dollar value but is actually dying slowly. Track this as a count, not a percentage, so small teams can see it at a glance.
Activity-to-meeting conversion rate — meetings booked divided by dials or emails sent. This is the one activity-adjacent metric worth keeping because it tells you whether the message and targeting are working, independent of how many hours someone put in. A rep converting 1-in-40 cold calls to a meeting has a messaging problem even if they're making 200 calls a week.
Closed won/lost with reason codes — not just the count, but why each deal closed the way it did: price, timing, competitor, no decision, champion left. Three months of reason codes is the single best diagnostic tool a sales leader has, and almost no small company tracks it consistently.
Forecast delta — this week's weighted forecast compared to last week's, and compared to quota-to-date. This is the number a board or investor actually wants, and it's the one most founder-led teams can't produce because their CRM data is too thin to weight accurately.
What this looks like in practice
| Metric | Good weekly signal | Warning sign |
|---|---|---|
| New qualified pipeline | Trending flat or up over trailing 4 weeks | Declining 2+ weeks in a row |
| Stage movement | Majority of open deals moved or closed | Deals sitting 3+ weeks in same stage |
| Meeting conversion rate | Stable or improving vs. prior month | Dropping while activity volume holds steady |
| Closed lost reasons | Diverse, specific, logged every time | "Other" or blank on most lost deals |
| Forecast delta | Moves in small increments, rarely swings | Big swings week to week (data hygiene issue) |
If your CRM can't produce four of these five numbers without a half-day of manual cleanup, the report isn't the problem — the system behind it is. That's a different fix, usually a CRM audit before a reporting-template rewrite.
Where SalesARC fits
SalesARC Perform (Basic $2,499/mo, Standard $4,999/mo, Enterprise $7,499/mo) provides fractional sales leadership that builds and runs this exact weekly cadence, including the reason-code discipline most teams skip because nobody owns enforcing it. If the underlying problem is that your CRM can't produce these five numbers cleanly, that's worth fixing first — a reporting template can't repair bad pipeline data. Learn more at /product/perform.