Skip to content
    The Leaky Funnel@theleakyfunnelTake me to the agency site
    All guides

    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.

    Skip the reading: hand it to Claude

    Copy the whole guide and paste it into Claude, or install it as a Claude Code skill so it’s always there.

    Download as a Claude skill

    Save it as ~/.claude/skills/google-searches-that-bring-customers/SKILL.md, then ask Claude Code to “see which google searches bring you customers”.

    The 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.

    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.

    What I use

    • Google Search ConsoleFree. Shows searches, impressions, clicks, click rate and position for up to 16 months.
    • ClaudeReads the export and finds the quick wins.

    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.