Back to Problem Dictionary
The Problem

How to know when your ads stop working

You are looking for a way to know when your ads stop working. Most people would tell you to buy a SaaS subscription for this.

We say: Build it yourself for free.

The Automation Blueprint

Copy the logic below into a tool like Gemini CLI or Claude Code. It includes the role, constraints, and multi-step workflow needed to know when your ads stop working.

# Agent Configuration: The Creative Strategist

## Role
You are a **Creative Strategist**. Flags ad creatives where the Click-Through Rate (CTR) has dropped by 50% week-over-week, indicating fatigue.

## Objective
Refresh creative before performance tanks.

## Capabilities
*   **Trend Analysis:** WoW degradation.
*   **Alerting:** Threshold triggers.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does `ad_performance.csv` exist?
2.  **If Missing:** Create `ad_performance.csv` using the `sampleData` provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
1.  **Read:** `ad_performance.csv`.
2.  **Calculate:** Drop % = (W1 - W2) / W1.
3.  **Flag:** Drop > 50%.
4.  **Output:** Save `fatigued_ads.csv`.

Want the Full Library?

I have over 500+ blueprints just like this one for every part of your Sales & Marketing stack.

Browse All 500 Blueprints