MARKETING
Weekly UTM Drift Report from BigQuery to Slack
Each week this rolls up every UTM value seen in the BigQuery clickstream that falls outside the approved taxonomy, ranks the worst offenders by traffic volume.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires
- ActionAggregate last 7 days of UTMs from BigQueryBigQuery
- LogicFlag non-compliant values and compute drift metrics
- LogicRank worst offenders by click volume
- OutputPost compliance digest to Slack channelSlack
What it does
Gives marketing leadership a recurring view of how badly tracking is drifting. Weekly, it aggregates the prior seven days of clickstream from BigQuery, compares every distinct UTM value against the approved taxonomy, and produces a ranked digest: the top non-compliant sources and mediums by click volume, the campaigns with free-text names, and the week-over-week change in compliance rate. The digest is posted to a Slack channel.
When to use it
Use it for visibility and accountability rather than per-link fixing. It surfaces which channels or teams are generating the most untracked or malformed traffic so you can target coaching, and it trends compliance over time so you can prove the program is working.
How it works
- 1A weekly schedule fires the workflow.
- 2It queries BigQuery to aggregate distinct UTM values and their click volume for the last seven days.
- 3Logic flags values outside the taxonomy and computes the compliance rate and week-over-week delta.
- 4It ranks the worst offenders by traffic so the digest leads with what matters.
- 5The formatted digest is posted to the marketing Slack channel.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Marketing workflows
Agentic UTM Taxonomy Steward: Detect, Explain, and Propose Fixes
An agent reviews the full backlog of campaign links in Airtable, reasons about taxonomy drift beyond rigid rules, drafts standardized replacements for malformed UTMs.
Slack UTM Check: Paste a Link, Get an Instant Verdict
Lets marketers drop a tracking URL into a Slack channel and get an immediate threaded reply that says whether the UTMs are valid, what is wrong, and a corrected suggestion.
Backlink Outreach Drafter for Verified Mentions
Picks verified, high-authority unlinked mentions from Airtable, drafts a personalized backlink-request email for each.
Source-Authority Verifier for Mention Provenance
Takes a queue of detected brand mentions and runs an agent that verifies whether each source is a legitimate, authoritative publisher versus a scraper or syndication copy.
Unlinked Brand-Mention Detector with Authority Scoring
Scans the web for fresh brand mentions, filters to ones that name you without linking back, scores the publishing domain's authority.
Weekly Brand-Mention Provenance Digest to Notion
Aggregates the week's tracked mentions from Airtable into a single summarized report covering new opportunities, authority distribution, and outreach progress.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.