Track Campaign UTM Links in a Sheet
Every morning, WebRun opens Google Analytics, pulls the previous day's sessions, clicks, and goal completions for each UTM source and campaign, appends the rows to your campaign tracking sheet, and sends a Slack summary of the top and bottom performers.
How can I automatically track my campaign UTM links in a live Google Sheet?
Every morning, WebRun opens Google Analytics, pulls the previous day's sessions, clicks, and goal completions for each UTM source and campaign, appends the rows to your tracking sheet, and sends a Slack summary of the top and bottom performers - so you always know which campaigns are working.
- A live Google Sheet tracks every UTM campaign's daily performance automatically
- Top and bottom performers are surfaced in Slack each morning
- Manual data exports from Google Analytics are eliminated entirely
Built for digital marketers · performance marketing teams · growth teams · marketing agencies running multiple campaigns
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
analytics.google.comin a real browser with your saved login - no setup, no API keys. -
1
Google Analytics - pull UTM campaign performance data
google.com
WebRun opens Google Analytics to pull UTM campaign performance data. - Open Google Analytics and go to Acquisition, then Campaigns, then All Campaigns
- Set the date range to Yesterday and filter to sessions where utm_source is set
- Export the columns: source, medium, campaign, sessions, goal completions, and conversion rate
Done when Yesterday's UTM campaign data is captured across all active sources and mediums.
-
2
Google Sheets - append metrics to the tracking sheet
WebRun opens Google Sheets to append metrics to the tracking sheet. - Open the Campaign UTM Tracker sheet
- Append one row per campaign: date, source, medium, campaign name, sessions, conversions, and conversion rate
- Update the rolling 7-day totals in the summary tab
Done when Yesterday's UTM data is appended and the summary tab reflects updated totals.
-
3
Slack - report top and bottom performers
slack.com
WebRun opens Slack to report top and bottom performers. - Post a morning summary to #marketing with the top 3 campaigns by conversions and any campaign with zero conversions despite significant spend
- Include a link to the full sheet for deeper review
Done when You have a Slack digest of yesterday's best and worst UTM performers.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it create or change any campaigns?
No - it is purely a read and log workflow. It never creates, edits, or pauses campaigns or UTM links.
Can it track multiple websites?
Yes. Add each Google Analytics property to the plan and WebRun will pull and tag data from all of them into the same sheet.
What if a campaign had no traffic yesterday?
It will still log a row with zero values so the sheet stays consistent and you can spot inactive campaigns easily.
Related templates
Instagram›Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.