Workflow · Search and ads · Opening soon

Marketing ROI by campaign

Export your HubSpot campaigns and deals. Mammoth calculates marketing ROI for each campaign from won deal revenue and spend.

Book a demo

Someone typed

“calculate marketing ROI for each campaign: revenue from won deals attributed to it minus spend, divided by spend”

The agent read it as

Calculate marketing ROI for each campaign: revenue from won deals attributed to it minus spend, divided by spend, using my HubSpot campaigns and HubSpot deals.

What the agent built

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

File

HubSpot campaigns

CSV export · 8 rows

File

HubSpot deals

CSV export · 30 rows

Step

Make campaign join key

Step 1

Step

Total won revenue by campaign

Step 2

Join

Bring in won revenue

8 of 8 paired

Step

Calculate campaign ROI

Step 4

Result

Campaign marketing ROI

8 rows

Schedule

Runs when you say

Proposed

File
HubSpot campaigns
CSV export · 8 rows
File
HubSpot deals
CSV export · 30 rows
Step
Make campaign join key
Step 1
Step
Total won revenue by campaign
Step 2
Join
Bring in won revenue
8 of 8 paired
Step
Calculate campaign ROI
Step 4
Result
Campaign marketing ROI
8 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 8 of 8 rows.

Download HubSpot campaigns sample (8 rows)HubSpot: Marketing > Campaigns > Export
Download HubSpot deals sample (30 rows)HubSpot: Sales > Deals > Export

What you get back

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

Campaign marketing ROISample data8 rows

Campaign name	Marketing ROI	Won revenue	Spend	Campaign ID
Brand Search Q3	1.32	19,500	8,400	cmp_1001
Webinar Series - Ops Leaders	2.19	19,800	6,200	cmp_1002
LinkedIn Demand Gen	1.92	34,400	11,800	cmp_1003
Product Launch Email	2.52	10,900	3,100	cmp_1004
Retargeting Display	1.22	12,000	5,400	cmp_1005
Partner Co-marketing	1.80	12,900	4,600	cmp_1006
Founder Webinar Push	0.86	5,200	2,800	cmp_1007
Holiday Promo Social	0.03	7,400	7,200	cmp_1008

8 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate marketing ROI by campaign?

Export your HubSpot campaigns and deals as files, then upload them to Mammoth. It matches campaigns, totals won deal revenue by campaign, and calculates ROI as (revenue minus spend) divided by spend.

How it works

How to use the Campaign marketing ROI 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.

Campaign marketing ROI: questions

What export should you use?

Use a campaigns export and a deals export from HubSpot. The campaigns file needs the campaign fields you use to match records and the spend value. The deals file needs the fields for deal revenue, won status, and campaign attribution.

What happens to rows that do not match?

Rows that do not match a campaign stay out of the matched result. You can review them, fix the source data, or adjust the matching rule and run the workflow again.

How do you change the rules?

Edit the step logic in plain words, for example by changing the join key, the filter for won deals, or the ROI formula. Then rerun the workflow on the exports.