MARKETING
Daily Ad-Fatigue Scanner: Frequency + CTR Decay Alerts
Each morning, scans yesterday's creative-level ad metrics in BigQuery, flags creatives where frequency has climbed and CTR has decayed past your thresholds.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule fires pre-standup
- ActionQuery per-creative frequency + CTR trendBigQuery
- LogicScore fatigue; filter past thresholds
- LogicExit if no creatives qualify
- OutputPost ranked fatigue watchlist to SlackSlack
What it does
Runs a daily query against your ad-performance warehouse, computes a fatigue score per creative from rising frequency and falling click-through rate, and drops a ranked watchlist into a Slack channel so the media team knows what to refresh before spend is wasted.
When to use it
Use it when you run always-on social or display campaigns and want a no-effort morning signal of which creatives are wearing out, instead of eyeballing dashboards. Best for teams whose ad data already lands in BigQuery.
How it works
- 1A daily schedule fires before the team's standup.
- 2A BigQuery query pulls per-creative frequency, impressions, CTR, and a 7-day CTR trend.
- 3A logic step computes a fatigue score and filters to creatives where frequency exceeds the cap AND CTR has fallen more than the decay threshold.
- 4If nothing crosses the line, the run exits quietly.
- 5Otherwise a Slack message posts the ranked list with current vs. baseline CTR, frequency, and wasted-spend estimate, tagging the channel owner.
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
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.