Marketing attribution first touch last touch
“compare first touch and last touch attribution of won deal revenue by channel”
Compare first touch and last touch attribution of won deal revenue by channel in HubSpot deals export.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileHubSpot deals exportCSV export · 14 rows
- StepCompare revenue by channelStep 1
- ResultWon Deal Attribution11 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 11 rows came out.
- Download HubSpot deals export sample (14 rows)HubSpot: Sales > Deals > Export view filtered to Closed won deals, include attribution properties
What you get back
The result of that run, the rows to look at first.
| Channel | First touch revenue | Last touch revenue |
|---|---|---|
| Direct Traffic | 13,600 | 28,900 |
| Email Marketing | 18,700 | 25,000 |
| Event | 26,500 | 0 |
| Organic Search | 18,500 | 30,900 |
| Organic Social | 11,250 | 0 |
| Paid Search | 6,400 | 78,300 |
| Paid Social | 26,950 | 31,000 |
| Partner Referral | 65,100 | 23,100 |
| Referral | 12,400 | 0 |
| Review Sites | 17,800 | 0 |
| Webinar | 15,400 | 15,400 |
How do you compare first touch and last touch attribution by channel?
Export your HubSpot deals file and upload it here. Then compare won deal revenue by channel using first touch and last touch attribution side by side. You can see which channels first created demand and which ones closed the deal.
How it works
How to use the Won Deal Attribution 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.
Won Deal Attribution: questions
What export should you use?
What happens if some rows do not match the rules?
How do you change the attribution rules?
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
Decide which pages to keep, update or prune, and find the search terms that spend without converting.
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template
- Google Ads wasted spendFind search terms with spend and no conversions in the last 30 days, ranked by spend, from a Google Ads export.See the workflow Built by the agent
- Keyword rankings changeCompare this month's average position with last month from Search Console and see which keywords moved up or down in a keyword ranking report.See the workflow Built by the agent
- Negative keyword finderEvery search term that spent money and never converted, with its share of spendSee the workflow Template
- Marketing ROI by campaignCalculate marketing ROI for each campaign from HubSpot exports, using won deal revenue and campaign spend.See the workflow Built by the agent