MARKETING
Weekly UTM Drift Tracker with Trend Snapshot
Every week, measures what share of tracked links conform to your UTM taxonomy, stores the score in a Postgres history table.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule (Monday 08:00)
- ActionRead last 7 days of links + prior scorePostgres
- LogicCompute conformance % and worst dimension
- ActionAppend new score to trend tablePostgres
- LogicFormat week-over-week drift
- OutputPost trend snapshot to SlackSlack
What it does
Turns UTM hygiene into a trackable KPI. Once a week it pulls recent link data, computes a conformance percentage (clean links over total), appends that score to a Postgres trend table, and compares it to the prior week. The Slack summary shows the current conformance rate, the direction of drift, and which source or medium degraded most.
When to use it
Use it when one-off audits aren't moving the needle and you need a recurring scorecard to hold campaign owners accountable. The stored history lets you chart hygiene over a quarter and prove whether enforcement is working.
How it works
- 1A weekly schedule triggers the run.
- 2A Postgres query reads the last seven days of link rows and last week's stored score.
- 3A scoring step computes the conformance percentage and isolates the largest declining dimension.
- 4A step writes the new score and timestamp back to the trend table.
- 5A logic step formats the week-over-week delta and direction.
- 6The trend snapshot is posted to Slack.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 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.