The Ultimate Guide to Sales Analytics

Sales analytics is the practice of using data from your CRM and sales activities to understand performance, identify opportunities, and make better decisions. Good sales analytics doesn't just tell you what happened — it tells you why, and what to do next.

The Foundation: Clean CRM Data#

Analytics is only as good as the data it draws from. Before building dashboards, ensure your CRM data is clean:

• All deals have stage, value, and close date
• Activities are logged consistently
• Contact and company fields are populated
• Duplicates are eliminated
• Lost deals have a recorded reason

With DenchClaw, the AI agent helps maintain data quality by: enriching new contacts automatically, flagging deals with missing fields, and alerting when records haven't been updated in too long.

Essential Sales Metrics#

Revenue Metrics#

Monthly Recurring Revenue (MRR) / Annual Recurring Revenue (ARR): The foundation for SaaS businesses. Current contracted revenue, not pipeline.

Net Revenue Retention (NRR): Revenue from existing customers, including expansion and less churn. NRR > 100% means existing customers are growing faster than they churn.

Average Contract Value (ACV): Average deal size. Segment by ICP, industry, or deal size to understand where your biggest opportunities are.

Pipeline Metrics#

Pipeline Coverage: Total pipeline value ÷ Revenue target. Should be 3-5x your target.

Pipeline Velocity: (Number of deals × Win rate × ACV) ÷ Average sales cycle. Comprehensive health metric.

Win Rate: Deals won ÷ Deals closed (won + lost). Track by stage entered for better insight.

Average Sales Cycle: Days from opportunity creation to close. Track by deal size and source.

Activity Metrics#

Activities per Rep: Calls, emails, meetings per rep per week. Leading indicator of pipeline.

Response Rate: Outreach sent ÷ Responses. Measures messaging effectiveness.

Meeting to Opportunity Rate: Meetings held ÷ Qualified opportunities created.

Stage Conversion Rates: What percentage of deals move from each stage to the next?

Building Sales Dashboards with DenchClaw#

DenchClaw's DuckDB backend makes building sales analytics straightforward. The AI can generate reports directly from natural language queries:

Pipeline Overview#

"Show me total pipeline value by stage, with deal count and average age at each stage"

Returns a table and optional chart showing pipeline health at a glance.

Win Rate Analysis#

"What's my win rate by deal size category? Break it into <$10K, $10K-$50K, >$50K"

The agent runs the SQL, calculates win rates by category, and presents the results.

Activity Dashboard#

"Show me activities logged per week for the last 8 weeks, broken down by type (call, email, meeting)"

Time-series view of activity volume trends.

Building Custom Dench Apps for Analytics#

For persistent dashboards, use DenchClaw's app builder:

// Pipeline velocity dashboard
const deals = await dench.db.query(`
  SELECT 
    stage,
    COUNT(*) as deal_count,
    SUM(CAST("Value" AS DECIMAL)) as total_value,
    AVG(EXTRACT(day FROM NOW() - created_at)) as avg_age_days
  FROM v_deals
  WHERE status = 'Active'
  GROUP BY stage
  ORDER BY deal_count DESC
`);

This creates a live dashboard that refreshes from your local DuckDB data.

Funnel Analysis#

Understanding where deals are lost in your funnel is the most actionable insight in sales analytics.

Stage Conversion Analysis#

For each stage transition, calculate:

• How many deals entered this stage
• How many moved to the next stage
• How many were lost at this stage
• Average time spent in this stage

Example funnel analysis:

Overall conversion: 7.5% from Lead to Closed Won.

Bottleneck: Lead → Qualified at 40%. This is a qualification problem — you're either targeting the wrong ICP or qualification criteria are wrong.

Lost Deal Analysis#

Segment lost deals by reason:

• Competitor (which competitor?)
• No budget
• Wrong timing
• Not a fit
• Decision deferred
• Champion left

Patterns in lost deal reasons point to specific fixes: competitor loss → work on competitive positioning, no budget → better qualification earlier.

DenchClaw query: "Show me all deals lost in the last 6 months grouped by lost reason."

Sales Rep Performance Analytics#

Individual Rep Metrics#

For each rep, track:

• Activities volume (calls, emails, meetings)
• Pipeline created
• Win rate
• Average deal size
• Average sales cycle
• Quota attainment

Don't just look at outcomes (quota attainment) — look at leading indicators (activities, pipeline). A rep who's missing quota but has high activity volume has a different problem than one who's not doing activity.

Identifying Coaching Opportunities#

Differences between top performers and average performers often cluster around specific funnel stages:

• If a rep's win rate drops at Proposal: pricing or competitive positioning coaching
• If a rep's qualification conversion is low: discovery and qualification training
• If average deal size is low: discuss when to pursue larger opportunities

DenchClaw: "Compare my win rate by stage against my historical average for the last 12 months."

Sales Forecasting#

Forecasting predicts future revenue based on current pipeline.

Types of Forecasting#

Pipeline-weighted: Sum of (deal value × stage probability) for all open deals.

Category-based: Reps categorize deals as Commit, Best Case, or Upside. More accurate because it incorporates rep judgment.

Historical pattern: Based on how similar pipeline has converted historically. Good for identifying when current pipeline is above or below pattern.

AI-assisted: Models trained on your historical data predict deal outcomes based on deal characteristics and interaction patterns.

DenchClaw query: "Based on my current pipeline and historical win rates, what's my expected revenue for Q2?"

Forecast Accuracy#

Good forecasts have these properties:

• Commit accuracy (within 10% of actual) for 90% of quarters
• No surprises at quarter close
• Regular pipeline review to catch slippage early

If your forecast is consistently too optimistic: tighten your qualification criteria, push deals to Closed Lost earlier, or adjust probability percentages.

Advanced Analytics: Sales Velocity Drivers#

Pipeline velocity = (Deals × Win Rate × ACV) ÷ Cycle Length

To increase velocity, you must improve one of these four components. Analytics tells you which lever to pull:

More deals: Is the problem deal volume? Look at activity rates and lead generation.

Higher win rate: Is the problem conversion? Look at stage conversion, competitor analysis, and rep performance gaps.

Higher ACV: Is the problem deal size? Look at how you're positioning value and which segments yield larger deals.

Shorter cycle: Is the problem time? Look at where deals stall and what causes acceleration.

Most sales teams benefit most from improving win rate or shortening cycle — these have compound effects on pipeline velocity.

Frequently Asked Questions#

What's the most important sales metric?#

Pipeline velocity captures the most information in a single number, but it's a lagging indicator. For leading indicators, activities volume and pipeline coverage are most actionable.

How often should I review sales analytics?#

Daily: deal updates, activity volume. Weekly: pipeline review, rep performance. Monthly: funnel analysis, win/loss review. Quarterly: forecast accuracy, velocity trends.

Can DenchClaw replace a dedicated analytics tool?#

For individual users and small teams: yes. DenchClaw's DuckDB backend and app builder handle all the analytics a small team needs. For enterprise teams with complex multi-source analytics: you may want Metabase or a dedicated BI tool connected to your CRM database.

How do I analyze competitors from my CRM data?#

Tag deals with competitors encountered. DenchClaw: "Show me my win rate when facing each competitor." If you're consistently losing to a specific competitor, that's a product positioning problem to solve.

What if I don't have enough data for meaningful analytics?#

Below ~50 closed deals, trends are noisy. Focus on fundamentals (stage conversion, activity rates) rather than statistical patterns. As your dataset grows, analytics become more reliable.

Ready to try DenchClaw? Install in one command: npx denchclaw. Full setup guide →