Skip to content

Sales Report Feature

Overview

The Sales Report feature (/sales-report) provides comprehensive sales pipeline analysis and reporting with detailed deal breakdowns, stage-by-stage analysis, and export capabilities. This feature helps sales managers make data-driven decisions and identify bottlenecks in the sales process.

Access Level: CRM access required Status: Production Ready Last Updated: January 2025


Features

1. Pipeline Selection

Multiple Pipeline Support: - Select any pipeline for analysis - Default pipeline auto-selection - Pipeline switching without page reload - Real-time data refresh

Pipeline Information: - Pipeline name display - Pipeline stage configuration - Deal count per pipeline - Total value per pipeline

2. Summary Metrics

Key Performance Indicators: - Total Stages: Number of stages in selected pipeline - Total Deals: Count of all deals across all stages - Total Value: Sum of all deal values (formatted currency) - Average Deal Value: Mean deal value calculation

Visual Display: - Large, prominent metric cards - Icon indicators - Formatted currency values - Real-time calculations

3. Stage-by-Stage Analysis

Collapsible Stage Cards: - Expandable/collapsible stage sections - Color-coded stage headers - Stage name and color indicators - Visual stage identification

Stage Metrics: - Deal count per stage - Total value per stage - Average deal value per stage - Average probability per stage

Expand/Collapse Controls: - Individual stage toggle - Expand All / Collapse All buttons - Visual chevron indicators - Smooth animations

4. Deal Details Table

Comprehensive Deal Information: - Deal title - Contact name and information - Company name - Description (truncated with tooltip) - Deal value (formatted currency) - Expected close date (formatted) - Probability percentage (badge display)

Quick Actions: - View deal details (navigate to deals page) - View conversation (navigate to inbox) - External link icons - Hover tooltips

Table Features: - Responsive design - Mobile-optimized layout - Scrollable content area

5. Export Capabilities

CSV Export: - Full report export functionality - All stages and deals included - Stage summary rows - Grand total row - Formatted currency values - Date-stamped filename - Ready for Excel import

Export Format: - Headers row - Stage-by-stage data - Summary rows per stage - Grand total row - CSV-compatible format

6. Data Refresh

Manual Refresh: - Refresh button with loading state - Real-time data fetching - Error handling and notifications - Optimistic updates

Auto-Refresh: - Automatic refresh on pipeline change - Real-time deal updates - Stage change detection


Usage

Generating a Report

  1. Navigate to Sales Report in the sidebar
  2. Select pipeline from dropdown (if multiple pipelines)
  3. Report automatically generates
  4. View summary metrics at top
  5. Expand/collapse stages as needed
  6. Review deal details in each stage

Analyzing Pipeline Performance

  1. Review Summary Metrics:
  2. Check total deals and value
  3. Review average deal value
  4. Identify pipeline size

  5. Analyze Stage Distribution:

  6. Expand each stage
  7. Review deal count per stage
  8. Check value distribution
  9. Identify bottlenecks

  10. Examine Individual Deals:

  11. Click to view deal details
  12. Check contact information
  13. Review probability and close date
  14. Navigate to conversation if needed

Exporting Reports

  1. Click Export CSV button
  2. File downloads automatically
  3. Open in Excel or spreadsheet application
  4. Analyze data further
  5. Share with team or stakeholders

Filtering and Navigation

  1. Pipeline Selection: Change pipeline to analyze different sales processes
  2. Assignee Filter: Filter the report by deal assignee (All, a specific team member, or Unassigned)
  3. Stage Expansion: Expand/collapse stages to focus on specific areas
  4. Deal Navigation: Click deal links to view full details
  5. Conversation Access: Click conversation icon to view related messages

Visual Design

Color-Coded Stages

  • Stage-specific colors for visual identification
  • Left border accent colors
  • Background tinting for stage cards
  • Consistent color scheme

Status Badges

  • Probability badges with percentage display
  • Deal count badges
  • Value highlights
  • Visual indicators

Responsive Layout

  • Mobile-optimized design
  • Scrollable content areas
  • Touch-friendly controls
  • Adaptive table layout

Use Cases

Sales Manager Review

Scenario: Weekly pipeline review meeting

  1. Generate report for current pipeline
  2. Review summary metrics
  3. Identify stages with most deals
  4. Check average deal values
  5. Export report for meeting
  6. Share insights with team

Deal Analysis

Scenario: Analyzing stuck deals

  1. Generate report
  2. Expand each stage
  3. Review deal details
  4. Identify deals with low probability
  5. Check expected close dates
  6. Create follow-up tasks

Performance Tracking

Scenario: Monthly performance review

  1. Generate report
  2. Export to CSV
  3. Import into analytics tool
  4. Create charts and graphs
  5. Track trends over time
  6. Identify improvement areas

Benefits

  1. Comprehensive Visibility: See entire pipeline at a glance
  2. Data-Driven Decisions: Make informed choices based on data
  3. Easy Export: Share reports with stakeholders
  4. Quick Identification: Find bottlenecks and issues quickly
  5. Performance Tracking: Monitor pipeline health
  6. Team Alignment: Share insights across team

Best Practices

  1. Regular Reviews: Generate reports weekly/monthly
  2. Stage Analysis: Focus on stages with most deals
  3. Deal Follow-Up: Use reports to identify deals needing attention
  4. Export Regularly: Keep historical reports for trend analysis
  5. Share Insights: Distribute reports to relevant stakeholders

Troubleshooting

"No data showing" - Verify pipeline has deals - Check pipeline selection - Ensure CRM access permissions - Refresh the page

"Export not working" - Check browser download settings - Verify file permissions - Try different browser - Check for popup blockers

"Stages not expanding" - Check JavaScript is enabled - Refresh the page - Clear browser cache - Try different browser



Last Updated: January 2025