MARKETING
Nightly UTM Drift Audit from BigQuery
Each night scans the day's live click traffic in BigQuery for UTM values that violate the naming registry.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule after analytics data lands
- ActionQuery distinct UTM tuples and session counts in BigQueryBigQuery
- ActionLoad approved naming registry from CodaCoda
- LogicFlag off-convention tuples, rank by sessions affected
- OutputPost ranked drift digest to SlackSlack
What it does
Finds UTM tagging mistakes that already made it into production. It queries yesterday's sessions in BigQuery, extracts the distinct UTM combinations actually being recorded, and checks each against the approved registry. Anything off-convention is surfaced with how many sessions it polluted, so you fix the highest-impact leaks first.
When to use it
Run it daily for analytics and growth teams who care about clean attribution. It catches drift that preflight validation misses: links built outside the official tooling, vendor-appended parameters, and stale campaign names that slipped back into rotation.
How it works
- 1A scheduled trigger fires once nightly after data lands.
- 2A BigQuery query pulls distinct UTM tuples and session counts from the prior day.
- 3The naming registry is loaded from Coda for comparison.
- 4Logic flags every tuple whose source, medium, or campaign value isn't in the registry, ranking by sessions affected.
- 5A Slack digest posts the top offenders with traffic volume and the likely correct value; clean nights post a short all-clear.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect CodaDocs, packs, automations.
- 3Connect SlackChannels, DMs, threads, mentions.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Marketing workflows
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.
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.
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.
Nudge translators on overdue localization returns and escalate stuck ones
Runs on a daily schedule, scans monday.com translation subtasks for items past their return date that aren't marked Returned, reminds the assigned translator in Slack.
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.
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.