---
name: google-searches-that-bring-customers
description: "Google Search Console shows every search you appeared for, free. Export it, give it to Claude, and get a list of pages that are one small fix away from page one. Use when the user asks to: see which google searches bring you customers."
---

Walk the user through this workflow. Check each setup step is done before running the prompts, and ask for anything marked [LIKE THIS] before starting.

# See which Google searches bring you customers

Google Search Console shows every search you appeared for, free. Export it, give it to Claude, and get a list of pages that are one small fix away from page one.

## Setup
1. Add your website to Search Console and verify it. If it's new, give it a few days to collect data.
2. Open Performance, then Search results. Set the date range to the last 3 months and switch on all four numbers (clicks, impressions, CTR, position).
3. Click Export and download it as a CSV or Google Sheet. You want the Queries and Pages tabs.
4. Open Claude, attach the export and paste the prompt below.

## Tools
- Google Search Console (https://search.google.com/search-console): Free. Shows searches, impressions, clicks, click rate and position for up to 16 months.
- Claude (https://claude.ai): Reads the export and finds the quick wins.

## Prompts
### Find the quick wins
Paste into Claude with your Search Console export attached.

```
This is my Google Search Console export for [YOUR WEBSITE], a [WHAT YOU SELL] business in [WHERE YOU TRADE].

1. Find the searches where my average position is between 8 and 20 and impressions are high. These are one fix away from page one. List the top 15 with their page.
2. Find searches with lots of impressions but a click rate under 2%. My title or description probably doesn't match what people want. Suggest a new title (under 60 characters) and description (under 155) for each.
3. Group the searches by what the person wants (price, near me, how-to, comparison, a specific product) and tell me which group I'm missing pages for.
4. Ignore searches for my own brand name.

Finish with a to-do list of no more than 10 changes, biggest likely gain first. Don't make up search volumes; only use the numbers in the export.
```

## Worth knowing
- Search Console data runs about two days behind. After you change a page, give it a few weeks before you judge the result.

Source: https://kodebykraft.com/guides/google-searches-that-bring-customers (The Leaky Funnel, @theleakyfunnel)