Workflow · Sales and growth · Opening soon
Lead response time
See how long each rep takes to first contact a new lead. Group the results by rep and lead source from your exported HubSpot contacts.
Someone typed
“calculate how long each rep takes to first contact a new lead, by rep and lead source”
The agent read it as
Calculate how long each rep takes to first contact a new lead, by rep and lead source, from HubSpot contacts.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
HubSpot contacts
CSV export · 20 rows
Step
Average contact time
Step 1
Result
Lead Contact Time
18 rows
Schedule
Runs when you say
Proposed
- FileHubSpot contactsCSV export · 20 rows
- StepAverage contact timeStep 1
- ResultLead Contact Time18 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 18 rows came out.
- Download HubSpot contacts sample (20 rows)HubSpot: Contacts > Contacts > Export view
What you get back
The result of that run, the rows to look at first.
Lead Contact TimeSample data18 rows
| Rep | Lead source | Average days to first contact | Leads contacted |
|---|---|---|---|
| Ava Chen | Organic Search | 0 | 1 |
| Ava Chen | Paid Search | 1.50 | 2 |
| Caleb Turner | Direct Traffic | 0 | 1 |
| Caleb Turner | Paid Social | 1 | 1 |
| Jordan Ellis | Direct Traffic | 1 | 1 |
| Jordan Ellis | Organic Search | 0 | 1 |
| Jordan Ellis | Webinar | · | 0 |
| Leila Hassan | Organic Search | 0 | 1 |
| Leila Hassan | Partner | 0 | 1 |
| Mateo Ruiz | Referral | 0 | 2 |
| Mateo Ruiz | Webinar | 2 | 1 |
| Nina Brooks | Event | 2 | 1 |
How do you calculate lead response time by rep and source?
Export your HubSpot contacts, then upload the file. Mammoth calculates the time from lead creation to first contact, then groups the result by rep and lead source.
How it works
How to use the Lead Contact Time 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.
Lead Contact Time: questions
Which export should you use?
Use a contacts export from HubSpot. Include the fields for lead created time, first contact time, rep, and lead source.
What happens to rows that do not match?
Rows with missing or unusable values for the fields in this workflow are left out of the result. They do not stop the rest of the file from being processed.
How do you change the rules?
Change the workflow in words by updating which fields you want to use, and how you want the rows grouped. For example, you can group by a different owner field or a different source field.
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