geo-conflict-analyzer

To detect geo-target conflicts in Google Ads, the analyzer reads search queries from a Google Sheet, groups them by CID with active geo targets, and sends batches to GPT-4o to determine PASS/FAIL results with confidence scores. It then writes the validated results back to an output tab.

Checking search queries for geo conflicts prevents unsafe negative keywords that would block legitimate traffic. By validating whether a query matches active geographic areas in GEO campaigns, you avoid accidentally excluding valid search terms and losing relevant ad traffic.

You process search queries in batches by running the analysis script after configuring your environment. The script reads queries marked as 'Waiting' from a Google Sheet tab and sends grouped batches to OpenAI GPT-4o for automated PASS/FAIL conflict evaluation.

Yes, you need an OPENAI_API_KEY and a Google Sheets OAuth token to run geo-conflict analysis. These credentials allow the script to access your sheet data, process queries through GPT-4o, and write the conflict results back to the spreadsheet.

Yes, you can integrate geo conflict analysis into an SQR workflow. The analyzer works alongside an off-brand analyzer to provide complete Search Query Report guardrails, ensuring safe geo targeting decisions and preventing negative keyword conflicts across campaigns.