Executive summary · TL;DR
A commercial dashboard is the single screen where the CEO and the sales manager read the health of the B2B pipeline every Monday. It contains 15-20 KPIs organised into four blocks: activity, pipeline, conversion and forecast. The numbers must update automatically from the CRM, not from a manual spreadsheet maintained by the sales assistant on Friday afternoons.
A sales dashboard done well is the difference between managing the commercial process by data and managing it by sensation. In the B2B SMEs I audit, the most common failure is not the lack of a dashboard but the proliferation of them: one in the CRM, another in Excel, another in PowerPoint for the monthly board meeting. None of them agrees with the others and nobody trusts any of them.
The fix is structural. One dashboard, twenty indicators, automatic data feed and a weekly cadence. The first three months are the hardest because data quality is exposed and the team complains. From month four on, the dashboard becomes the operating system of the commercial function.
The four blocks of a B2B sales dashboard
The 20 KPIs are organised into four blocks that answer four questions in this order: am I doing enough activity? do I have enough pipeline? am I converting properly? will I hit the number?
Block 1 · Activity (5 KPIs)
- Outbound calls / week per SDR.
- Outbound emails / week per SDR.
- Discovery meetings booked / week per SDR.
- Proposals sent / week per AE.
- CRM hygiene rate: % of opportunities with all mandatory fields filled and an updated next step.
Block 2 · Pipeline (5 KPIs)
- Total open pipeline in €, by stage.
- Pipeline coverage ratio: open pipeline / quarterly target (healthy range: 3x-4x).
- New pipeline created this month in €.
- Stale pipeline: opportunities without activity in the last 21 days.
- Average deal size in €, trend over the last six months.
Block 3 · Conversion (5 KPIs)
- MQL → SQL conversion rate.
- SQL → proposal conversion rate.
- Proposal → closed-won conversion rate (the master KPI).
- Average sales cycle in days, by ICP segment.
- Lost-deal reasons: top three reasons for closed-lost this quarter.
Block 4 · Forecast (5 KPIs)
- Committed forecast for the current quarter in €.
- Best-case forecast for the current quarter in €.
- Forecast accuracy: committed vs. actual at the close of the previous quarter.
- Sales velocity: (opportunities × deal size × win rate) / cycle length.
- Quota attainment per AE: % of target achieved year-to-date.
How to read the dashboard in the weekly meeting
The weekly pipeline meeting is 45 minutes, has a closed agenda and never starts late. The agenda goes block by block: first activity (does the team have enough at-bats?), then pipeline (is there enough coverage?), then conversion (are we losing in the same place again?), then forecast (will we hit the number?). The CEO does not need to attend every week, but the dashboard reaches their email every Monday at 09:00.
Where the data lives and how to feed the dashboard
The source of truth is the CRM. The dashboard is a Looker Studio, a Power BI report or a native CRM dashboard that reads directly from the CRM database. The rule is simple: if the data does not exist in the CRM, it does not exist on the dashboard. This rule alone fixes 70% of the CRM-hygiene problems within the first quarter.
Related: B2B sales consultancy: commercial process audit.
Authored by Ángel Ortega Castro · independent consultant in strategy, quality and digitalisation for SMEs.
Frequently asked questions
How does this apply to my SME?
It applies as long as you serve Spanish customers or process Spanish data; the framework is mandatory above thresholds we summarise in the table.
What does it cost in 2026?
Indicative ranges for SMEs 10-50 employees: 2,500-12,000 EUR for documentation + auditor fees vary by AENOR / BV / SGS / LRQA.
Which Spanish regulation applies?
BOE references RD 311/2022 (ENS), Regulation EU 2016/679 (GDPR), LOPDGDD, NIS2, DORA and the EU AI Act 2024/1689 depending on scope.
How long does the implementation take?
Average runs 4-7 months for a single ISO. Compound integrated SGI (9001+14001+27001) usually 8-12 months.
Can I co-finance it with Kit Digital or Kit Consulting?
Yes, Kit Consulting 2026 covers up to 24,000 EUR in advisory hours; Kit Digital covers tools (CRM, ERP, ciberseguridad) up to 29,000 EUR.
El marketing del cerebro es más predictible que el marketing de la opinión. — Ángel Ortega Castro