Reporting + analytics CRM Odoo: dashboard, KPI, win/loss (guida 10 di 15)

Ottantatreesima guida operativa Odoo 19 per PMI italiane. Decima della serie 15 guide CRM Odoo. “Cosa misuri lo gestisci.” Sales without analytics = guessing. Sales con dashboard CRM = decisioni informate, coaching mirato, ottimizzazione continuativa. Odoo CRM include reporting nativo potente: pipeline analytics, conversion funnel, win/loss analysis, sales velocity, KPI per team/owner. In questa guida vediamo come usare bene questi strumenti per gestire sales in modo data-driven nella PMI italiana.

Vediamo: pipeline analytics, leads aggregate, opportunity detail, team performance, sales KPI dashboard, casi pratici PMI italiane.

Pipeline analytics: vista d’insieme

Pipeline kanban + lista mostra opportunity per stage. Aggregate per team, owner, segment. Counter + revenue per colonna. Health della pipeline visibile a colpo d’occhio. CEO + Sales Manager + AE guardano stesso schermo:

• Counter opp per stage
• Revenue sum per stage
• Color coding priority
• Filter team/owner/period
• Drill-down su single opp
• Compare period over period
• Export Excel per analisi advanced

Opportunity detail analytics

Ogni opp ha analytics dedicato: tempo in ogni stage, activity history, email engagement, expected vs actual. Insight per coaching + diagnostics. Pattern detection da histories aggregate:

• Time-in-stage tracking
• Activity count + types
• Email engagement metrics
• Quote history + outcomes
• Stakeholder mapping
• Communication frequency
• Risk indicators

Leads aggregate report

Vista lista leads con grouping e filter avanzati. Pareto analysis per source, segmentation per criteria, conversion rate per channel. Marketing-sales alignment dashboard:

• Group by source/campaign/team
• Filter by date range
• Conversion rate per group
• Cost per lead computation
• Revenue attribution
• ROI marketing channel
• Pivot table flexible

Team performance dashboard

Per ogni team/rep: opportunity count, revenue weighted, win rate, average deal size, cycle time. Comparison tra rep + tra periodi. Identify top performer + struggling. Base per coaching:

• Opportunity count per rep
• Weighted revenue per rep
• Win rate per rep
• Average deal size per rep
• Cycle time per rep
• Activity volume per rep
• Quota attainment %

Sales KPI dashboard executive

Dashboard high-level per CEO/CFO: revenue trend, pipeline coverage, forecast vs target, top customers, churn risk. Refresh real-time. One screen for executive decisions:

• Revenue MTD/QTD/YTD
• Forecast vs target gap
• Pipeline coverage ratio
• Win rate trending
• Customer concentration
• New business vs renewal
• Cash conversion cycle

Le 10 metriche essenziali CRM

Top-of-funnel

• 1. Lead volume: contatti generati per period
• 2. Cost per lead: spend marketing / lead
• 3. Lead-to-MQL conversion: % qualified

Middle funnel

• 4. MQL-to-SQL conversion: sales accept rate
• 5. Opportunity count: qualified deals
• 6. Average deal size: revenue per opp

Bottom funnel

• 7. Win rate: closed-won / total closed
• 8. Sales cycle length: days creation → close
• 9. Sales velocity: (opp × value × win%) / cycle

Health

• 10. Pipeline coverage: pipeline value / target ratio

Win/Loss analysis

Loss reasons aggregate

• Top 5 reasons per losing
• Percentage per reason
• Trend over time
• Per segment/product

Win patterns

• Common characteristics deals won
• Product mix preferred
• Decision factors
• Cycle time average

Actionable insights

• Identify problem stages (high loss)
• Training needs per loss reason
• Product positioning adjust
• Pricing strategy refinement

Sales velocity formula

La formula

• SV = (Opp × Average Deal × Win Rate) / Sales Cycle
• Esempio: (100 × 25k × 25%) / 60 days = 10.4k €/day
• Single metric che cattura sales health

