UTM Link Linter: Block Malformed Tracking URLs Before Launch

Reads campaign links staged for launch in Airtable, runs each one through a deterministic UTM hygiene check (required params present, lowercase, no spaces, approved source/medium values, no double-encoded ampersands), and writes a Pass/Fail verdict plus a human-readable reason back to each row. It finishes by posting a launch-readiness summary to Slack.

Run this as the final gate before a marketing launch when links are assembled in a shared Airtable base. It catches the silent attribution killers — uppercase mediums, `utm_campaign` typos, trailing spaces — that would otherwise scatter traffic across phantom campaign rows in your analytics.

1. 1A scheduled trigger fires each weekday morning and pulls rows from the Airtable launch table where Status is Queued.
2. 2For each link, the linter parses the query string and checks required UTMs, casing, allowed source/medium values, and encoding integrity.
3. 3A branch routes clean links to a Pass path and flagged links to a Fail path with a specific reason string.
4. 4Each verdict and reason is written back to its Airtable row.
5. 5A Slack message summarizes total checked, passed, and a bullet list of every failure so the owner can fix before launch.