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.

The sales report.

Access Level: OWNER/ADMIN only (and CRM access)

Status: Production Ready

Last Updated: October 2026

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. Period Filter¶

Narrow the report to a specific time window instead of showing the pipeline's full history:

All time (default), This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year
Filters on when each deal last changed stage — the same date the target progress above uses for "this month's" actuals
Combines with the Pipeline and Assignee filters

3. Monthly Target Progress¶

A This Month's Target card appears at the top of the report showing:

The total value of deals closed (won) so far this month
The target for the month
A progress bar showing how close you are to the target
The percentage of the target reached

If no target has been set for the current month, the card says so explicitly ("No target set for this month yet") instead of disappearing — nothing else on the page changes.

Managing targets: OWNER/ADMIN users see a Manage targets button on the target card. It opens a dialog to create, update, or delete a revenue target for any month or quarter (and currency) — no database access required. Deleting a target removes it immediately; saving a target for a period that already has one updates it in place.

Targets by Month / Targets by Quarter: below the current-month card, two tables show every target your organization has set, each compared against the deals actually closed (won) in that period:

Targets by Month lists every month with a target, its actual vs. target value, and the percentage reached.
Targets by Quarter rolls the same months up into their calendar quarter (e.g. Q4 = October, November, December) and totals target vs. actual for the whole quarter.

If your organization has no month or quarter targets yet, this section explains that instead of disappearing, and (for OWNER/ADMIN) points to the Manage targets button to add one.

4. 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

5. 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

6. 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 (opens that deal's details on the deals page) - View conversation (opens the contact's most recent conversation in the inbox) - External link icons - Hover tooltips

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

7. 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

8. 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¶

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

Analyzing Pipeline Performance¶

Review Summary Metrics:
Check total deals and value
Review average deal value
Identify pipeline size
Analyze Stage Distribution:
Expand each stage
Review deal count per stage
Check value distribution
Identify bottlenecks
Examine Individual Deals:
Click to view deal details
Check contact information
Review probability and close date
Navigate to conversation if needed

Exporting Reports¶

Click Export CSV button
File downloads automatically
Open in Excel or spreadsheet application
Analyze data further
Share with team or stakeholders

Pipeline Selection: Change pipeline to analyze different sales processes
Assignee Filter: Filter the report by deal assignee (All, a specific team member, or Unassigned)
Period Filter: Narrow the report to This/Last Month, This/Last Quarter, This/Last Year, or All time — based on when each deal last changed stage
Stage Expansion: Expand/collapse stages to focus on specific areas
Deal Navigation: Click deal links to view full details
Conversation Access: Click conversation icon to view related messages

The active Pipeline, Assignee, and Period filters are shown as badges above the report, and are included in the CSV export's metadata.

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

Generate report for current pipeline
Review summary metrics
Identify stages with most deals
Check average deal values
Export report for meeting
Share insights with team

Deal Analysis¶

Scenario: Analyzing stuck deals

Generate report
Expand each stage
Review deal details
Identify deals with low probability
Check expected close dates
Create follow-up tasks

Performance Tracking¶

Scenario: Monthly performance review

Generate report
Export to CSV
Import into analytics tool
Create charts and graphs
Track trends over time
Identify improvement areas

Benefits¶

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

Best Practices¶

Regular Reviews: Generate reports weekly/monthly
Stage Analysis: Focus on stages with most deals
Deal Follow-Up: Use reports to identify deals needing attention
Export Regularly: Keep historical reports for trend analysis
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

Deals
Analytics
Dashboard
Sales Reports on connectgain.cloud — feature overview on the ConnectGain website