Workflow · Search and ads · Opening soon
UTM campaign report
Build a UTM report from your Google Analytics export. Group sessions and conversions by utm source, medium, and campaign.
Someone typed
“group sessions and conversions by utm source, medium and campaign”
The agent read it as
Group sessions and conversions by utm source, medium and campaign in Google Analytics UTM campaign report.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Google Analytics UTM campaign report
CSV export · 16 rows
Step
Group UTM sessions and conversions
Step 1
Result
UTM Session Summary
16 rows
Schedule
Runs when you say
Proposed
- FileGoogle Analytics UTM campaign reportCSV export · 16 rows
- StepGroup UTM sessions and conversionsStep 1
- ResultUTM Session Summary16 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out.
- Download Google Analytics UTM campaign report sample (16 rows)Google Analytics 4: Reports > Acquisition > Traffic acquisition > Export, with Session source, Session medium, Session campaign, Sessions, and Conversions
What you get back
The result of that run, the rows to look at first.
UTM Session SummarySample data16 rows
| UTM source | UTM medium | UTM campaign | Sessions | Conversions |
|---|---|---|---|---|
| cpc | brand_search_q4 | 1,840 | 214 | |
| cpc | spring_sale | 1,260 | 118 | |
| cpc | retargeting_cart | 740 | 92 | |
| organic | brand | 980 | 76 | |
| paid_social | creator_collab_launch | 620 | 33 | |
| newsletter | monthly_digest | 510 | 48 | |
| youtube | video | how_to_series | 390 | 14 |
| quora | paid_social | problem_awareness | 185 | 8 |
| bing | cpc | competitor_search | 410 | 29 |
| paid_social | prospecting_us | 1,560 | 61 | |
| paid_social | retargeting_viewers | 890 | 54 | |
| paid_social | b2b_leadgen_q3 | 340 | 25 |
How do you group sessions and conversions by utm source, medium, and campaign?
Export your Google Analytics report and upload it to Mammoth. Then group sessions and conversions by utm source, medium, and campaign to build your UTM campaign report. The result is a UTM session summary.
How it works
How to use the UTM Session Summary 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.
UTM Session Summary: questions
What export should you use?
Use a Google Analytics export that includes utm source, utm medium, utm campaign, sessions, and conversions.
What happens to rows that do not match?
Rows that do not fit the grouping rules stay out of the grouped summary. You can review them in the source file and adjust the rules if needed.
How do you change the rules?
Edit the rule words so they match the fields you want to group by. You can add, remove, or rename the grouping terms, then run the workflow again.
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