Sales analytics Odoo: dashboard, KPI, forecast, win/loss (guida 10 di 15)

Novantottesima guida operativa Odoo 19 per PMI italiane. Decima della serie Sales (15 guide). Sales analytics avanzato trasforma decisioni da gut feeling a data-driven: dashboard executive, KPI velocità vendita, forecast accuracy, win/loss analysis, pipeline coverage ratio. PMI italiana con analytics maturi vede revenue predictability +40%, sales productivity +25%, decision speed +60%. Vediamo dashboard, KPI core, forecast, marketing ROI, activity discipline.

Vediamo: dashboard executive Odoo, revenue analytics, pipeline coverage, marketing ROI, activity reporting, KPI core, casi PMI.

Dashboard executive Odoo

Il dashboard executive Odoo 19 è il command center per il management. Mostra KPI core (Quotations, Orders, Revenue, AOV) con trend % vs periodo precedente. Vendite mensili graph + top quotation + top sale orders. Aggiornamento real-time. Vista:

• 4 KPI cards: Quotations, Orders, Revenue, AOV
• Trend % vs periodo precedente
• Color coding (verde positivo, rosso negativo)
• Vendite mensili graph
• Top quotations + sale orders
• Sidebar nav per area
• Drill-down click per dettaglio

KPI dashboard tipici PMI

• Revenue MTD/QTD/YTD
• Pipeline coverage ratio
• Win rate vs target
• AOV (Average Order Value)
• Sales velocity
• Customer count trend
• Forecast vs actual

Revenue analytics: invoice graph

L’analisi revenue dettagliata via invoice graph mostra trend, distribuzione, anomalie. PMI può analizzare per cliente, prodotto, sales rep, periodo. Identifica concentration risk + opportunity di diversificazione. Graph fatturato:

• Trend revenue mensile
• Breakdown per cliente top
• Distribuzione per prodotto
• Sales rep contribution
• Outstanding receivable trend
• Aged AR analysis
• Cash collection rate

Concentration risk indicators

• Top 10% customer = X% revenue
• Top 5 customer = sotto 30%? OK
• Top 1 customer = sotto 15%? OK
• Sopra threshold = risk alto
• Diversification plan necessario

Pipeline coverage analysis

Il pipeline CRM consolidato mostra opportunità per stage. Pipeline coverage ratio (pipeline value / target quota) deve essere >3x per essere “healthy”. Sotto 2x = high risk miss quota. PMI tipica monitora settimanale. Vista pipeline:

• Pipeline value per stage
• Weighted forecast (% prob)
• Coverage ratio calculation
• Average deal size per stage
• Cycle time per stage
• Conversion rate stage-to-stage
• Stuck deals identification

Pipeline coverage benchmark

• 3x quota = healthy
• 4-5x = aggressive growth
• 2-3x = manageable
• <2x = miss high risk
• >6x = potentially inflated pipeline

Sales velocity formula

Formula

