You have likely faced this situation before. Leadership wants to know how last quarter compares to the current one, and suddenly, you are juggling spreadsheets, recreating the same report with slightly different dates.
It is tedious, prone to errors, and often hides the larger trend behind manual work.
What if you could see that comparison in a single side-by-side chart, without duplicating reports or switching between tools?
With HubSpot’s Custom Report Builder, that is possible if the date comparison feature is set up correctly. Many teams overlook this option or use it incorrectly, which leads to unnecessary reports and confusing dashboards.
This guide walks through how the feature works, how to configure it properly, and how to read the results so trends are visible and decisions are easier to support.
How to Analyze Two Time Periods Side by Side in HubSpot Reports
The Compare Date Ranges option in HubSpot’s Custom Report Builder allows you to measure two time periods in one report.
Instead of exporting data or building duplicate charts, you see both periods together with clear comparisons.
To access it, go to:
Reports > Reports > Create Report > Custom Report Builder
Once inside, select your dataset, such as Contacts, Companies, Deals, Tickets, or Marketing Emails. Then choose a date property, such as Close Date or Email Sent Date.
This feature is useful for any metric tied to time. Marketing teams use it to check campaign performance, while RevOps teams use it to review pipeline movement after process changes.
How the Date Comparison Feature Works
The Custom Report Builder pulls data directly from your HubSpot CRM and applies time-based grouping logic.
When you add a date field, HubSpot groups records into intervals such as daily, weekly, monthly, or quarterly.
When the Compare Date Ranges toggle is enabled, HubSpot creates a second version of the same metric for another time period. It then calculates the difference between the two ranges.
You can view the change as a number or a percentage, whichever best fits your report.
What You Configure in the Report
Primary Date Field:
The date property that anchors the report, such as Close Date for deals or Created Date for tickets.
Primary Date Range:
The current period you want to review, such as This Month or This Quarter.
Comparison Date Range:
The period you want to measure against, such as the previous month or a custom date range.
Metrics:
The values you are tracking, like Total Revenue, Ticket Count, or Email Click Rate.
Once configured, HubSpot overlays both datasets in the same chart. Labels make it clear which line or column belongs to which period.
Common Use Cases Inside HubSpot
Tracking Campaign Performance Month Over Month
Marketing teams often need to see whether recent changes actually improved results.
A month-over-month comparison makes this visible without extra reports.
Example:
You create a report using the Marketing Email dataset. Set the Sent Date as the date field and compare April to March.
Add metrics like Open Rate and Click Through Rate.
The chart immediately shows whether engagement improved in April or dropped after the changes.
Evaluating Sales Pipeline Progress Quarter Over Quarter
Sales leaders often need proof that process updates are improving revenue outcomes.
Quarterly comparisons provide that proof using live CRM data.
Example:
In a Deals report, select Close Date and use Sum of Amount as the metric.
Compare This Quarter to the Previous Quarter.
The chart displays revenue for both periods and highlights the difference, all tied to actual deal records.
Measuring Ticket Volume Year Over Year
Support teams track volume trends to understand workload and staffing needs.
A year-over-year comparison makes seasonal patterns easy to spot.
Example:
Use the Tickets dataset with Created Date as the date field.
Measure the count of Tickets and compare the same months across two years.
This reveals spikes that may justify staffing changes or signal recurring product issues.
Common Setup Errors and Wrong Assumptions
Avoid these mistakes so your reports reflect reality instead of confusion.
Using the Wrong Date Property
If you use Create Date for deals instead of Close Date, you are measuring deal creation, not revenue wins.
Always confirm the date field matches the question you are answering.
Overlapping Date Ranges
If your current and comparison ranges overlap, records can be counted twice.
Use clearly separated ranges like This Month versus Previous Month or define custom periods that do not overlap.
Expecting Record-Level Comparisons
This feature summarizes data across a dataset.
It does not track how individual records change over time.
For record-level tracking, use calculated properties or workflows instead.
Choosing the Wrong Chart Type
Comparisons only work if differences are easy to see.
Line and column charts work best.
Avoid pie charts or layouts with subtle color differences.
Step By Step Setup Guide
Before starting, confirm that you have reporting permissions and that the dataset includes usable date properties.
- Go to Reports in your HubSpot account
- Click Create Report > Custom Report Builder
- Choose your dataset, such as Deals, Contacts, Tickets, or Marketing Emails
- Drag your date propert,y like Closed Date to the X axis
- Add a metric to the Y axis, such as Amount or Ticket Count
- Apply your primary date range filter in the top right
- Turn on Compare Date Ranges and select the comparison period
- Choose a chart type, with line or column charts recommended
- Review the legend and labels so both ranges are clearly named
- Save the report and add it to a dashboard if needed
Once saved, the report updates automatically. There is no need to rebuild it each reporting cycle.
Measuring Results in HubSpot
Creating the report is only the start. The real value comes from reviewing trends over time.
Focus on the following areas:
Percentage Change:
Shows whether performance increased or declined between periods.
Conversion And Close Rates:
Reveals changes in lead quality or deal effectiveness.
Volume Movement:
Highlights how much activity shifted between time frames.
Trend Direction:
Shows whether patterns are holding steady or weakening.
Dashboards let you group comparison reports for leadership reviews or planning sessions.
Pin dashboards and apply filters, such as This Quarter versus Previous Quarter, to speed up recurring analysis.
Short Example That Brings It Together
Imagine you lead a RevOps team and want to confirm whether recent sales process updates improved revenue.
You build a custom report using the Deals dataset.
Set Closed Date as the date field and Sum of Amount as the metric.
Compare This Quarter with the Previous Quarter.
The report shows a clear increase in closed revenue.
You place this chart next to a marketing leads report that shows higher lead volume in the same period.
Together, these reports show that pipeline input and sales execution improved simultaneously.
How INSIDEA Helps
HubSpot reports reflect only the quality of the data and the setup behind them.
INSIDEA supports teams that want reports they can trust and act on.
We help structure CRM data correctly, map data properties properly, and build reporting frameworks that reflect how your business actually runs.
Our HubSpot consulting services include:
- Onboarding: Set up your portal with aligned date properties and clean reporting foundations.
- Management: Maintain data consistency and keep automations running as expected.
- Workflow Support: Create trigger-based workflows that match real operational processes.
- Reporting Strategy: Build dashboards that show performance across marketing, sales, and service.
If your reports feel unreliable or difficult to maintain, it may be time to hire HubSpot experts who work directly inside your CRM.
Our HubSpot consulting services focus on clarity, accuracy, and reports that leadership can rely on without second-guessing the numbers.
Clear comparisons support better decisions.
With the right setup, HubSpot’s Custom Report Builder lets you review performance over time without rebuilding reports or exporting data.
When reports reflect reality, teams move faster, and discussions stay focused on action instead of explanations.
