Metrics

Sales report for a small team: pipeline, activities and overdue follow-ups

The SautiDesk team
11 November 2026 · 9 min read

The short answer

A sales pipeline report shows how many leads were opened, won and lost, which have stopped moving and whose follow-ups are late. SautiDesk has four sales reports: Leads, Pipeline movement, Sales activities and Lead follow-ups. They need at least one lead and SautiDesk Pro, at KES 3,000 per person a month. Win rate is won divided by won plus lost.

A weekly sales report for a small team has to answer four things: what came in, what closed, what has stalled and who has not followed up. SautiDesk has four sales reports, one for each. Leads sits in the Records group of Reports, and Pipeline movement, Sales activities and Lead follow-ups sit in the Sales group. They are on SautiDesk Pro and appear once the workspace has a lead. Each figure below is given as the report works it out, followed by a fifteen-minute review a sales supervisor can run every week.

Which sales reports does SautiDesk have?

The four sales reports and where each sits. Source: SautiDesk Reports, 11 Nov 2026.
ReportGroupThe question it answers
LeadsRecordsHow is the pipeline doing: what was opened, won and lost, and what is still open?
Pipeline movementSalesHow far did leads get, how long do they sit in each stage and which have stopped moving?
Sales activitiesSalesWhat did the team do to move deals, and is anyone under their daily target?
Lead follow-upsSalesWhich next steps were done on time, late or missed, and who is overdue now?

All four take the usual dates: Today, Yesterday, Last 7 days, This month, Last 30 days or a custom range of up to 366 days, with a compare chip on by default. They have Export CSV, and Subscribe emails any of them daily, weekly or monthly. Reports open on a computer, and a person needs the Reports access. For the other reports a supervisor uses, see the call centre reports guide.

Leads: opened, won, lost and open now

Leads is the sales report to open first. Its four headline figures show how the range went and what is waiting.

Leads headline figures. Source: SautiDesk Leads report, 11 Nov 2026.
FigureWhat it counts
Leads openedNew leads in the range
WonLeads closed on a Won stage in the range, with the shillings won under it
Win rateWon ÷ (won + lost), with the number of leads closed under it
Open nowLeads still open, with the shillings in the pipeline under it

Open now is not limited to the dates you picked. It counts every lead opened before the end of the range that is still open. Values come from what the team entered on each lead, so the report is only as good as the values on the leads.

The tables break the range down. The list of leads can be filtered by Status: All, Open, Won or Lost, and shows the stage, owner, source, temperature (Hot, Warm or Cold), value and dates. Below it are Open pipeline by stage (leads, value, share and average age), By source and By owner (opened, open now, won, lost, win rate, won value and open value) and Why leads were lost. When lost leads have no reason, the report says so and asks the team to pick one next time.

A worked example with assumed numbers for one week.
LineFigureHow it is worked out
Leads won12Closed on a Won stage this week
Leads lost8Closed on a Lost stage this week
Win rate60%12 ÷ (12 + 8)
Leads still open30Open now, whenever they were opened

Pipeline movement: where leads stall

Pipeline movement shows how far the leads opened in the range got and how long they sit in each stage. Its headline figures are Stage moves, Reached Won (a share of the leads opened in the range), Time to win (the average from opened to won) and Stuck.

A lead is stuck when it is open and has not moved stage for 14 days, counted to today and not to the end of the range, so a past range still shows what is stuck now. The Stuck leads table lists each one with its stage, owner, value and how long it has been still. “Stage by stage” shows how many leads reached each stage, the average time in the stage, how many moved on, how many were lost from there and how many are stuck there now. “Where leads moved” shows the most common moves from one stage to another.

Recent leads may still be in progress, so the report notes it when none of the leads opened in the range has been won yet. Read Reached Won over a few weeks rather than one.

Sales activities: what the team did

Sales activities counts what people did on leads: things logged by hand, such as a visit or an offer, plus calls and messages sent from a lead. Its headline figures are Activities, Leads worked (leads with at least one activity), Per person a day and Of target.

