Revenue Operations
Reconcile pipeline movement, preserve definitions, and give leaders a repeatable view every reporting cycle.
Create it in 3 clicks
Build Your HubSpot Pipeline Change Dashboard in 3 Clicks
For RevOps, Sales Ops, and sales leaders who prepare weekly or monthly pipeline updates. Compare two cutoffs, explain the deals behind the movement, and choose what goes into Excel and PowerPoint.
Sign up to the SWOTBee app with your work email. No card is required.
Pipeline change dashboard
New Business Pipeline
Opening pipeline
USD 1.24m
Net movement
-USD 68k
Closing pipeline
USD 1.17m
Start
+145k
+40k
-120k
-133k
End
NewRevaluedWonLost or left
Pipeline fell by USD 68k. Every dollar is tied to a movement category and named deal.
HubSpot and revenue operations work trusted by teams at
Who it is for
Built for the people who prepare and explain the numbers
This dashboard is for teams that have to explain pipeline movement repeatedly, not analysts building a one-off report.
Sales leaders
Understand why the forecast moved and focus the review on the deals and owners that need a decision.
Sales Operations
Prepare weekly and monthly updates without rebuilding HubSpot filters, spreadsheets, and slides by hand.
Three-click workflow
From HubSpot to a repeatable pipeline change dashboard in 3 clicks
Set the reporting rules once, then regenerate the same management-ready view every week or month without learning HubSpot tables or rebuilding the presentation.
- 1
Connect HubSpot
Use a read-only connection so the dashboard can use the pipeline data already maintained by the team.
- 2
Choose the comparison
Select the pipeline, weekly or monthly cadence, and the two cutoffs that should be compared.
- 3
Create and share
Generate the dashboard, inspect the Excel-ready rows, and choose the charts and talking points for PowerPoint.
Choose the reporting scope once, then rebuild the same dashboard, Excel-ready detail, and PowerPoint story for every review cycle.
One source, three useful outputs
Review the dashboard, inspect the spreadsheet, then tell the story
Choose the charts, rows, and AI-assisted talking points that belong in the management update. Keep the underlying data available when someone asks what is behind a number.
Dashboard
See the reporting rhythm
Track the starting value, ending value, net movement, movement categories, and the deals responsible across recurring reviews.
Excel-ready data
Inspect and tune the detail
Filter and sort the underlying deal rows, check owners and close dates, and identify source records that need correction in HubSpot.
PowerPoint story
Choose what management sees
Select the additions, losses, pushed dates, and value changes that explain the period, then place them into the management update.
AI-assisted talking point example
“Pipeline fell by 68,000 dollars this week. New opportunities added 145,000 dollars, but closed-lost deals, reductions, and exits removed 253,000 dollars.”
The user chooses what to keep, edits the wording, and can apply an approved PowerPoint template. The underlying figures remain available for review.
Pipeline changes over time
What is a HubSpot pipeline change dashboard?
A HubSpot pipeline change dashboard compares your sales pipeline at two dated cutoffs. It shows how total pipeline value and the number of deals changed, then identifies which deals entered, left, changed stage, changed amount, or moved their close date.
Use the same dashboard for a weekly review, a month-to-month pipeline check, or any two dates your team needs. It combines the summary, movement categories, underlying deal rows, and presentation story in one repeatable workflow.
What this dashboard helps you do
Go from a changed total to the deals that need attention.
Choose any two dates, check that the numbers tie out, and focus the conversation on owners and next actions.
Repeat the same review
Set the pipeline, cutoff, and cadence once, then rebuild the same weekly or monthly dashboard without recreating filters.
Explain every movement
Separate new, won, lost, moved, and revalued deals so the starting and ending values reconcile.
Inspect the Excel-ready detail
Give reviewers the named deals, owners, stages, amounts, and close dates behind every dashboard number.
Prepare the meeting faster
Open one dated dashboard before the weekly or monthly review instead of rebuilding last period from a live CRM view.
Choose the management story
Select the movements that matter and turn them into editable PowerPoint charts and AI-assisted talking points.
Use HubSpot without learning its internals
Work with familiar sales concepts without mapping objects, joins, APIs, or internal HubSpot tables for every cycle.
Dashboard preview
Example dataOne dashboard, from the movement to the deals
This dashboard moves from a reconciled change summary to the exact deals and owners behind every movement.
New Business Pipeline
Pipeline change between two dates
Sep 1, 5:00 PM to Sep 8, 5:00 PM, portal timezone
Value reconciledSample
Open pipeline at start
$1,240,000
Open pipeline at end
$1,172,000
Net movement
-$68,000
Unexplained residual
$0
Reconciled value bridge
Residual USD 0Opening pipelineUSD 1.24m
New and increased+USD 185k
Closed won-USD 120k
Lost, left, reduced-USD 133k
Closing pipelineUSD 1.17m
Close-date and stage moves remain visible as review flags, while the value bridge accounts for every dollar between the two cutoffs.
Deals behind the movement
Sorted by review priorityBriar Health expansion
Owner: Priya Shah
Entered pipeline
Not in pipeline to Discovery
Acme Platform renewal
Owner: Maya Chen
Closed won
Contract sent to Closed won
Northstar expansion
Owner: Liam Ross
Closed lost
Decision to Closed lost
Quarry Systems rollout
Owner: Elena Park
Amount reduced
$90k to $70k
Worked pipeline bridge
Reconcile the total before explaining the story
This fictional example compares the same pipeline, currency, scope, and Friday cutoff method. It separates changes that affect open-pipeline value from review flags such as stage progression and close-date slippage.
Fictional week-over-week value bridge
USD company currency, open deals only
Opening pipeline$2,400,000
New or reopened+$450,000
Amount increases+$75,000
Closed won-$180,000
Closed lost-$95,000
Amount reductions-$40,000
Closing pipeline$2,610,000
$2.40m + $450k + $75k - $180k - $95k - $40k = $2.61m
Interpret the $210,000 net increase
Do not report only that pipeline grew. New and reopened deals added $450,000 and amount increases added $75,000. Won, lost, and reduced deals removed $315,000 from open pipeline. The team should validate the quality of the new value and review the largest losses and reductions.
Keep timing and quality flags separate
A deal moving from Discovery to Decision does not add value when its amount and inclusion remain unchanged. A close-date push-out may not change total open pipeline either, but it can weaken the current-period forecast. Show progressed, regressed, pulled-in, pushed-out, and stale deals beside the value bridge.
Trace every movement to named deals
Keep deal ID, name, owner, pipeline, prior and current stage, prior and current amount, close dates, movement class, and source timestamps. A zero residual proves the arithmetic, while the named rows explain the decision.
Free worksheet
Copy the reconciled pipeline bridge
The management reporting starter pack includes prior and current snapshots, movement classifications, formula checks, named-deal evidence, a weekly agenda, and an editable board deck.
Management reporting system
Govern cutoffs, definitions, evidence, commentary, and decisions.
Weekly sales report
Place the pipeline bridge inside a focused 30-minute review.
Pipeline health dashboard
Find stale, overdue, and unsupported deals behind the movement.
Historical snapshots
Preserve comparable cutoffs for future change reports.
Three-click setup
The 3-click dashboard setup
Sign up, choose the pipeline and comparison dates, and create the recurring dashboard in three clicks.
- 01
Choose a pipeline
Select the sales pipeline you review. The report should not mix unrelated pipelines without saying so.
- 02
Choose the earlier cutoff
Pick the state you want to compare from, with its date, time, and portal timezone visible.
- 03
Choose the later cutoff
Create the dashboard for the next review, then inspect the named deals behind the net movement.
A complement to native reporting
HubSpot has the data. The value is a repeatable dashboard that ties the numbers to deals.
HubSpot already offers deal change history, pipeline waterfall reports, historical snapshots, and recurring report emails on eligible plans.
SWOTBee prepares one dated dashboard with the before and after values, a complete reconciliation, and the named deals and owners behind the movement.
Questions about the dashboard
What to know before you create the dashboard
How do I report on pipeline changes over time in HubSpot?
Choose two dated cutoffs and reconcile the difference to deals that entered, left, closed, changed amount, changed stage, or moved close date. SWOTBee keeps the summary and supporting deals in one dashboard.
What appears in the pipeline change dashboard?
The dashboard shows opening and closing pipeline value, additions, wins, losses, value changes, stage movement, close-date movement, and the named deals and owners behind the difference.
How do I reconcile opening and closing pipeline?
Start with opening open pipeline, add new or reopened deals and amount increases, then subtract won, lost, removed, and reduced value. The result should equal closing open pipeline for the same scope, currency, and cutoff method.
Does stage movement change pipeline value?
A stage move explains pipeline quality and progression, but it does not change the value bridge unless the deal enters or leaves the included scope or its amount changes. Track stage and close-date movement as separate review flags.
Will it edit our HubSpot records?
No. The reporting connection reads the pipeline data required for the dashboard without editing deal records.
Can I compare dates other than Monday to Monday?
Yes. Choose any two valid cutoffs for a weekly review, month-end comparison, QBR, or another management cadence.
How do I get started?
Sign up to the SWOTBee app, connect the appropriate HubSpot portal, choose the pipeline and comparison dates, and create the dashboard.
Related HubSpot reporting resources
Continue with the reporting problem closest to yours
Run the weekly sales report
Use the pipeline bridge in a focused scorecard, exception review, and 30-minute management agenda.
Read nextPreserve historical pipeline snapshots
Keep exact weekly or monthly cutoffs and reopen the deal rows behind an earlier management review.
Read nextFind stale and aging deals
Move from pipeline movement to the opportunities that now need an owner decision.
Read nextApp signup
Sign up to the app
Create your SWOTBee account with your work email. No card is required.
Your report signup is saved
We saved your work email for the HubSpot pipeline change dashboard. We will contact you about access. No app account or report was created yet, and no HubSpot account was connected or accessed.