offbrand-analyzer

Classify Google Sheets search queries into intent categories using brand matching rules.

58|9|Updated Apr 7, 2026

Search Tags:#query classification #google sheets #gpt-4o #brand matching #offbrand #ppc analytics

Ready to run

npx skills add https://github.com/fourteenwm/ppc-ai-skills --skill offbrand-analyzer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: offbrand-analyzer
Source: https://github.com/fourteenwm/ppc-ai-skills/tree/main/offbrand-analyzer
Command: npx skills add https://github.com/fourteenwm/ppc-ai-skills --skill offbrand-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openai, google-auth, google-api-python-client, python-dotenv, and includes scripts (resource) components.

What problem does it solve?

This skill automates the classification of search queries into high-intent, low-intent, informational, or off-brand, enabling safer and faster PPC planning by catching misclassifications early.

Core Features & Use Cases

Batch processing of queries from Google Sheets with a robust off-brand keyword reference.
Brand-first classification: prioritizes brand matches before tagging as off-brand to reduce false positives.
Use Case: A PPC manager runs weekly audits to ensure queries are correctly labeled, speeding reporting and optimization.

Quick Start

Load the skill and run the analyzer against the Have Cost sheet with a sample batch to see results.

Frequently Asked Questions about offbrand-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I classify search queries as high intent, low intent, or off-brand in Google Sheets?▼

The classification process uses brand-first precedence and fuzzy matching rules to prioritize brand matches before tagging terms as off-brand. This mechanism reduces false positives and ensures safer PPC analytics.

Can I use GPT-4o for PPC query classification and flag off-brand terms?▼

Yes, you can use GPT-4o to analyze and flag off-brand search queries. The tool integrates with Google Sheets to batch process queries, applying explicit brand matching precedence to minimize misclassifications and API overuse.

Does this query classification tool require a Google Sheets setup with specific tabs?▼

Yes, the workflow requires a Google Sheets environment configured with a 'Have Cost' tab to read input queries and a 'Have Cost Result' tab to write the classified outputs. It uses google-api-python-client for safe write operations.

What is the best way to automate off-brand keyword checks for PPC analytics?▼

The best way is to run an automated analyzer that applies a robust off-brand keyword reference combined with explicit brand matching precedence. This catches misclassifications early and speeds up weekly PPC reporting and optimization.

How do I prevent false positives when flagging off-brand search queries?▼

To prevent false positives, the analyzer implements brand-first classification logic. It prioritizes explicit and fuzzy brand matches before checking against off-brand keywords, ensuring branded terms are not mistakenly flagged.

Are there limitations to using AI-powered query classification for large Google Sheets datasets?▼

A known limitation is API overuse. To mitigate this, the tool implements safe-guarded write operations and optional QA gating, ensuring controlled batch processing of queries from your Google Sheets without exceeding API limits.