Workflow · Sales and growth · Opening soon

Sales cycle length

Use your HubSpot deals export to track sales cycle length by rep and source. You get days from deal created to closed won for closed-won deals from the last 6 months.

Book a demo

Someone typed

“show every closed-won hubspot deal from the last 6 months by rep and source, with days from create to close; status Agrees when the deal is unique and the source is mapped, otherwise Duplicate or Unmapped”

The agent read it as

show every closed-won HubSpot deals export from the last 6 months by rep and source, with days from create to close; status Agrees when the deal is unique and the source is mapped, otherwise Duplicate or Unmapped

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

HubSpot deals export

CSV export · 18 rows

Step

Filter and flag deals

Step 1

Result

Closed-won deals

18 rows · 1 flagged

Schedule

Runs when you say

Proposed

File
HubSpot deals export
CSV export · 18 rows
Step
Filter and flag deals
Step 1
Result
Closed-won deals
18 rows · 1 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 18 rows came out.

Download HubSpot deals export sample (18 rows)HubSpot: Sales > Deals > Export view (columns: Deal ID, Deal name, Create date, Close date, Deal owner, Deal stage, Original source)

What you get back

The result of that run, the rows to look at first.

Closed-won dealsSample data18 rows

17 agrees1 unmapped

Deal ID	Deal owner	Original source	Create date	Close date	Days from create to close	Status
5,016	Sofia Alvarez	Unknown	2026-10-07	2026-10-25	18	Unmapped
5,013	Jordan Patel	Direct Traffic	2026-10-01	2026-10-21	20	Agrees
5,008	Jordan Patel	Organic Search	2026-09-20	2026-10-16	26	Agrees
5,018	Jordan Patel	Organic Search	2026-10-11	2026-10-28	17	Agrees
5,002	Jordan Patel	Paid Search	2026-09-05	2026-09-22	17	Agrees
5,001	Maya Chen	Organic Search	2026-09-02	2026-09-26	24	Agrees
5,011	Maya Chen	Organic Search	2026-09-02	2026-09-26	24	Agrees
5,007	Maya Chen	Paid Search	2026-09-18	2026-10-14	26	Agrees
5,015	Maya Chen	Paid Search	2026-10-05	2026-10-24	19	Agrees
5,003	Maya Chen	Referral	2026-09-08	2026-10-01	23	Agrees
5,006	Noah Bennett	Direct Traffic	2026-09-15	2026-10-10	25	Agrees
5,017	Noah Bennett	Direct Traffic	2026-10-09	2026-10-27	18	Agrees

18 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you measure sales cycle length by rep and source?

Export your HubSpot deals data, then filter to closed-won deals from the last 6 months. Group the rows by rep and source, and calculate days from deal created to closed won for each deal. Mammoth flags each row as Agrees when the deal is unique and the source is mapped, or as Duplicate or Unmapped when it is not.

How it works

How to use the Closed-won deals 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.

Closed-won deals: questions

Which export should you use?

Use a HubSpot deals export with deal created date, closed date, deal owner or rep, deal source, and deal ID or another unique deal key.

What happens to rows that do not match?

Rows that do not match the rules are not counted as Agrees. They are marked Duplicate if the deal appears more than once, or Unmapped if the source value does not match the source rules.

How do you change the rules?

Change the rules in words by updating the filters, the required columns, and the mapping for source values. For example, you can switch the date range, add or remove fields, or rename the source rules.