MARKETING
Rotate Ad Spend Off CTR-Decaying Creatives
Pulls daily per-creative ad metrics from BigQuery, flags variants whose 3-day CTR has dropped a set percentage below their rolling 14-day baseline.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule fires the fatigue scan
- ActionQuery per-creative metrics from BigQueryBigQuery
- LogicCompute 3-day CTR vs 14-day baseline
- LogicFlag creatives decaying past threshold with live spend
- OutputPost ranked pause-and-reallocate list to SlackSlack
What it does
This workflow watches each active ad creative for early fatigue and tells your media buyer which variants to pause before performance collapses. It compares a creative's recent click-through rate against its own healthy baseline, so a strong-but-tiring ad gets caught while it still has salvageable spend.
When to use it
Run it when you maintain a rotating library of paid social or display creatives and want a daily, evidence-backed call on what to retire. It is built for teams whose spend outpaces their ability to eyeball every variant.
How it works
A daily schedule fires the run. The flow queries BigQuery for per-creative impressions, clicks, and spend, then computes each creative's trailing 3-day CTR and 14-day baseline. A logic step flags any creative whose recent CTR sits more than the configured threshold below baseline and still carries meaningful spend. Flagged creatives are sorted by wasted-spend impact and written to Slack as a ranked block, naming each variant, its decay percentage, and yesterday's burn. The buyer pauses and reallocates from one message.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, 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.