MARKETING
Auto-Correct Malformed UTMs in the BigQuery Click Tracker
Runs nightly over your BigQuery clickstream, finds rows with malformed UTM parameters, normalizes them against the canonical taxonomy.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule fires
- ActionQuery BigQuery for rows with non-canonical UTMsBigQuery
- LogicNormalize values via alias and casing ruleset
- LogicBranch: confident correction vs. ambiguous
- ActionWrite corrected rows to cleaned attribution tableBigQuery
- OutputAppend per-correction audit logBigQuery
What it does
Fixes the data after the fact where it actually hurts: analytics. On a schedule it scans the raw click/event table in BigQuery, detects UTM values that don't match the approved taxonomy (wrong casing, trailing spaces, known aliases like "fb" for "facebook", deprecated source names), and applies deterministic correction rules. Corrected rows are written to a clean attribution table, and a small audit log records every change.
When to use it
Use it when historical and incoming clickstream data is fragmenting your channel reports because of inconsistent tagging you can't fix at the source. Best for teams whose marketing data already lands in BigQuery and who need a reliable normalization layer feeding dashboards.
How it works
- 1A nightly schedule fires the workflow.
- 2It queries BigQuery for rows in the raw events table whose UTM values fall outside the approved set.
- 3Logic maps each malformed value through a normalization ruleset (alias table, casing, whitelist) to its canonical form.
- 4Rows that can be confidently corrected are written to the cleaned attribution table; ambiguous ones are flagged for review.
- 5An audit row per correction is appended to BigQuery so the cleanup is fully traceable.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 3Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 4Test, 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.