MARKETING
Real-Time CAC Spike Alert on Spend Webhook
When a daily spend export webhook lands, it pulls same-day conversions from BigQuery, computes rolling CAC.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily spend export webhook receivedHTTP webhook
- ActionQuery same-window conversions per channelBigQuery
- LogicCompute rolling CAC and check thresholds
- LogicFilter to breaches over 25 percent
- OutputPage growth team in SlackSlack
What it does
Instead of waiting for the weekly review, this workflow catches runaway acquisition costs as they happen. When your daily spend pipeline posts a webhook, it fetches the matching conversion counts from BigQuery, computes a rolling 3-day CAC per channel, and compares it to each channel's threshold. If a channel is burning more than 25 percent over target, it fires an alert so someone can pause or cap before the week is wasted.
When to use it
Use it when a single bad day of bidding can blow your monthly budget and the weekly cadence is too slow. Best for accounts with volatile auction dynamics or aggressive scaling tests.
How it works
An incoming webhook from your daily spend export triggers the run and carries the date and channel spend. The workflow queries BigQuery for same-window converted customers per channel. A logic step computes rolling CAC and evaluates each channel against its breach threshold. A branch filters out channels within tolerance; only breaches continue. For each breach it posts a tagged alert to Slack naming the channel, current CAC, target, and overage percentage.
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.