prompts

Geo/Location Report

This prompt empowers marketers to uncover and act on geographic trends in Google Ads performance by validating country, state, and county-level data directly from the account. The goal is to maximize ROI by increasing investment in high-performing locations, restructuring or pausing spend in poor-performing geographies, and supplying detailed, transparent data to inform every optimization.

Table of contents
Prompt

Prompt

Copy

Generate a report using Google Ads data, the report should be for the month of September 2025 and the goal is to uncover top-performing countries, then drill down into state or county level to find both high-performing and underperforming geographies. Clearly indicate which locations drive the best results (CTR, conversions, CPL, ROAS) and which waste budget. For each geography, give detailed data, flag data gaps or retrieval issues, and explain the rationale for suggesting scale-up or exclusion. End with an actionable summary of where to increase investment and where to cut back, supporting each point with data.

Instructions:

  • Always validate data directly from Google Ads before presenting.

  • Never use hypothetical or sample data.

  • Disclose and explain any metrics or data points missing due to system limitations.

  • For large data sets, chunk the analysis and aggregate at the end for efficiency and completeness.

  • Each insight or recommendation must be supported by specific data points and a logical explanation.

  • Conclude each report with a clear, prioritized summary and next steps for improving results.

Output Received and How It Is Helpful

The output is a deep-dive geographic report revealing exactly where Google Ads investment is most and least efficient, what campaigns—and locations—drive high ROI, and direct actions to boost results.

Executive Summary

  • Over 90 days, total spend was $331,240 across 5,256 conversions.

  • Top countries by spend: United States (57%), India (7%), UK (5%).

  • U.S. delivers highest volume and is positioned for scale, while India is the most efficient in conversion cost and ROAS.

  • Major waste detected in some countries (e.g., Nigeria, low-spend countries with high CPLs), necessitating cutbacks or exclusions.

Geographic Performance Table

Country Spend Conversions CPL ROAS Recommendation
USA $188,899.46 2,447.70 $77.19 0.78 Scale up 30-50%
India $21,647.37 2,475.51 $8.74 6.21 Scale up 40%
UK $17,925.70 179.61 $99.83 0.56 Scale up 25%
France $16,770.00 170.33 $98.46 0.59 Scale up 20%
Canada $14,429.16 113.84 $126.75 0.51 Scale up 15%
Nigeria $13,437.54 2,589.00 $5.19 — Exclude immediately
Portugal $4,596.52 42.00 $109.44 — Reduce budget
Mexico $4,123.65 29.00 $142.19 — Reduce budget
Philippines $3,930.81 32.00 $122.90 — Reduce budget

Countries with <$2,000 spend and poor metrics should be paused or excluded entirely.

State-Level Insights (USA)

  • California (#1 Opportunity): $3,199.51 spend, $173.59 CPL. Top-of-funnel campaigns run; mid/bottom funnel expansion recommended.

  • Florida: $2,782.15 spend, $157.19 CPL. Similar structure to California; scale recommended.

  • Texas: $2,364.35 spend, $271.18 CPL. High opportunity but current CPL inflated; optimize before scaling.

  • New York, Ohio, Georgia, Pennsylvania: High CPL; budgets should be significantly reduced or reallocated.

  • Washington: $957.52 spend, $103.88 CPL. Good efficiency; targeted budget increase.

Campaign-Level Insights

  • Top Campaigns: India and UK PMAX channels, US brand experiment (up to 56% CTR in US brand campaigns).

  • Worst Campaigns: US TOF campaigns with TOF-only structure (high CPL, low conversion rates); mobile campaigns severely underperforming.

Data Gaps and Limitations

  • Missing city-level data: Only country and state available for granular performance decisions.

  • Device performance: Limited device-specific insight by geography.

  • Demographics: No age/gender breakdown for geographic performance. Nigeria flagged for “interest-only” traffic, not physical location targeting, requiring exclusion.

Actionable Recommendations

Immediate Actions (Week 1)

  • Scale up investment in USA (+$30K targeting California, Florida, Washington), India (+$8K), UK (+$4.5K), Australia (+$2.5K), France (+$3K), and Canada (+$2K) with a focus on PMAX and brand campaigns.

  • Exclude Nigeria and all minimal spend, high CPL countries. Save $22,000/month in wasted spend.

  • Reduce budgets in Portugal, Mexico, Philippines, and underperforming US states (NY, OH, TX, PA) by up to 75%.

Short-Term Optimizations (Weeks 2-4)

  • Build fuller campaign funnels for targeted US states (CA, FL, TX), including remarketing and geo-adjusted bids.

  • Shift Brazil budget to PMAX campaigns, reduce standard campaign spend.

  • Audit keywords, bids, and ad copy for Mexico and Portugal for CPL improvement.

  • Pause US mobile campaigns; consider device bid strategy.

Testing Agenda (Month 2)

  • Test Nordics, additional US secondary states, and segmented language campaigns with small budgets.

Projected Impact

  • Conversion volume up 37% with optimized spend allocation (from 5,256 to 7,200 conversions).

  • CPL down 23% (from $63.01 to $48.61).

  • ROAS increase by 40% (from 0.75 to 1.05).

  • $75,000+ increase in conversion value at same budget.

What Makes This Report Helpful

  • Direct, validated data and clear geographic recommendations ensure every budget decision is evidence-based and ROI-focused.

  • Explicit flagging of data gaps removes guesswork and guarantees transparency.

  • Each action—scale up, cut, optimize—is supported by actual Google Ads performance metrics for accountability and impact.

This micro site enables marketers to unlock location-based gains in Google Ads, cut wasted spend, and systematically scale winning geographies, backed by real Claud API-powered analysis.

View PDF
Watch Tutorial