MARKETING
Untracked Campaign Spend Leak Detector
On a schedule, compares campaigns that incurred ad spend in BigQuery against campaigns present in Salesforce.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule
- ActionList campaigns with spend yesterdayBigQuery
- ActionList tracked campaign IDsSalesforce
- LogicDiff spend set against tracked set
- OutputAlert channel about untracked spendSlack
What it does
Finds the money you cannot attribute. It lists every campaign that spent budget yesterday from BigQuery, checks whether each one exists as a tracked campaign in Salesforce, and flags any spend going to campaigns with no attribution mapping, so dollars stop disappearing into an untracked bucket.
When to use it
Use it when your attribution numbers never add up because new campaigns get launched in ad platforms before anyone wires up UTM or campaign records in the CRM. It is the early-warning system for marketing ops to catch tracking gaps within a day instead of at quarter close.
How it works
- 1A daily schedule triggers the check.
- 2Query BigQuery for all campaign IDs with non-zero spend yesterday.
- 3Query Salesforce for the set of known, tracked campaign IDs.
- 4In a logic step, compute the set difference: spending campaigns absent from the CRM.
- 5If the leak set is empty, exit quietly; otherwise continue.
- 6Post the offending campaigns and their wasted spend to Slack so ops can wire up tracking the same day.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SalesforceAccounts, opportunities, cases.
- 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.