MARKETING
Flag CTR-declining ad creatives and queue refresh briefs in Notion
Scans BigQuery ad-performance data each morning, flags creatives whose click-through rate has dropped past your threshold over a rolling window.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule fires the fatigue scan
- ActionQuery per-creative CTR for current and baseline windowsBigQuery
- LogicKeep creatives past the CTR-decay threshold with enough impressions
- ActionCreate a pre-filled refresh brief in Notion for each flagged creativeNotion
- OutputPost a digest of opened briefs to SlackSlack
What it does
Every morning this workflow queries your BigQuery ad-performance table, computes each creative's CTR trend over a rolling 7-day window versus its prior baseline, and identifies the ones whose performance has decayed past a set threshold. For each flagged creative it creates a refresh brief in a Notion database so your creative team has a ready-to-action ticket instead of a raw spreadsheet row.
When to use it
Run this when you manage a meaningful number of live ad creatives and CTR erosion sneaks up on you. It's for performance marketers who want fatigue caught automatically and turned into briefed work, not a dashboard nobody checks.
How it works
A daily schedule fires the run. A BigQuery action pulls per-creative impressions and clicks for the current window and the baseline window. A logic step computes the relative CTR drop and keeps only creatives past the decay threshold with enough impressions to be significant. For each survivor, a Notion action creates a brief page pre-filled with the creative name, current vs baseline CTR, spend, and a suggested refresh angle. A final Slack output posts a digest of how many briefs were opened and links them.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect NotionPages, databases, comments.
- 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
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.
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.
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.
Nudge translators on overdue localization returns and escalate stuck ones
Runs on a daily schedule, scans monday.com translation subtasks for items past their return date that aren't marked Returned, reminds the assigned translator in Slack.
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.
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.