How to report on sales activity in a CRM
Three numbers, one page, same day every week. What an activity report should contain, the two metrics that quietly reward the wrong behaviour, and why the report is worth less than the conversation it starts.
Syncek Team · CRM reference library
/ 4 min read / Art. #87
Report on sales activity with three numbers, on one page, sent the same day every week: new deals created, deals that moved a stage, and deals with no next step. The third is the exception list, the only figure that names specific work. Together they answer the one question the report exists for: is enough happening, to the right deals, to hit the number. Most activity reports answer who has been busy instead, and that one is worth nothing.
The three numbers
New deals created. How much came in. Without it every other figure is a story about a shrinking pipeline told as if it were about effort.
Deals that moved a stage. Movement, not motion. A deal that got four calls and stayed where it was did not move, and the report should say so.
Deals with no next step. The exception list. This is the only number on the page that names specific work, and it is the one people act on.
You can add value and win rate later. Start here, because these three can be read in ten seconds and argued with immediately.
What to leave out
Calls made and emails sent, as headline figures. They measure keystrokes. Any metric a person can improve without helping a customer will eventually be improved that way, and activity counts are the easiest of all to inflate.
They are useful as a diagnostic once something looks wrong: a rep with movement and no activity is worth a question, and so is the reverse. As the top line they teach the team that the report is about looking busy.
Anything you cannot act on this week. A quarterly trend on a weekly report is decoration.
What goes on the weekly page, and what stays off it:
| Figure | On the report? | Why |
|---|---|---|
| New deals created | Yes | How much came in: without it, every other figure is a story about a shrinking pipeline told as if it were about effort |
| Deals that moved a stage | Yes | Movement, not motion: a deal that got four calls and stayed where it was did not move |
| Deals with no next step | Yes, at the bottom | The only number on the page that names specific work, and the one people act on |
| Value and win rate | Later | Start with the three that can be read in ten seconds and argued with immediately |
| Calls made and emails sent | Not as headline figures | They measure keystrokes, and work as a diagnostic once something looks wrong |
| Anything you cannot act on this week | No | A quarterly trend on a weekly report is decoration |
Where do the numbers in a sales activity report come from?
All three come from fields you already keep if the pipeline is in order: created date, stage, and a next step with a date. Nothing here needs a new field or a logging habit. If the report is hard to build, that is the finding. A CRM that cannot say which deals moved this week is a CRM where the stage is not being updated, and no reporting work will fix that.
Why does the cadence matter more than the contents?
The cadence matters more than the contents. A report that arrives on a predictable morning gets read; one that arrives when somebody remembers becomes an email people archive. One page. If it does not fit, the extra was not going to be discussed.
What is a weekly sales report actually for?
The report exists to start one conversation: which of these deals is stuck, and what would unstick it. If nobody changes what they do on Monday, you built a dashboard rather than a habit. That is also why the exception list belongs at the bottom of the report and not the top. The three numbers set the context, and then you spend the meeting on the deals that stopped moving, which is where the recoverable revenue is.
What makes a sales activity report misleading?
Reporting on a pipeline that has not been qualified. Activity against deals that were never going to buy looks identical to activity against real ones, and it looks like a healthy week right up until the quarter closes. Clean the qualification first. The report will get smaller and start being true.
Frequently asked questions
What should a sales activity report include?
Three numbers: new deals created, deals that moved a stage, and deals with no next step. Together they answer whether enough is happening, to the right deals, to hit the number. Count movement rather than motion, since a deal that got four calls and stayed where it was did not move. Value and win rate can be added later. These three can be read in ten seconds and argued with immediately.
What should you leave out of a sales activity report?
Calls made and emails sent as headline figures, and anything you cannot act on this week. Activity counts measure keystrokes, and any metric a person can improve without helping a customer will eventually be improved that way. They still work as a diagnostic once something looks wrong: a rep with movement and no activity is worth a question, and so is the reverse. A quarterly trend on a weekly report is decoration.
Which number in a sales activity report matters most?
Deals with no next step. That exception list is the only figure on the page that names specific work, which makes it the one people act on. New deals created and deals that moved a stage set the context for it. The conversation a report should start is about which of those deals is stuck and what would unstick it, because the deals that stopped moving are where the recoverable revenue is.
What data do you need for a sales activity report?
Three fields you already keep if the pipeline is in order: the date each deal was created, its stage, and a next step with a date. Nothing in the report needs a new field or a new logging habit. If the report is hard to build, that is itself the finding. A CRM that cannot say which deals moved this week is one where the stage is not being updated, and no reporting work will fix that.
How long should a sales activity report be?
One page, sent on the same day every week. If it does not fit on one page, the extra was not going to be discussed anyway. The cadence matters more than the contents: a report that arrives on a predictable morning gets read, and one that arrives whenever somebody remembers becomes an email people archive.
What is a sales activity report for?
Starting one conversation: which of these deals is stuck, and what would unstick it. Most activity reports answer a different question, who has been busy, and that one is worth nothing. The numbers are there to set up the conversation about the deals. If nobody changes what they do on Monday after reading the report, you built a dashboard rather than a habit.
Should you report on sales activity before the pipeline is qualified?
No, and doing it anyway is a common failure in activity reporting. Activity against deals that were never going to buy looks identical to activity against real ones, so the report shows a healthy week right up until the quarter closes. Clean the qualification first. The report will get smaller, and it will start being true.