MARKETING

Frequency-Cap Fatigue Alert to Slack with Monday Refresh Task

Watches ad frequency in BigQuery and, when a creative's frequency exceeds the cap while CTR slides, posts a Slack alert to the growth channel and opens a refresh task on a Monday…

CategoryMarketing
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerScheduled frequency check
  • ActionPull frequency and CTR trend from BigQueryGoogle BigQueryBigQuery
  • LogicKeep creatives over cap with falling CTR
  • ActionPost fatigue alert to Slack growth channelSlack
  • OutputCreate refresh task on Monday boardmonday.com

What it does

This workflow tracks per-creative frequency (average impressions per unique user) and pairs it with CTR trend. When a creative crosses your frequency cap and its CTR is simultaneously falling, that's a clear fatigue signal — the same people are seeing the ad too often and tuning it out. The workflow alerts the growth team in Slack and creates a refresh task on a Monday board with the creative name, current frequency, and CTR delta prefilled.

When to use it

Use this on always-on prospecting campaigns where audience sizes are finite and frequency creeps up over the flight. It's the early-warning version of fatigue detection — it fires on overexposure before the cost-per-result blows out.

How it works

  1. 1A schedule runs the check on your chosen cadence.
  2. 2BigQuery returns frequency and CTR trend per active creative.
  3. 3A logic step keeps only creatives over the frequency cap with a declining CTR.
  4. 4For each, a Slack message posts to the growth channel summarizing the signal.
  5. 5A Monday item is created on the creative-refresh board, owned and ready to schedule.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  3. 3
    Connect monday.comVisual work management for teams.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.