MARKETING
Weekly UTM Hygiene Audit Against Warehouse
Compares the campaigns logged in the Airtable UTM base against the utm_campaign values actually seen in BigQuery sessions, flags untracked, orphaned, and malformed tags.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule triggers audit
- ActionRead registered campaigns from Airtable UTM baseAirtable
- ActionQuery distinct utm_campaign values from BigQueryBigQuery
- LogicDiff sets and validate naming convention
- OutputPost cleanup checklist to SlackSlack
What it does
Dirty UTM tags quietly corrupt every CAC number downstream. This workflow audits hygiene weekly: it lists the campaigns your team has registered in the Airtable UTM base and the distinct utm_campaign values BigQuery actually recorded, then reconciles the two. It flags live campaigns missing from the sheet, sheet entries with zero recent traffic, and tags that violate your naming convention — and reports them to Slack so they get cleaned before the next budget review.
When to use it
Use it when your CAC and ROAS figures feel untrustworthy because of inconsistent or stray UTM tagging. Run it ahead of the weekly reallocation so decisions rest on clean attribution.
How it works
A weekly schedule triggers the audit. It reads the registered campaign list from the Airtable UTM base and queries BigQuery for distinct utm_campaign values with recent sessions. A logic step diffs the two sets and validates each tag against your naming pattern, bucketing issues into untracked, orphaned, and malformed. The categorized findings are posted to Slack as an actionable cleanup checklist.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 2Connect BigQueryDatasets, queries, schemas.
- 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.