skills.rest
fourteenwm
fourteenwmCOMMUNITY
Explore all skills by this author →
Website𝕏@KurtHenningerGitHub

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
One-click install
npx skills add https://github.com/fourteenwm/ppc-ai-skills --skill offbrand-analyzer
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Marketing & Sales Skills→
mishahaninmishahanin
10

google-contacts

Manage Google Contacts records via the People API.

Community
Intermediate
fourteenwmfourteenwm
58

sqr-classifier

Classify search terms into four intent categories from pasted lists or CSV exports.

Community
Intermediate
zapierzapier
114

google-sheets

Automate read, write, and manage operations in Google Sheets via API v4.

Official
Intermediate
portermetricsampleportermetricsample
17

search-term-branded

Classify Google Ads search terms into brand, competitor, and generic categories.

Community
Intermediate