Google Ads Search Term Analyzer

Name: Google Ads Search Term Analyzer
Price: 5 USD
Availability: InStock
Author: Agensi

by Edison Gold

Automates Google Ads search term analysis, keyword classification, and multi-tab Excel reporting.

30-day refund guarantee

Secure checkout via Stripe

0 installsSecurity scanned

See it in action

You say

Analyze this search_terms.csv file. My target CPA is $40. Give me an Excel report with negative keyword suggestions and scaling opportunities.

Your agent does

Analysis complete. I found 12 terms to pause saving $450/mo, 5 scale candidates, and 18 negative keywords. I've mapped the scale terms to your 'Brand_Search' campaign. [Download ads_audit.xlsx]

What you get

Identify wasted spend by surfacing negative keyword candidates automatically.Group high-converting search terms into new campaign and ad group structures.Generate formatted, client-ready Excel reports for Google Ads audits.Calculate dynamic CPA and ROAS thresholds to find outliers in search data.

About this skill

The problem

Manual analysis of Google Ads search term reports is a tedious, error-prone process. Advertisers often struggle to identify wasted spend at scale or recognize new high-intent keyword opportunities buried in thousands of rows of CSV data.

What it does

Statistically classifies search terms into scale, pause, or negative keyword buckets based on account-wide performance baselines.
Maps high-performing terms to existing campaign and ad group structures or proposes new thematic structures for outliers.
Calculates dynamic efficiency thresholds (CPA/ROAS) and allows for developer or user overrides.
Generates a multi-tab, color-coded Excel workbook with filtered views, formatted metrics, and ready-to-copy negative keyword lists.

Frameworks & tools

Google Ads API, Python (Pandas/XLSXWriter), Excel (Formula recalc scripts).

Why this beats prompting it yourself

Generic prompts often hallucinate campaign structures or fail to maintain consistent classification logic across large datasets. This skill enforces rigorous statistical thresholds, handles complex Excel formatting and multi-tab exports, and ensures terms are categorized with specific rationale rather than vague guesses.

Use cases

Identify and export negative keyword lists to immediately stop wasted spend.
Perform an automated audit of a new client's Google Ads search history.
Scale search campaigns by surfacing hidden winning queries for exact match expansion.
Restructure messy accounts by grouping terms into tightly-themed ad group proposals.

Known limitations

Requires an export of search term data or a connected Google Ads MCP tool. Low-volume terms with fewer than 10-15 clicks are flagged as having insufficient data for confident recommendations.