prompts

Keyword Spends Change

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.

Table of contents
Prompt

Prompt

Copy

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:

  1. IMMEDIATE: Pause bottom 0 performers or reduce bids by 50% - recovers $0.00 budget
  2. Audit "brand co pricing" landing page and ad creative - conversion rate dropped 46% month-over-month
  3. Review Quality Score for all keywords with CPC increases >40% - indicates relevance issues
  4. Implement automated rules to pause keywords with <1% conversion rate after 100 clicks
  5. Redirect bottom performer budget to top 20 converting keywords (30+ conversions/month)
  6. Run A/B test on brand keyword landing pages - current pages underperforming by 46%
  7. Analyze search term reports for waste - high impression keywords may be matching irrelevant queries
  8. 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

‍

View PDF
Watch Tutorial