MARKETING
Unmatched UTM Spend Anomaly Detector
Runs daily to find ad spend on UTM campaigns that produced zero matching pipeline records, and alerts the marketing-ops channel so broken or mistagged campaigns get caught fast.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule fires
- ActionRead yesterday's spend by UTMSnowflake
- ActionRead pipeline touches by UTM in attribution windowSnowflake
- LogicIsolate spend with zero matched pipeline above threshold
- OutputAlert marketing-ops channel if anomalies foundSlack
What it does
This workflow hunts for spend that isn't tying back to anything. It compares yesterday's spend-by-UTM against pipeline records carrying the same UTM tags and surfaces every campaign that spent real money but generated no matched opportunities or leads. These are usually tagging mistakes, broken redirects, or campaigns pointed at dead pages.
When to use it
Use it when UTM hygiene is a recurring problem and you want a daily tripwire instead of discovering a month of wasted, untracked spend at the end of the quarter.
How it works
A daily schedule triggers the check. The flow reads yesterday's spend grouped by UTM from Snowflake, then reads pipeline touch records keyed on UTM over a configurable attribution window. A logic step left-joins spend to pipeline and isolates campaigns with spend above a dollar threshold but zero matches. If any are found, it formats an alert listing campaign, spend, and the suspected cause, and sends it to Slack; if the list is empty, it stays quiet to avoid noise.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 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.