GA4 channel report to Excel every month
“export our ga4 traffic by session default channel group and month to excel with sessions, engaged sessions, key events and revenue, and flag channels whose key events fell by more than a third, channels with revenue but no sessions, and the unassigned channel”
Export our GA4 traffic by month and session default channel group by session default channel group and month to excel with sessions, engaged sessions, key events and revenue, and flag channels whose key events fell by more than a third, channels with revenue but no sessions, and the unassigned channel, comparing key events with the previous month.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileGA4 traffic by month and session default channel groupCSV export · 24 rows
- StepFlag channel changesStep 1
- ResultGA4 Channel Flags24 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 24 rows.
- Download GA4 traffic by month and session default channel group sample (24 rows)GA4: Reports > Acquisition > Traffic acquisition > Customize report > Export to Excel
What you get back
The result of that run, the rows to look at first.
| Session default channel group | Month | Sessions | Engaged sessions | Key events | Revenue | Key events flag | Revenue flag | Channel flag |
|---|---|---|---|---|---|---|---|---|
| Unassigned | 2026-08-01 | 610 | 420 | 36 | 980 | · | · | Unassigned channel |
| Unassigned | 2026-09-01 | 598 | 410 | 34 | 910 | · | · | Unassigned channel |
| 2026-10-01 | 4,590 | 2,860 | 235 | 17,640 | Fell by more than a third | · | · | |
| Referral | 2026-10-01 | 0 | 0 | 9 | 1,240 | Fell by more than a third | Revenue with no sessions | · |
| Unassigned | 2026-10-01 | 625 | 432 | 38 | 1,040 | · | · | Unassigned channel |
| Direct | 2026-08-01 | 9,560 | 7,025 | 710 | 29,840 | · | · | · |
| 2026-08-01 | 4,120 | 3,380 | 410 | 18,460 | · | · | · | |
| Organic Search | 2026-08-01 | 12,480 | 9,820 | 840 | 41,250 | · | · | · |
| Organic Social | 2026-08-01 | 3,650 | 2,405 | 195 | 8,420 | · | · | · |
| Paid Search | 2026-08-01 | 8,420 | 6,115 | 620 | 35,680 | · | · | · |
| Paid Social | 2026-08-01 | 2,880 | 1,710 | 122 | 6,910 | · | · | · |
| Referral | 2026-08-01 | 2,140 | 1,580 | 148 | 9,260 | · | · | · |
How it works
How to use the GA4 Channel Flags workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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.
GA4 Channel Flags: questions
How do you export GA4 channel data to Excel each month?
What file should you export from GA4?
What happens to rows that do not match the rules?
How do you change the rules in words?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Remove duplicates, tidy names and addresses, fill the blanks, and merge files into one.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Merge Excel or CSV filesOne tidy table with every file's rows, re-sent rows dropped, and a Period columnSee the workflow Template
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Remove blank rowsRemove rows that are empty or only contain spaces from an Excel export, while keeping the rest of the sheet unchanged.See the workflow Built by the agent
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Multi-entity consolidationEvery entity's balances in one currency, by accountSee the workflow Template