MARKETING
Daily UTM drift audit against BigQuery click data
Each morning it scans the previous day's click events in BigQuery for UTM values that violate your taxonomy.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule fires
- ActionQuery distinct UTM tuples and click counts from BigQueryBigQuery
- LogicValidate each tuple against approved taxonomy
- LogicRank violations by click volume
- OutputPost ranked drift report to SlackSlack
What it does
This workflow runs a scheduled audit over your live click and session data in BigQuery. It pulls every distinct UTM combination seen in the last 24 hours, scores each against your taxonomy (unknown sources, freeform mediums, casing mismatches, missing campaign IDs), and produces a ranked report of the worst offenders by click volume. The report lands in Slack so the team fixes high-traffic violations first.
When to use it
Use it when links are already in market and you need to catch taxonomy drift that slipped past pre-launch checks — vendor-appended parameters, hand-edited links, or legacy campaigns still firing.
How it works
- 1A daily schedule triggers the audit.
- 2A BigQuery query returns distinct UTM tuples and their click counts for the prior day.
- 3Each tuple is validated against the approved taxonomy.
- 4Violations are ranked by click volume so the costliest errors surface first.
- 5A formatted drift report with counts and example URLs 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.