Skip to content
Workflow · Track and forecast · Opening soon

HubSpot sales activity by rep against deals

Export your HubSpot activities and deals, then load them into the workflow. It counts calls, emails, meetings, open deals, won deals, and won amount for each rep over the last four weeks.

Early access opens shortly. Check back soon.

Someone typed

“show each rep from the hubspot activities and deals, count calls, emails, meetings, open deals and won deals in the last four weeks, total won amount, then flag no meetings, deal gone quiet after 21 days, and not linked activities; status Agrees when meetings > 0”

The agent read it as

show each rep from HubSpot activities and HubSpot deals, count calls, emails, meetings, open deals and won deals in the last four weeks, total won amount, then flag no meetings, deal gone quiet after 21 days, and not linked activities; status Agrees when meetings > 0, counting all currently open deals.

What the agent built

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

  1. File
    HubSpot activities
    CSV export · 45 rows
  2. File
    HubSpot deals
    CSV export · 30 rows
  3. Step
    Number activity lines
    Step 1
  4. Step
    Number deal lines
    Step 2
  5. Join
    Bring in rep activities
    30 of 30 paired
  6. Step
    Count activity and deal flags
    Step 4
  7. Result
    Rep Activity Flags
    5 rows · 1 flagged
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 5 rows.

What you get back

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

Rep Activity FlagsSample data5 rows
4 agrees1 no meetings
RepCallsEmailsMeetingsOpen dealsWon dealsWon amountQuiet dealsNot linked activitiesStatusQuiet deal statusActivity link status
Maya Chen4303116,00010No meetingsDeal gone quietAll activities linked
Brooke Patel23324108,00010AgreesDeal gone quietAll activities linked
Sam O'Neill4321142,00003AgreesNo quiet dealsNot linked activities
Alex Rivera2231353,00000AgreesNo quiet dealsAll activities linked
Jordan Kim3332224,50000AgreesNo quiet dealsAll activities linked
5 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Rep Activity Flags workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Rep Activity Flags: questions

How do you build a HubSpot report for sales activity by rep against deals?
Export your HubSpot activities and deals, then load them into the workflow. It counts calls, emails, meetings, open deals, won deals, and won amount for each rep over the last four weeks. It also flags reps with no meetings, open deals that have gone quiet for 21 days, and activity that is not tied to a deal or contact.
What export should you use from HubSpot?
Use exports of HubSpot activities and HubSpot deals. The workflow reads the rows in those files and matches them by rep and deal.
What happens to rows that do not match a deal or contact?
They stay in the report and are flagged as not linked activity. You can review them separately from the rows that match a rep and deal.
How do you change the rules in words?
Edit the rule text to change the date window, the quiet-deal limit, or the conditions for flags. For example, you can ask for a different time range, a different inactivity cutoff, or a different meeting test.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →