Validate New Campaign Links Against UTM Taxonomy in Airtable

Guards the single source of truth for campaign links. Every time a new row lands in your Airtable "Campaign Links" table, the workflow parses the URL's UTM parameters and validates each one (source, medium, campaign, content, term) against the canonical taxonomy you maintain in a reference table. Clean links are flipped to Valid; malformed ones get a precise, human-readable list of what's wrong written into a Validation Notes field.

Use it when link hygiene is decaying because anyone can drop a URL into the tracker and there's no gate. Ideal for teams who already centralize links in Airtable and want errors caught at entry instead of surfacing weeks later as broken attribution.

1. 1A new record is created in the Airtable Campaign Links table.
2. 2The flow reads the URL field and splits out each UTM parameter.
3. 3It loads the approved values from the Airtable UTM Taxonomy reference table.
4. 4Logic compares each parameter: unknown source/medium, free-text campaign names, or missing required tags are collected as violations.
5. 5If clean, it sets Status to Valid. If not, it writes the violation list and sets Status to Needs Fix, updating the same record in Airtable.