MARKETING

Bulk UTM Cleanup and Corrected-Link Writeback

On demand, reads a campaign-link sheet from Airtable, auto-corrects fixable UTM violations (casing, spaces, aliasing) and flags the rest.

CategoryMarketing
Enginesim
Difficultybeginner
Triggermanual
Steps6
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerManual run against link table
  • ActionRead flagged link records from AirtableAirtableAirtable
  • LogicNormalize UTMs and rebuild corrected URLs
  • LogicBranch: auto-fixed vs needs review
  • ActionWrite corrected URLs + tags to AirtableAirtableAirtable
  • OutputSummarize fixed vs flagged in SlackSlack

What it does

Remediates an existing backlog of dirty links rather than gating new ones. Triggered manually against an Airtable table of campaign URLs, it normalizes each UTM value (lowercases, replaces spaces with hyphens, maps known source aliases to canonical names), rebuilds a corrected URL, and writes it back. Violations it cannot safely auto-fix are tagged for human review.

When to use it

Use it as a one-time or ad-hoc cleanup pass when you adopt a new taxonomy and inherit thousands of legacy links. It does the mechanical 80% automatically and hands you a short list of genuine judgment calls.

How it works

  1. 1A manual trigger starts the cleanup run.
  2. 2An Airtable read pulls all link records flagged for review.
  3. 3A normalization step rewrites fixable UTM values and rebuilds each corrected URL.
  4. 4A branch separates auto-fixed links from records needing human review.
  5. 5An Airtable update writes corrected URLs and a status tag back to each record.
  6. 6A Slack message summarizes how many were fixed versus flagged.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.