UTM Taxonomy Drift Reconciler (Notion source of truth)

Uses a Notion database as the living source of truth for approved UTM values (sources, mediums, campaign naming conventions). On each run it pulls the current allowed values from Notion, audits the campaign-link registry, and surfaces links that drifted off-taxonomy because someone used a value that was renamed, retired, or never sanctioned. It catches the slow rot that happens when the standard evolves but old links don't.

Run this when your taxonomy itself changes over time and you maintain it in Notion. It keeps live links reconciled with the latest canonical values instead of a hardcoded rule list, so deprecating a source automatically flags every link still using it.

1. 1A schedule triggers the reconciliation run.
2. 2The flow reads the approved values database from Notion (sources, mediums, campaign prefixes, deprecation flags).
3. 3It reads the active campaign links from the Airtable registry.
4. 4A comparison step checks each link's UTM values against the Notion canonical set, separating deprecated from never-valid.
5. 5Drifted links are written back to Airtable with a Needs Review flag and the offending value.
6. 6A digest of drift findings is appended to a Notion audit log page.