MARKETING
Ad-Spend Webhook Ingest with UTM Normalization
Receives daily ad-spend exports via webhook, normalizes and validates the UTM campaign tags against a canonical naming convention.
How it runs
The automated pipeline, trigger to output.
- TriggerInbound spend payload webhook receivedHTTP webhook
- LogicNormalize UTM tags and validate required fields
- ActionInsert clean rows into warehouse spend tableBigQuery
- ActionWrite malformed rows to rejects tableBigQuery
- OutputPost accepted vs rejected counts to SlackSlack
What it does
This workflow is the ingestion front door for the whole reconciliation system. It accepts ad-spend payloads pushed from your ad platforms or an ETL job, normalizes inconsistent UTM tags (case, spacing, known aliases) to a canonical convention, validates required fields, and writes the cleaned rows into the warehouse spend table that every downstream rollup reads.
When to use it
Use it when spend arrives in messy, inconsistent formats and bad UTM tags are corrupting your reconciliation. Standardizing at ingest means every report downstream tells the same truth.
How it works
An inbound webhook receives the spend payload. A logic step normalizes UTM fields against an alias map and validates that campaign, date, and spend are present and well-formed; malformed rows are diverted. Clean rows are inserted into the BigQuery spend table with a load timestamp. Any rows that failed normalization are written to a rejects table and a count of accepted versus rejected rows is posted to Slack so data issues surface immediately.
Set it up
What you configure once, before turning it on.
- 1Connect HTTP webhookTrigger any URL on agent actions.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.