WorkestraDocs
ModulesCRM

CRM Analytics

Sales reports, pipeline metrics, win rates, and forecasting tools.

CRM Analytics

CRM Analytics provides comprehensive reporting on your sales performance, pipeline health, and team productivity. Make data-driven decisions with real-time insights.

Accessing Analytics

Navigate to CRM > Analytics (/crm/analytics).

Date Range Selector

All analytics support customizable date ranges:

PresetDescription
7 daysLast week
30 daysLast month
90 daysLast quarter
12 monthsLast year
All timeEntire history
CustomSpecific date range

Select a preset or use the date picker for custom ranges.

KPI Cards

Key metrics at a glance:

MetricDefinitionCalculation
Closed RevenueTotal value of closed-won dealsSum of deal values with status = closed_won
Pipeline ValueTotal value of open dealsSum of deal values with status = open
Win Rate% of deals closed successfullyClosed won / (Closed won + Closed lost)
Avg Deal SizeMean value of closed dealsTotal closed revenue / Number of closed deals

Click any KPI card to see the underlying data or trend over time.

Analytics Tabs

Pipeline Funnel

Visualize deal flow through your sales stages:

Funnel Chart:

  • Shows number of deals at each stage
  • Conversion rates between stages
  • Bottleneck identification

Reading the Funnel:

StageDealsConversionInsight
Discovery50Top of funnel
Qualified3570%Drop-off: 30%
Proposal2057%Major bottleneck
Negotiation1260%Healthy conversion
Closed Won867%Strong close rate

Click-Through: Click any funnel segment to view the specific deals in that stage.

Win/Loss Analysis

Understand why deals succeed or fail:

Win/Loss Ratio:

  • Pie chart of won vs lost
  • Trend over time
  • By rep, by source, by product

Loss Reasons:

Track and analyze why deals are lost:

ReasonCount% of Losses
Price1537%
Competitor1025%
No Budget820%
Timing512%
Other26%

Configure loss reasons in CRM Settings > Loss Reasons. Require reps to select a reason when marking deals lost.

Revenue

Revenue trends and breakdowns:

Revenue Trend Chart:

  • Line chart of closed revenue over time
  • Compare to previous period
  • Forecast line (AI-generated)

Revenue Breakdown:

BreakdownView
By MonthMonthly totals
By QuarterQuarterly summaries
By RepIndividual performance
By SourceLead source analysis
By ProductProduct line revenue

Team Performance

Individual and team metrics:

Leaderboard:

RankRepDeals WonRevenueWin Rate
🥇Alice12$120K60%
🥈Bob10$95K55%
🥉Carol8$110K67%

Individual Metrics:

For each team member:

  • Deals created
  • Deals won/lost
  • Revenue generated
  • Activities completed
  • Win rate
  • Average deal size
  • Sales cycle length

Forecasting

AI-powered deal predictions:

Forecast Categories:

CategoryConfidenceWeighting
CommitHigh90% of deal value
Best CaseMedium70% of deal value
PipelineLow30% of deal value

Forecast Calculation:

Forecast = (Commit × 0.9) + (Best Case × 0.7) + (Pipeline × 0.3)

Adjusting Forecasts:

  1. Review open deals
  2. Categorize each as Commit, Best Case, or Pipeline
  3. AI calculates weighted forecast
  4. Compare to quota/target

Activity

Activity metrics and trends:

Activity by Type:

TypeCountTrend
Calls150↑ 12%
Emails320→ 0%
Meetings45↓ 5%
Tasks200↑ 8%

Activity Correlation:

AI analysis showing relationship between activity and outcomes:

"Deals with 5+ activities in the first week have a 70% higher close rate."

Interpreting Charts

Pipeline Health Indicators

IndicatorHealthyWarning
Stage balanceEven distributionClumping in one stage
Conversion rates>50% between stages<30% drop-off
Deal velocityConsistent flowStagnation in stages
Win rate>40%<25%

Trend Analysis

Upward Trends (Positive):

  • Revenue increasing
  • Win rate improving
  • Deal size growing
  • Sales cycle shortening

Downward Trends (Negative):

  • Pipeline value shrinking
  • Win rate declining
  • Activity levels dropping
  • Overdue deals increasing

Click-Through to Data

All charts support drill-down:

  1. Click a chart segment or bar
  2. View filtered list of underlying records
  3. Further filter or export
  4. Take action on specific items

Click-through is the fastest way to act on insights. See a problem in the chart? Click to see the specific deals and take action.

Exporting Reports

Export Options

FormatUse Case
PDFPresentations, sharing
CSVSpreadsheet analysis
Image (PNG)Embedding in documents

Scheduling Reports

Set up automated report delivery:

  1. Configure your report view
  2. Click Schedule
  3. Set frequency (daily, weekly, monthly)
  4. Add recipients
  5. Save schedule

Custom Reports

Building Custom Views

  1. Start from any analytics tab
  2. Apply filters and date ranges
  3. Click Save View
  4. Name your custom report
  5. Access from Saved Reports

Available Filters

FilterOptions
OwnerSpecific reps or teams
StagePipeline stages
SourceLead sources
ProductProduct lines
RegionGeographic territories
Deal SizeValue ranges

AI Insights in Analytics

Automated Observations

The AI highlights notable patterns:

"Revenue from enterprise deals (> $50K) increased 40% this quarter."

"Deals sourced from referrals have a 2x higher win rate than cold outreach."

"Sales cycle for manufacturing industry is 15 days longer than average."

Anomaly Detection

Alerts for unusual patterns:

  • Sudden drop in pipeline value
  • Unusually high loss rate
  • Significant change in activity levels
  • Deals stuck in stages

Best Practices

Regular Review Cadence

ReportFrequencyAudience
PipelineWeeklySales team
Win/LossMonthlySales + Product
Team PerformanceWeeklyManagers
ForecastWeeklyLeadership
Full AnalyticsMonthlyExecutive team

Action-Oriented Analysis

Don't just view reports — act on them:

  1. Identify issues — Bottlenecks, declining metrics
  2. Click through — See specific affected records
  3. Take action — Follow up, reassign, update
  4. Track improvement — Monitor in next review

Benchmarking

Compare your metrics to:

  • Previous periods
  • Team averages
  • Industry standards
  • Quota/target goals

Next Steps