MARKETING
Spend-Without-Revenue Campaign Alert
Hourly check that flags any UTM campaign accumulating ad spend in BigQuery with zero matching Stripe revenue over a rolling window, and pages the channel to pause it.
How it runs
The automated pipeline, trigger to output.
- TriggerHourly schedule
- ActionRolling 72h spend per campaignBigQuery
- ActionMatching Stripe revenue per campaignStripe
- LogicKeep spend-over-floor + zero-revenue campaigns
- OutputAlert Slack with pause recommendationSlack
What it does
It catches the most expensive marketing failure mode: campaigns burning budget that produce no revenue. On a rolling window it compares spend to revenue per UTM campaign and alerts the moment a campaign crosses a spend floor while still showing zero attributed Stripe revenue.
When to use it
Run this when you have several live campaigns and want an early-warning tripwire rather than discovering wasted spend at end-of-month. Tune the spend floor and window to your typical conversion lag.
How it works
- 1An hourly schedule triggers the check.
- 2BigQuery returns rolling 72-hour spend per `utm_campaign`.
- 3Stripe revenue for the same campaigns and window is pulled and totaled.
- 4A logic step keeps only campaigns where spend exceeds the floor AND revenue is zero, accounting for the conversion-lag window.
- 5If any qualify, a Slack alert lists each offending campaign, its burned spend, and a recommended pause. If none qualify, the run ends silently.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect StripeCustomers, subscriptions, payments.
- 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.