FreeNovember 2026ShopsLead-genShopsLead-genShopsLead-gen

Works with

Search Console, ChatGPT, BigQuery

Works with

Search Console, ChatGPT, BigQuery

Works with

Search Console, ChatGPT, BigQuery

Connect Search Console to ChatGPT

and check it before you trust it

Stop Paying for Free Clicks The same guide with a check on whether you pay for brand clicks you'd get for free.

What you get (+1 bonus)

Five routes, compared.
From a manual export to Google's bulk export into BigQuery, with what each route can reach and how much technical skill it needs. When we checked on 7 October 2026, Google offered no official Search Console connector for Claude or ChatGPT.
The money question.
Are you paying Google Ads for brand searches you'd win for free? How to line up paid and organic brand searches, and why only a controlled test can say how many paid clicks were extra.
15 prompts for shops and lead-gen.
Each labelled SAFE, VERIFY or WON'T WORK WITHOUT JOINED DATA. Three are written for shops, three for lead-gen sites, and the rest work for both, including brand versus non-brand.
A 10-minute trust test.
Five questions checked against the Search Console interface - totals, devices, your money pages, a top-10 list and a calculation - with a score that says whether to rely on the answers yet.
What Search Console can't show.
Hidden searches, row caps, Pacific Time dates, 16 months of history and an impressions logging error from May 2025 to April 2026, with how to read your numbers around each one.
+1 bonus
An AI skill for Claude, ChatGPT, Gemini or Copilot
that runs the trust test first, takes totals from the property rather than adding up rows, and splits brand searches only with the brand terms you give it.

Free · about 15 seconds

Who it's for, and who it's not for

The owner of a small service business sits in a showroom office with a laptop open to an AI chat and a printed list of search terms with some lines highlighted.

Who it's for

Online shop owners who get a share of their sales from Google search and want to know which searches and pages bring them.
Lead-gen businesses collecting enquiries through forms, calls or bookings who want to know which searches bring people to their service, location and contact pages.
Agencies and freelancers who look after search or Google Ads for clients and want quick answers from Claude or ChatGPT that they can check.

Who it's not for

SEO specialists who already pull Search Console data through the API or into BigQuery with their own tools - you'll know most of the setup.
Anyone without at least Restricted access to the Search Console property. If someone else manages it, pass the guide to whoever runs it.

What's inside

PDF · About 45 min read

Honest note

Search Console stops at the click: it has no sales or leads, and it hides searches made by very few people, so query rows never add up to the total. The guide shows how to read your numbers with those gaps in mind. The brand check shows where paid and free results overlap; only a controlled test can say how many paid clicks you'd have had anyway. The BigQuery and community-server routes need someone technical.

Free · about 15 seconds