Instructions

• Download a search terms report from Performance Max:
  • Include the columns: clicks; impressions; conversions; cost; conv. rate; conv. value
  • Before downloading, filter the report to only look at converting search terms
  • Download to gsheet format, open the sheet
  • Delete the top two rows from the report
  • The top row of the table should now be the header row
  • Download the file to .csv format
  • Rename the file to “search terms report.csv”
• Download the full keyword list from Google:
  • From the all campaigns screen make sure you are looking at all campaigns, all ad groups
  • Go to the keywords list and make sure you are looking at all keywords (including paused and removed)
  • It doesn’t really matter what columns you include
  • Download to gsheet format, open the sheet
  • Delete the top two rows from the report
  • The top row of the table should now be the header row
  • Download the file to .csv format
  • Rename the file to “search keywors report.csv”
• Paste the below prompt into ChatGPT (Claude and Google Gemini make a lot more errors and take longer than ChatGPT on this particular task) and attach the two downloaded files.
• Run the prompt, the file it spits out will show all converting terms from PMax that you are NOT currently targeting in Search

Prompt

✅ Keyword Gap Analysis Prompt— Client-Ready Report

I have attached two Google Ads reports to analyze:

1. "search terms report.csv" — all search terms that triggered my ads

2. "search keyword report.csv" — all keywords currently in my Google Ads account

⸻

Task

Find all search terms that have a keyword gap, meaning either:

• Missing Keyword: The search term has no matching keywords in my account (exact spelling match required, case-insensitive).

• Not Eligible: The search term does have matching keywords, but none of those matching keywords are Eligible (e.g., all are Paused, Rarely Served, etc.).

• Important: a keyword can appear multiple times in the keyword list with different statuses. You must check all instances of a matching keyword before deciding eligibility.

⸻

Matching Rules

• Keywords must match search terms exactly in spelling (case-insensitive).

• Before comparing, strip match-type syntax from keywords: