Workflow · Sales and growth · Opening soon
Sales activity report by rep
Build a sales activity report from your exported Salesforce activity log. Group calls, emails and meetings by rep and week.
Someone typed
“count calls, emails and meetings by sales rep and week from the activity log”
The agent read it as
Count calls, emails and meetings by sales rep and week from the Salesforce activity log.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Salesforce activity log
CSV export · 35 rows
Step
Count activities by week
Step 1
Result
Weekly Rep Activity Counts
16 rows
Schedule
Runs when you say
Proposed
- FileSalesforce activity logCSV export · 35 rows
- StepCount activities by weekStep 1
- ResultWeekly Rep Activity Counts16 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out.
- Download Salesforce activity log sample (35 rows)Salesforce: Activities > Activity History > Export
What you get back
The result of that run, the rows to look at first.
Weekly Rep Activity CountsSample data16 rows
| Sales rep | Week | Calls | Emails | Meetings |
|---|---|---|---|---|
| Avery Chen | 2026-09-14 | 1 | 1 | 1 |
| Jordan Lee | 2026-09-21 | 1 | 1 | 0 |
| Maya Patel | 2026-09-21 | 1 | 1 | 1 |
| Jordan Lee | 2026-09-28 | 0 | 0 | 1 |
| Sofia Alvarez | 2026-09-28 | 1 | 1 | 1 |
| Ethan Brooks | 2026-10-05 | 1 | 1 | 1 |
| Nora Kim | 2026-10-05 | 1 | 1 | 0 |
| Avery Chen | 2026-10-12 | 1 | 1 | 0 |
| Nora Kim | 2026-10-12 | 0 | 0 | 1 |
| Maya Patel | 2026-10-19 | 1 | 1 | 1 |
| Jordan Lee | 2026-10-26 | 1 | 1 | 1 |
| Ethan Brooks | 2026-11-02 | 2 | 0 | 0 |
How do you count calls, emails and meetings by sales rep and week from the activity log?
Export the Salesforce activity log, then load it into Mammoth. Mammoth groups the rows by sales rep and week, then counts calls, emails, and meetings for each group. The result is a weekly activity count by rep.
How it works
How to use the Weekly Rep Activity Counts 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.
Weekly Rep Activity Counts: questions
What export do I need from Salesforce?
Export the activity log with the fields you need to identify the rep, the activity type, and the activity date. Those columns let the workflow group rows by person and week.
What happens to rows that do not match the activity types I want?
Rows that do not match the rules are left out of the count. You can keep them in the file, but they will not affect the totals for calls, emails, or meetings.
How do I change the rules in words?
Edit the step so it counts the activity types you want, grouped by sales rep and week. You can also change which column holds the rep name, the date, or the activity label.
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