Per person a day is the total divided by the people who logged something, divided by every calendar day in the range. Of target compares what each person did with the daily target set for that activity type. The target counts only the days the person logged that type, so a day off is not a miss. Daily targets are set in Settings, Sales, and the report asks you to set one when no activity type has a target. “By person”, “By type”, “Against daily targets” and “Recent activities” are the tables.

A worked example with assumed numbers for one week.
LineFigureHow it is worked out
Activities logged120By 4 people over 7 days
Per person a day4.3120 ÷ 4 people ÷ 7 days
Daily target for calls5Set in Settings, Sales
Calls done by one person20On 5 days they logged calls
Of target80%20 ÷ (5 × 5 days)

Lead follow-ups: how overdue follow-ups surface

A follow-up is a task attached to a lead. Lead follow-ups sorts them into four groups so late ones cannot hide. Its headline figures are Follow-ups due, Done on time, Overdue now and No next step.

How Lead follow-ups sorts each follow-up. Source: SautiDesk Lead follow-ups report, 11 Nov 2026.
GroupWhat it means
On timeDone, and completed on or before the due time
LateDone, but completed after the due time
MissedStill open, and the due time has passed
Still to comeStill open, and due later

The on-time rate is on time ÷ (on time + late + missed). Follow-ups still to come are left out, and a rate under 80% is shown in warning colour. With 18 on time, 4 late and 3 missed, the rate is 18 ÷ 25 = 72%. Overdue now counts every open follow-up past its due time as of today, and No next step lists open leads with no open follow-up, with the highest value first. Neither depends on the dates you picked.

The tables are Overdue follow-ups (when it was due, the lead, the type, the note, the owner and how late), By owner and Open leads with no next step. The owner is the person the task is assigned to, else the lead’s queue, else “Nobody”. The By owner table tints a row when that person has missed any, so a supervisor sees where to look in seconds.

How do you run a weekly pipeline review from these reports?

Pick a fixed time each week, set the dates to Last 7 days with compare on, and work down the four reports. The order matters: start with results, then find what has stalled, then see who has fallen behind.

  1. Leads (3 minutes). Note Leads opened, Won, Win rate and Open now against last week. Read Why leads were lost.
  2. Pipeline movement (4 minutes). Open the Stuck leads table. Give each stuck lead an owner and a date for its next move.
  3. Lead follow-ups (4 minutes). Open Overdue follow-ups and By owner. Ask each person with a missed follow-up to clear it today. Then give the highest-value leads with No next step a follow-up.
  4. Sales activities (4 minutes). Check Per person a day and Against daily targets. Coach the person who is under target on the days they worked.
  5. Subscribe. Subscribe to Leads and Lead follow-ups weekly, so the numbers reach you on Monday morning without opening anything.

A weekly sales report is only as good as the habit of logging. If the team does not move stages, log activities or set follow-ups, the reports are quiet because nothing was recorded, not because nothing happened. Leads that arrive from ads belong in the pipeline from the first message: see Click to WhatsApp ads into leads. If you are deciding whether a team needs a pipeline at all, read help desk vs CRM.

Start on SautiDesk

  1. Choose SautiDesk Pro at KES 3,000 per person a month. Leads, Sales and Reports are on Pro.
  2. Add your people and choose a Kenyan number for KES 500 a month.
  3. Switch Sales on in Settings, then set your stages, sources and lost reasons.
  4. Set a daily target for each activity type you want to track.
  5. Add your first leads, then open Reports after a week and run the review above.

The sales CRM page shows the pipeline the reports read from, and the pricing page lists every rate.

Keep reading

SoftwareHelp desk vs CRM: which does a Kenyan small business need?8 min readWhatsAppClick to WhatsApp ads: turn every ad chat into a sales lead7 min readMetricsCustomer service KPIs: the 12 numbers worth tracking10 min readTeamThe ten-minute morning check every supervisor should do6 min read

Frequently asked questions

A weekly sales report should show leads opened, leads won and lost with the win rate, leads still open with their value, leads that have stopped moving, and follow-ups that are overdue. In SautiDesk Pro these come from the Leads, Pipeline movement and Lead follow-ups reports.

Put calls, WhatsApp, SMS, email and web chat on one screen.

Incoming calls are free. Outgoing calls are KES 0.05 a second, paid from a balance you top up by M-Pesa or card.