Reports

The standard report library — pipeline, win/loss, forecast, case volume, SLA performance and more.

Reports

Reports are filterable, exportable lists with grouping and summary totals. Where dashboards show the what, reports answer the why and which.

Standard reports

HotCRM ships with these reports out of the box:

📈 Sales reports

ReportWhat it shows
Pipeline by StageAll open deals grouped by stage with $ totals
Forecast vs ActualClosed Won vs forecast, by period
Win/Loss AnalysisClosed deals grouped by win/loss with reason breakdown
Sales Cycle LengthDays from creation to close, by owner and product
Top Performing RepsBookings leaderboard
Stale OpportunitiesDeals with no activity in 14+ days
Big Deals WonClosed-won opportunities ≥ $100K
Discount Approval ActivityAll approval requests by status and approver

🎯 Lead reports

ReportWhat it shows
Lead Conversion FunnelNew → Working → Qualified → Converted
Lead Source ROIVolume, conversion rate, and revenue by source
Aged LeadsLeads in New or Working status > 30 days

🎧 Service reports

ReportWhat it shows
Case Volume by OriginNew cases by Email / Phone / Web / Chat / Portal
SLA Performance% first-response on time, % resolved on time, by priority
Case Resolution TimeAverage time-to-resolve, by category and agent
Top Accounts by Case VolumeAccounts with the most cases
Reopened CasesCases reopened in the period (quality signal)
CSAT by AgentAverage customer satisfaction by agent

💰 Revenue reports

ReportWhat it shows
Contracts ExpiringActive contracts ending in next 30/60/90 days
Active Contracts by ProductRecurring revenue rollup
Renewal PipelineOpportunities tied to renewing contracts

📣 Marketing reports

ReportWhat it shows
Campaign ROISpend vs sourced/influenced pipeline and revenue
Campaign EngagementOpen / click / response / conversion by campaign

Working with reports

Every report has the same basic controls:

ControlWhat it does
FilterAdd criteria (date range, owner, stage, etc.)
Group byRoll up by any field — owner, stage, product, region
SortClick any column header
SummaryShow totals, averages, min, max at group and overall level
Drill inClick any row to open the source record
ExportDownload as CSV or Excel
Save asSave your filtered/grouped version with a new name
ScheduleEmail a PDF or CSV on a recurring schedule
SubscribeGet notified when the report changes

Permissions

  • A user only sees records they have access to — a rep running Pipeline by Stage sees their own deals; a manager sees the team's.
  • Admins can lock down which fields appear in reports via Field-Level Security.
  • Sensitive reports can be restricted to specific profiles.

Custom reports

Anyone with the Report Builder permission can:

  1. Pick a source object (lead, opportunity, case, etc.).
  2. Pick columns to display.
  3. Add filters.
  4. Pick grouping and summary fields.
  5. Choose a chart to visualise.
  6. Save and share.

For more advanced analysis — multi-object joins, time-series, cohort analysis — use cubes.

Subscriptions and scheduled delivery

The most common way to consume reports is by email subscription:

  • Frequency: daily, weekly, monthly.
  • Day & time of delivery.
  • Format: PDF (formatted) or CSV (raw data).
  • Recipients: yourself, a team alias, or specific users (subject to their own permissions).

A common pattern:

  • Pipeline by Stage → Mondays 8 AM to the sales team.
  • SLA Performance → daily 6 PM to the service manager.
  • Top Accounts by Case Volume → Fridays 4 PM to the customer success team.

Tips for users

  • ✅ Save filtered versions for the views you run weekly — don't re-filter from scratch.
  • ✅ Use Group by Owner on team reports to spotlight outperformers and stragglers.
  • ✅ Export to Excel only when you need to combine with external data — otherwise stay in-app for live data.

Tips for managers

  • ✅ Schedule Stale Opportunities weekly to your team — it forces follow-up discipline.
  • ✅ Use Win/Loss Analysis monthly with sales coaches — it's the single best coaching tool.

Tips for admins

  • ✅ When users keep building the same report, promote it to the standard library.
  • ✅ Retire reports no one runs — keep the library curated.
  • ✅ Set up default report folders by team (Sales, Service, Marketing, Exec) for easy discovery.

On this page