How to see what your HubSpot pipeline looked like last week
By Kayabyte
“How many deals were in Proposal last Monday?” and “what was open pipeline on 30 September?” sound simple, but a deal only stores where it is now. HubSpot does give you several ways to look backwards, and each answers a slightly different question. This guide goes through them in the order to try them, then says where a gap remains.
1. The Historical snapshots report
HubSpot’s sales analytics reports include one called Historical snapshots. HubSpot describes it like this: “This report shows the number of deals at certain points in time by category (e.g., deal stage, amount).” You split it with the Break down by dropdown on the Filters tab. To find it, go to Reporting > Reports, choose Sales and open the Forecast & revenue topic (HubSpot guide, last updated 18 Jun 2026).
Try this first. The article does not say how often the snapshots are taken, how far back they go or which pipelines they cover, so open it on your own account and check that the dates and stages you need are there. It also lists Sales Hub Starter, Professional and Enterprise at the top for the whole article; confirm on your own subscription that this report is available to you.
2. Reports on what changed between two dates
The same article describes three more reports that look at movement rather than a single day:
- Deal change history shows “changes made to the deals’ stages, amounts, and close dates”, and deals that were created.
- Deal push rate counts deals whose close date moved, per owner, team or deal stage. A deal counts as pushed only when its close date moves from inside the timeframe you picked to outside it.
- Deal pipeline waterfall shows revenue changes between two periods, split into Created, Pushed, Pulled, Decreased, Increased, Lost and Won.
For “what happened to the pipeline between 1 October and 1 November”, the waterfall is the closest native answer.
3. Time in stage
If the question is really “how long do deals sit in each stage”, use stage calculated properties. For each pipeline stage HubSpot can keep date entered, date exited, latest time and cumulative time. HubSpot says the values “will be populated retroactively based on existing data”. They are off by default for new pipelines and stages, so an admin has to switch them on under Settings > Objects > Deals > Pipelines. The article lists Professional or Enterprise (HubSpot guide, last updated 15 Jul 2026).
With those on, a custom report can count deals that entered a stage in a date range. That is a flow (“entered Proposal in October”), not a stock (“were sitting in Proposal on 15 October”), though for many reviews it is enough. Custom reports need Professional or Enterprise (HubSpot guide).
4. One deal at a time: property history
Every deal keeps a history of its stage, amount and close date, visible from the deal record. That answers “when did this deal move”, but it is one deal at a time and does not add up to a pipeline on a given day. (How to export property history covers the details.)
5. Your own snapshot: export on a schedule
Export the deals view to a file each week and keep the files. It works on any plan and costs nothing, but it only starts on the day you start and depends on someone remembering. If you go this way, keep the same columns every week (deal ID, stage, amount, close date, owner) so the files can be stacked later.
What is still missing
If you are on a plan without the reports above, or you want the numbers side by side as a trend (deals and value per stage, week by week, for any two days you pick), plus a notice of which deals moved and which went quiet, you are left with option 5.
Full disclosure: we built an app for this gap
We built Historical Snapshots & Weekly Digest (more about it). It reads your deals and saves a snapshot every night: deals and amounts per pipeline stage. On install it rebuilds the last 90 days from each deal’s own stage, pipeline and amount history; deals deleted before the install can’t be seen, so those points are marked as estimates. You can then compare any two days, see stage moves, amount changes and pushed close dates from install day on, and list stale deals.
The Free plan keeps 90 days of deal pipeline history. Pro is USD 19 per month per HubSpot account and adds contacts per lifecycle stage and lead status, tickets per stage, all snapshots kept, the Monday digest email and CSV export. Every new account gets 14 days of Pro, no card needed. It only reads; it never changes anything in HubSpot. If HubSpot’s own Historical snapshots report already shows what you need, you do not need it.
FAQ
Can I see my HubSpot pipeline as it was last week? Start with HubSpot’s Historical snapshots report in the sales analytics reports, then the Deal pipeline waterfall for changes between two dates. If neither fits, keep your own weekly exports or use an app that saves a nightly snapshot.
Does HubSpot keep a history of my pipeline? It keeps the history of each deal’s properties, and it offers the reports above. How far back the Historical snapshots report goes is not stated in HubSpot’s article, so check it on your account.
How do I see how many deals were in a stage on a past date? The Historical snapshots report gives deal counts at points in time by stage. For a date it does not cover, a stored daily snapshot is the reliable way, starting from the day you begin saving them.
Is there a free way to track HubSpot pipeline history? Yes: weekly exports of the deals view, or the free plan of Historical Snapshots & Weekly Digest, which keeps 90 days of deal pipeline history. We built that app, so weigh that.
Questions or corrections: support@kayabyte.dev. HubSpot is a registered trademark of HubSpot, Inc. Kayabyte is an independent developer and is not affiliated with HubSpot.
More guides
- How to audit and clean up HubSpot properties without breaking anything
- How to stop a HubSpot deal reaching Closed won until it is approved
- How to bulk create custom properties in HubSpot from a CSV or spreadsheet
- How to send a client an hours statement from HubSpot
- How to copy properties from one HubSpot account to another
- DealHub or a lightweight approval app for HubSpot deals?
- How to export all properties from HubSpot, with their dropdown options
- How to bulk add dropdown options (and properties) in HubSpot
- HubSpot deal approval options compared: native approvals, workflows, DealGuard and Deal Approvals & Stage Gate
- HubSpot deal approvals without Enterprise: what Free, Starter and Professional can do
- HubSpot discount approval on Sales Hub Professional or Starter
- How to set up discount approvals in HubSpot (deal desk)
- How to track prepaid hours and retainers in HubSpot
- Creating HubSpot properties in bulk: HubSpot import, the API, Lift and Bulk Property Import & Export compared
- HubSpot property naming conventions: a template for internal names, groups and labels
- Tracking retainer hours in HubSpot: StopWatch, PSOhub, a spreadsheet or Retainer Wallet
- A weekly stale-deal report in HubSpot, without Enterprise
- Time tracking on HubSpot tickets: what HubSpot has and the options
- Insycle or Bulk Property Import & Export for HubSpot properties?
- How to require approval before a deal moves stage in HubSpot
- How to require fields before a HubSpot deal moves to a stage
- Retainer rollover rules: expire, capped or full, with examples
- RevOps Deal Desk & CPQ vs Deal Approvals & Stage Gate for HubSpot
- How to stop reps skipping deal stages or moving deals backward in HubSpot
- How to track a retainer balance per client in HubSpot