Notes for owners · Sales management
How to create a sales dashboard for management
A management dashboard answers five questions on one screen: what came in, what is moving, what is stuck, what will close, and who needs help this week.
The GullySales team · Updated 15 Sept 2026 · 6 min read
On this page
A management dashboard exists to answer five questions on one screen: what came in, what is moving, what is stuck, what is likely to close this month, and who on the team needs help this week. Anything that does not serve one of those five belongs in a monthly appendix. Build it from stage definitions everyone agrees on, keep it to about ten numbers, and make sure every number has an action behind it. A dashboard that produces no decision is a screensaver.
The five questions, and the numbers that answer them
What came in. Enquiries this month by source, against the same month last year, and the share that were genuinely relevant. Sources include your website, search advertising, Meta, IndiaMART or JustDial, referrals, exhibitions and walk-ins.
What is moving. Open pipeline by stage, in value and in count, and how many deals moved forward since last week. Movement matters more than size. A large pipeline where nothing moved is a report on last quarter.
What is stuck. Deals with no activity for fourteen days, leads never contacted, and quotations sent more than thirty days ago with no answer. This is the most useful panel on the screen and the one most dashboards leave out.
What will close. Deals expected this month with a date and a next step, separated from deals expected this quarter. Ask for the next step, not the percentage. A deal with no scheduled next action is not closing whatever the probability field says.
Who needs help. Per salesperson: open leads held, first response time, calls or visits completed, quotations sent, and conversion from quotation to order. Used for coaching, not for public embarrassment.
A one-screen layout
| Panel | Numbers on it | The action it triggers |
|---|---|---|
| Enquiries | Count by source, month to date, against last year | Move media spend towards what produced relevant enquiries |
| Response | Average first response time, count of leads untouched | Reassign and escalate the same day |
| Pipeline | Open value and count by stage, deals moved this week | Work the stage where deals are piling up |
| Stuck | No activity 14 days, quotations open over 30 days | A named call list for the week |
| Closing this month | Deal, value, next step, date | Managerial help on the two largest |
| By person | Leads held, response time, quotations, conversion | One coaching conversation each |
| Conversion | Enquiry to qualified, qualified to quotation, quotation to order | Fix the weakest step, not all three |
| Cost | Cost per enquiry and cost per order, by source | Budget decision at month end |
| Won and lost | Orders won, orders lost, top three loss reasons | Pricing, product or process decision |
Nine panels, one screen, and every panel has a consequence.
Agree the definitions before you build anything
Most dashboards fail here rather than in the software. Write one line for each stage saying what must be true for a deal to sit in it. A quotation stage means a written quotation with a number has gone to the customer, not that a price was mentioned on a call. A qualified stage means you know the requirement, the rough budget and who decides.
Write down the source list and do not allow a tenth source called other. Agree what date a deal is counted on, the order date or the invoice date, and stick to it. This is where sales and finance usually produce different numbers, turning the review into an argument about data instead of a decision.
What does this look like in practice?
For example, a commercial printing company in Peenya, Bengaluru with five salespeople selling to pharmaceutical and food packaging customers. Its monthly meeting used to open with a pipeline figure of roughly ₹2.4 crore, an illustrative number, that never matched what was invoiced.
Building the dashboard showed why in one afternoon. Nearly half the pipeline value sat in deals with no activity for more than sixty days, mostly quotations sent to purchase managers who had never replied. Once a stuck panel was added, the Monday meeting changed shape. It began with a list of eleven customers to call rather than a total, and the pipeline number began to resemble the invoice book within two quarters. Nothing was added to the CRM. One report was added, and one field was made compulsory.
What to leave off
Vanity numbers that nobody acts on: total leads in the database, total contacts, website sessions, social followers. Twenty small charts that force the reader to interpret before deciding. Targets shown without the gap to target. The gap is the only part anyone acts on. Percentages without the underlying count, where a 50 per cent conversion rate turns out to be one deal out of two.
And leave off any number the team cannot see for themselves. A dashboard the salespeople cannot open produces suspicion rather than performance.
What to do next
Write the five questions on a sheet and, next to each, the single number you would want if you could only have one. Check whether your CRM can produce those five today. The ones it cannot usually point to a field nobody fills, which is a process fix rather than a reporting one. If you want the stage definitions agreed and a one-screen management report built from your own data, tell us what you need and we will look at what your current reports can and cannot tell you.
