MARKETING
Untagged & Mismatched Revenue Quarantine
On new Stripe payments, checks whether the customer carries a valid UTM tag matching a known BigQuery campaign and logs any untagged or unrecognized-campaign revenue to Airtable…
How it runs
The automated pipeline, trigger to output.
- TriggerStripe payment succeededStripe
- ActionConfirm campaign exists in spend tableBigQuery
- LogicRoute untagged / unknown-campaign revenue
- OutputAppend flagged revenue to Airtable queueAirtable
What it does
It protects attribution data quality at the source. Every time a payment succeeds, it inspects the customer's UTM tags and verifies the campaign actually exists in your BigQuery spend table. Revenue that is untagged, or tagged to a campaign nobody is spending on, gets quarantined into an Airtable cleanup queue.
When to use it
Use it when your ROAS numbers feel off because revenue isn't reliably tagged, or when sales-assisted and organic deals leak in without UTMs. It gives ops a concrete worklist instead of a vague 'attribution is broken' complaint.
How it works
- 1A Stripe payment-succeeded event triggers the workflow.
- 2The customer's `utm_campaign` and related tags are read from Stripe metadata.
- 3A BigQuery lookup confirms whether that campaign exists in the spend table.
- 4A logic branch routes the payment: tagged-and-known revenue passes through untouched; untagged or unknown-campaign revenue is flagged.
- 5Flagged records are appended to an Airtable quarantine table with amount, customer, raw tags, and reason for manual attribution fix.
Set it up
What you configure once, before turning it on.
- 1Connect StripeCustomers, subscriptions, payments.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Connect AirtableBases, tables, views, automations.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, 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.