Workflow · Sales and growth · Opening soon
Deal aging in pipeline
See how long each open deal has been in its current stage. Flag deals that have stayed too long in a stage.
Someone typed
“show how long each open deal has been in its current stage and flag ones stuck too long”
The agent read it as
Show how long each open deal has been in its current stage and flag ones stuck too long in HubSpot deals export, using HubSpot pipeline stage aging rules.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
HubSpot deals export
CSV export · 16 rows
File
HubSpot pipeline stage aging rules
CSV export · 5 rows
Step
Make deal stage key
Step 1
Step
Make rule stage key
Step 2
Join
Add stage aging rules
16 of 16 paired
Step
Show days and flag stuck deals
Step 4
Result
Deal Stage Aging
16 rows
Schedule
Runs when you say
Proposed
- FileHubSpot deals exportCSV export · 16 rows
- FileHubSpot pipeline stage aging rulesCSV export · 5 rows
- StepMake deal stage keyStep 1
- StepMake rule stage keyStep 2
- JoinAdd stage aging rules16 of 16 paired
- StepShow days and flag stuck dealsStep 4
- ResultDeal Stage Aging16 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out, and the join paired 16 of 16 rows.
- Download HubSpot deals export sample (16 rows)HubSpot: Sales > Deals > Export view
- Download HubSpot pipeline stage aging rules sample (5 rows)HubSpot: Settings > Objects > Deals > Pipelines > Export stage rules
What you get back
The result of that run, the rows to look at first.
Deal Stage AgingSample data16 rows
| Deal name | Deal ID | Days in current stage | Stage status | Deal stage | Date entered current stage | Max days in stage |
|---|---|---|---|---|---|---|
| Harbor freight automation | 40188235 | 35 | Stuck | contract_sent | 2026-10-07 | 7 |
| Brightside telecom upgrade | 40188246 | 34 | Stuck | qualified_to_buy | 2026-10-08 | 14 |
| Cobalt education district | 40188241 | 28 | Stuck | qualified_to_buy | 2026-10-14 | 14 |
| Bluebird services add-on | 40188234 | 24 | Stuck | presentation_scheduled | 2026-10-18 | 14 |
| Evergreen labs renewal | 40188239 | 22 | Stuck | contract_sent | 2026-10-20 | 7 |
| Pioneer foods rollout | 40188238 | 18 | Stuck | decision_maker_bought_in | 2026-10-24 | 12 |
| Vertex manufacturing pilot | 40188243 | 15 | Stuck | decision_maker_bought_in | 2026-10-27 | 12 |
| Summit nonprofit grant | 40188245 | 12 | Stuck | appointment_scheduled | 2026-10-30 | 10 |
| Luma retail pilot | 40188233 | 13 | Within limit | qualified_to_buy | 2026-10-29 | 14 |
| Orchid health system | 40188242 | 10 | Within limit | presentation_scheduled | 2026-11-01 | 14 |
| Quill media upsell | 40188237 | 9 | Within limit | presentation_scheduled | 2026-11-02 | 14 |
| Sunset clinic multi-site | 40188236 | 7 | Within limit | qualified_to_buy | 2026-11-04 | 14 |
How do you track deal aging in a pipeline?
Export your deals from HubSpot, then make the deal stage key and the rule stage key. Add your stage aging rules, then show days in stage and flag the deals that are stuck too long.
How it works
How to use the Deal Stage Aging workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Deal Stage Aging: questions
Which export should you use?
Use a HubSpot deals export with the fields for deal ID or deal name, current stage, and any dates or status fields you need for your rules.
What happens to deals that do not match a rule?
They stay in the table, but they are not flagged by that rule. You can review them separately or add another rule if they need to be covered.
How do you change the rules?
Edit the rule words, such as the stage names and the number of days allowed in each stage. Then rerun the workflow on a fresh export if needed.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Measure how fast the pipeline turns into revenue, and where people drop out of your funnel.
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template
- Funnel analysisHow many people reach each step of your funnel, in order, and where they drop offSee the workflow Template
- Sales forecast from pipelineForecast this quarter’s sales from a HubSpot export, using stage probability, close month, and closed won revenue.See the workflow Built by the agent
- Survey results analysisSummarize Typeform survey responses by question and respondent segment, with score averages and response counts.See the workflow Built by the agent
- Time to first valueMeasure how many days new accounts take to reach their first key action, grouped by signup week, from a Mixpanel events export.See the workflow Built by the agent
- Feature adoptionCompare feature adoption this month and last month from a Mixpanel export. See which features held, dropped, or shifted.See the workflow Built by the agent