Improvement levers

• Aumentare opportunities: marketing + outbound
• Aumentare deal size: upsell + premium
• Aumentare win rate: training + qualifying
• Ridurre cycle: process + automation

Dashboard customization

Custom views

• Pivot table flexible
• Graph view (bar, pie, line)
• Kanban customizable
• List with grouping

Custom filters

• Save filter for reuse
• Share filter con team
• Filter combinabili
• Domain logic Python

Studio for custom dashboard

• Drag-and-drop builder
• Multiple widget types
• KPI cards
• Real-time refresh

External BI integration

Quando serve

• Multi-source data (CRM + ERP + marketing)
• Advanced analytics (predictive)
• Cross-functional dashboard
• Stakeholder esterni (board, investor)

Tool comuni

• Power BI: Microsoft ecosystem
• Tableau: enterprise grade
• Metabase: open source
• Looker Studio: free + GCP

Integration

• Odoo API REST/XML-RPC
• Direct database query
• Scheduled extracts
• Real-time webhooks

Errori comuni reporting CRM

“Vanity metrics”

Problema: track lead volume only, no conversion measurement.
Soluzione: focus actionable metrics + full funnel view.

“Reports senza action”

Problema: dashboard guardati, nulla cambia.
Soluzione: weekly review + specific action items.

“Data quality scarsa”

Problema: report based on incomplete/dirty data.
Soluzione: data hygiene rules + cleanup periodico.

“Troppi KPI”

Problema: 50 metriche, nessuna actionable.
Soluzione: focus 10 essenziali, monitor weekly.

“No win/loss analysis”

Problema: lost deal closed senza learning.
Soluzione: structured win/loss review process.

Casi pratici PMI italiane

Caso 1 — SaaS: data-driven culture

• 10 KPI essential tracked weekly
• Win/loss review monthly
• Sales velocity benchmark
• Sales productivity +35% in 18 mesi

Caso 2 — Manifattura B2B: pipeline coverage

• 3.5x pipeline coverage target
• Quarterly review strategic
• Loss reason analysis triggers
• Win rate +12 points

Caso 3 — Servizi: forecast accuracy

• Weekly forecast review
• Accuracy 30gg: 92%
• Coaching basato su data
• Investor confidence

Caso 4 — E-commerce B2B: real-time

• Dashboard always-on
• Alert su anomalie
• Action immediate
• Sales velocity +50%

FAQ

Reporting Community vs Enterprise?

Community: list, pivot, graph view native. Enterprise: dashboard, charts avanzati, Studio customization. PMI tipica: Community sufficiente per setup base, Enterprise per scaling.

Sales velocity quanto target?

Industry-specific. SaaS: 1-3k €/giorno per rep. Manifattura: variable, valore alto. Track over time + benchmark interno.

Pipeline coverage ratio ideale?

3-4x quota tipico. Sotto 2x: rischio missed quota. Sopra 5x: forse low quality opp inflate. Sweet spot 3-4x.

Quanto spesso review reports?

Daily: tactical metrics (pipeline, activities). Weekly: forecast, team performance. Monthly: strategic (win/loss, velocity). Quarterly: deep dive.

Posso esportare reports per board?

Sì, multi-format: PDF, Excel, immagine. Schedule auto-send (Enterprise). Custom branding template. Insight summary writing tip.

Prossimi passi

Nella prossima guida (11/15 serie CRM) vedremo multi-team sales organization: setup teams, permissions, territory management, lead routing inter-team, KPI per team.

Vuoi sales data-driven nella tua PMI?
G Tech Group implementa reporting + analytics CRM Odoo per PMI italiane: dashboard custom, KPI framework, win/loss analysis, coaching data-driven. Track record di sales velocity +30-50% post-implementation.
Richiedi un preventivo gratuito oppure prova la nostra demo Odoo 19 live. Oppure prova Odoo direttamente su odoo.com (link partner Brentasoft).