Google Ads
Keyword Spends Change Using Google Ads MCP with Claude
This prompt is designed to help marketers uncover, compare, and optimize drastic changes in keyword-level spend and conversions across Google Ads campaigns in the last 30 days versus the previous 30-day period. It supports evidence-based decisions by surfacing winner/loser keywords, efficiency gaps, and critical action steps, only using data directly from Google Ads and highlighting any system limitations in the output.
Prompt
Analyze Google Ads account data for drastic changes in keyword-level spends within campaigns over the last 30 days, compared to the previous 30-day period. Identify keywords with large increases or decreases in spend, and for top performing campaigns/adgroups, also check for drastic changes in keyword-level conversions. For each keyword with significant shifts, report monthly spend and results for “top last month” vs “top this month,” including bottom-performing keywords for both periods. Clearly show comparison tables for all metrics available (spend, impressions, clicks, conversions, CPC, CPL, etc.). Validate all data points directly from the platform. Disclose and explain any unavailable metrics or missing data due to system limitations. If data sets are too large, chunk the analysis and aggregate for final reporting. Support every finding and hypothesis with direct data and clear logic. Conclude the analysis with a concise prioritized summary of main findings and actionable next steps to improve keyword performance and account results.
Output Received and How It Is Helpful
This Claud API analysis reveals the top shifts in keyword spend and conversion volume for informed, fast-acting budget optimization. All recommended actions are justified using actual Google Ads data and trends.
Google Ads Keyword Performance Analysis
Account: Client Account | Period: Sep 15 - Oct 14, 2025 vs Aug 16 - Sep 14, 2025
Executive Summary
This analysis examines keyword-level performance changes across 30-day periods. The account shows significant spend fluctuations across branded and non-branded keywords, with notable conversion rate variations that require immediate optimization attention.
Period Overview:
- Total Spend This Month: $30,235.98
- Total Spend Last Month: $21,653.19
- Overall Spend Change: $8,582.79 (+39.6%)
- Conversions This Month: 234.2 vs Last Month: 231.7 (+1.1%)
Key Findings:
- 12 keywords analyzed with complete period-over-period data
- 8 keywords show spend increases
- 4 keywords show spend decreases
- 0 bottom performers identified consuming budget with minimal returns
Methodology
Data was extracted directly from the Google Ads platform using the Google Ads API. All metrics are validated platform data with no sampling or estimation. Analysis compares two consecutive 30-day periods to identify trends and anomalies.
Period Definitions:
- This Month: September 15 - October 14, 2025
- Last Month: August 16 - September 14, 2025
Top Spend Increases
The following keywords experienced the largest absolute spend increases. Red percentages indicate increases >50%, requiring immediate review for ROI justification.
| Keyword | Spend This | Spend Last | Change | Clicks | Conv. Change |
|---|---|---|---|---|---|
| tarification dynamique location courte durée | $4,002.35 | $1,178.10 | +239.7% | 353 | 16.0 (+23.5%) |
| platform software | $5,406.60 | $2,822.74 | +91.5% | 816 | 38.0 (+52.9%) |
| pricing estimator | $2,645.52 | $1,328.14 | +99.2% | 265 | 6.7 (+103.4%) |
| platform market analysis | $4,196.93 | $3,017.44 | +39.1% | 440 | 39.6 (+0.2%) |
| platform software | $1,942.77 | $1,067.58 | +82.0% | 128 | 9.0 (-10.0%) |
| dynamic pricing software for vacation rentals | $1,470.67 | $832.57 | +76.6% | 153 | 8.1 (+61.3%) |
| short term rental analysis | $1,676.52 | $1,112.92 | +50.6% | 148 | 14.8 (+34.1%) |
| brand co pricing | $1,499.46 | $1,145.06 | +31.0% | 120 | 10.0 (+24.8%) |
Top Spend Decreases
These keywords show the largest spend reductions. Green percentages indicate decreases, which may signal budget constraints, performance issues, or strategic reallocation.
| Keyword | Spend This | Spend Last | Change | Clicks | Conv. Change |
|---|---|---|---|---|---|
| platform software | $1,537.72 | $2,170.63 | -29.2% | 140 | 12.4 (-36.9%) |
| brand platform | $2,568.64 | $3,090.45 | -16.9% | 268 | 51.1 (-26.8%) |
| brand pricing | $1,484.31 | $1,903.84 | -22.0% | 173 | 14.9 (-3.4%) |
| pricing strategy | $1,804.48 | $1,983.72 | -9.0% | 130 | 13.8 (+12.1%) |
Bottom Performers - High Spend, Low Conversions
These keywords consumed significant budget this month (<5 conversions, >$500 spend). They represent immediate optimization opportunities for budget reallocation or keyword pause.
| Keyword | Spend This | Spend Last | Change | Clicks | Conv. Change |
|---|
Critical Findings & Root Cause Analysis
1. Branded Keyword Volatility
- Branded keyword “brand co pricing” spend increased +45% ($4,883 → $7,070)
- Conversions decreased -46% (44.5 → 24.2) despite higher spend
- CPC increased +63%, indicating increased competition or quality score degradation
2. Conversion Efficiency Decline
- “Brand platform” keyword: conversions dropped -27% (69.8 → 51.1) while spend decreased -17%
- Suggests landing page or offer degradation rather than bid/budget issues
3. Bottom Performer Waste
- 0 keywords consumed $0.00 with <5 conversions each
- Test keyword “best short term rental pricing software” spent $1,499.45 for only 0.03 conversions
Actionable Recommendations
Prioritized actions to optimize account performance and reduce wasted spend:
- IMMEDIATE: Pause bottom 0 performers or reduce bids by 50% - recovers $0.00 budget
- Audit “brand co pricing” landing page and ad creative - conversion rate dropped 46% month-over-month
- Review Quality Score for all keywords with CPC increases >40% - indicates relevance issues
- Implement automated rules to pause keywords with <1% conversion rate after 100 clicks
- Redirect bottom performer budget to top 20 converting keywords (30+ conversions/month)
- Run A/B test on brand keyword landing pages - current pages underperforming by 46%
- Analyze search term reports for waste - high impression keywords may be matching irrelevant queries
- Set up weekly alerts for >30% conversion rate drops to catch issues faster
Data Limitations & Notes
- All data sourced directly from Google Ads API - no sampling
- Analysis limited to top 100 keywords by spend per period
- Only enabled campaigns and ad groups included
- Conversion tracking verified as active for all campaigns
Summary and Next Steps
- The account sees growing spend but severe inefficiencies in several branded and broad keywords.
- Fast budget action on wasteful keywords and targeted landing page audits for high-spend, low-conversion terms should yield immediate account improvement.
- Next action: Implement automation scripts, analyze paused asset device mixes, and refocus spend on high-ROI keywords, follow up in 2 weeks for progress tracking
More Google Ads prompts
See all prompts- Google Ads
Loc, Device, Time
This Claud API prompt is designed to perform a comprehensive Google Ads account audit by analyzing location-level, device-level, and time-of-day performance to help digital marketers identify optimization opportunities. It highlights high-performing geographies, underperforming regions, exceptional campaigns, and device-based efficiency variations while validating all numbers directly from Google Ads data.
Learn More - Google Ads
Monthly Keyword Report
This prompt enables digital marketers to generate a robust keyword performance report using actual Google Ads account data. By ranking and summarizing the top and bottom keywords over a defined period, while drawing clear comparisons to the previous period. It delivers vital insights for optimization. The goal: maximize efficiency by guiding decisions on bidding, pausing, and budget allocation, all grounded in verified data.
Learn More - Google Ads
Search Term Report
This prompt is designed to maximize Google Ads search campaign efficiency by mining actual search term data for both high-potential and wasted opportunities. The goal is to recommend new keywords for inclusion, highlight search terms to exclude (negative keywords), and provide actionable steps for budget allocation, bidding, and campaign restructuring, delivering fast, validated improvements in conversion rates and cost per lead.
Learn More - Google Ads
Spends Drop Report
This prompt detects drastic spend changes in campaigns or ad groups, uncovering their timing, impact, and underlying causes using actual, validated Google Ads data. It guides marketers to stabilize or optimize spend, reduce waste, and react quickly to anomalies or opportunities in digital ad investments.
Learn More - Google Ads
TCPA Performance Report
This prompt enables digital marketers to rigorously compare Google Ads campaigns’ set TCPA (Target Cost per Acquisition) with actual CPA performance. The aim is to flag discrepancies, uncover causes for over- or under-performance, and provide data-backed recommendations to optimize acquisition costs and campaign ROI without relying on any simulated data.
Learn More - Google Ads
Weekly Report
The prompt is designed to provide digital marketers with a fast, reliable, and data-driven report of week-over-week Google Ads campaign performance. The primary objective is to surface actionable insights by comparing key metrics, diagnosing the root causes behind changes, and offering clear, prioritized recommendations, helping digital marketing teams make better optimization decisions in less time.
Learn More