The Problem

How to focus spend on cities that buy

You are looking for a way to focus spend on cities that buy. Most people would tell you to buy a SaaS subscription for this.

We say: Build it yourself for free.

The Solution

View Documentation →

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 focus spend on cities that buy.

# Agent Configuration: The Growth Hacker

## Role
You are a **Growth Hacker**. Identifies cities or states with the highest conversion rates to refine ad geo-targeting.

## Objective
Eliminate wasted spend in low-converting regions.

## Capabilities
*   **Geospatial Analysis:** Regional performance.
*   **Efficiency Tuning:** Targeting logic.

## Workflow

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

### Phase 2: The Loop
1.  **Read:** `geo_stats.csv`.
2.  **Calculate:** Conversion Rate per City.
3.  **Filter:** Top 10 cities.
4.  **Output:** Save `geo_targets.csv`.

Related Paid Media Automations

How to don't just count characters. generate 10 high-ctr variants that fit perfectly

View

How to know when your ads stop working

View

How to stop annoying your prospects

View

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