Sales Velocity = (# Opportunities × AOV × Win Rate %) / Sales Cycle Length (giorni)

Esempio PMI SaaS

• 30 opportunità attive
• AOV: 8.000€
• Win rate: 25%
• Cycle length: 45 giorni
• Sales Velocity: 1.333€/giorno

Leve per migliorare velocity

• Più opportunità (lead gen)
• AOV più alto (upsell)
• Win rate maggiore (qualification)
• Cycle ridotto (process)

Marketing ROI tracking

Le campagne marketing impattano direttamente il sales pipeline. Mailing trace analytics mostra performance per campagna: open rate, click rate, conversion to lead, conversion to deal. Closed-loop reporting essenziale. Vista marketing:

• Sent count per campagna
• Delivery rate
• Open rate (industry 20-25%)
• Click rate (industry 2-3%)
• Conversion to lead
• Conversion to opportunity
• Conversion to closed-won
• Revenue attribution

Marketing KPI hierarchy

• MQL (Marketing Qualified Lead)
• SQL (Sales Qualified Lead)
• SAL (Sales Accepted Lead)
• Opportunity created
• Closed-won deal
• Customer (active)

Activity discipline reporting

L’activity report mostra disciplina sales rep: chiamate fatte, email inviate, meeting completati. Correlazione activity-output diretta. Top performer tipicamente 3x activity vs bottom. Reporting per coaching:

• Activity count per rep
• Activity per tipologia
• Outcome conversion rate
• Avg response time
• Pipeline created per activity
• Best practices identification
• Coaching opportunity flags

KPI core sales

Top-of-funnel

• Lead volume: target weekly/monthly
• Lead quality score: average
• Source mix: marketing channel attribution
• Cost per Lead: total marketing / lead count

Middle-of-funnel

• Lead-to-opportunity: % qualification
• Opportunity creation rate: weekly
• Pipeline coverage: ratio vs quota
• Cycle length: avg days lead-to-close

Bottom-of-funnel

• Win rate: closed-won % of closed
• AOV: average order value
• Discount rate: avg discount applied
• Sales velocity: revenue/day

Post-sale

• Onboarding completion: %
• Time-to-value: days first success
• NPS: customer satisfaction
• NRR: net revenue retention

Forecast accuracy

Calcolo

Forecast Accuracy % = 100 – (|Forecast – Actual| / Actual × 100)

Benchmark

• 90%+ accuracy = excellent
• 80-90% = good
• 70-80% = acceptable
• <70% = process improvement needed

Migliorare accuracy

• Standardize probability stages
• Discipline opportunity update
• Manager review weekly
• Bottom-up + top-down reconciliation
• Track forecast vs actual quarterly

Win/loss analysis

Process

• Survey customer post-decision
• Capture reason in CRM
• Interview win/loss champion
• Trend analysis quarterly
• Actionable insights extracted

Win reasons tipici

• Product fit superior
• Price competitive
• Implementation speed
• Sales rep trust
• References strong

Loss reasons tipici

• Prezzo (50%+ casi)
• Feature mancante
• Timing wrong
• Competitor preferito
• Budget killed
• No decision (status quo)

Casi pratici PMI italiane

Caso 1 — SaaS B2B

• Dashboard executive + 8 KPI core
• Weekly pipeline review
• Forecast accuracy 88%
• Pipeline coverage 3.5x
• Decisioni data-driven sistemiche

Caso 2 — Manifattura B2B

• Customer concentration monitoring
• Sales velocity trend
• Win/loss quarterly analysis
• Strategic accounts deep-dive
• Forecast accuracy 91%

Caso 3 — Servizi consulenza

• Utilization rate tracking
• Project margin analytics
• Cross-sell rate per cliente
• NPS quarterly
• NRR 115%

Caso 4 — E-commerce

• Marketing ROI per canale
• Customer LTV per segment
• Cohort retention analysis
• Conversion funnel deep-dive
• CAC payback period 8 mesi

5 errori comuni sales analytics

1. Troppi KPI: 50+ metrics = nessuno actionable, paralisi
2. No baseline: KPI senza target/benchmark
3. Backward-looking only: storia OK ma forecasting weak
4. Silos sales/marketing: dati non integrati
5. No action plan: KPI rosso ma nessun decision

FAQ sales analytics

Quanti KPI servono?

5-10 KPI executive top-level. 15-25 operativi per management. Più di 30 = sovraccarico cognitivo. Drill-down on demand.

Real-time vs daily reporting?

KPI strategici real-time (dashboard). Reporting deep weekly per analisi. Monthly per board. Quarterly per strategic review.

Dashboard tool vs Odoo native?

Odoo dashboard sufficient per la maggior parte PMI. Power BI/Tableau per cross-data warehouse o cross-system advanced analytics.

Predictive analytics quando?

Dopo 12+ mesi historical data accumulati. AI lead scoring built-in Odoo Enterprise. ML custom per casi specifici. Investment vs ROI.

Forecast frequency?

Weekly per sales operations. Monthly per management. Quarterly per board. Annual budget cycle. Forecast accuracy migliorata con cadence.

Conclusione

Sales analytics maturi sono il sistema nervoso PMI growth-stage. Setup dashboard 3-7 giorni + ongoing refinement. ROI: revenue predictability +40%, decisions speed +60%, sales productivity +25%. La prossima guida (11/15) coprirà multi-warehouse sales: shipping rules, fulfillment optimization, inventory allocation.

Vuoi sales analytics avanzato nella tua PMI?
G Tech Group implementa Odoo sales analytics: dashboard executive, KPI tree, forecast accuracy, win/loss analysis, pipeline coverage, marketing ROI tracking. Discovery + setup + training executive team.
Richiedi un preventivo gratuito oppure prova la nostra demo Odoo 19 live. Oppure prova Odoo direttamente su odoo.com (link partner Brentasoft).