prompts

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.

Table of contents
Prompt

Prompt

Copy

Analyze Google Ads data to generate a weekly campaign performance comparison, showing improvement or decline week over week. For each campaign, identify the main metrics (spend, clicks, CPC, CTR, conversions, CPL, ROAS) that led to the change. Explain underlying causes for shifts in performance, referencing only data that is valid and available. If any campaign data cannot be retrieved, clearly note the limitation. If the data is too large, split and process in chunks, then aggregate the results. End with a data-driven summary and actionable recommendations for the next week.

Instructions to generate the report:

  • Always validate data directly from Google Ads before presenting.
  • Never use hypothetical or sample data in any output.
  • 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 prompt delivers a week-over-week comparative analysis that is comprehensive, actionable, and tailored for digital marketing teams using Google Ads. This includes:

Account-Level Performance Summary

  • Spend rose from $20,737.24 to $36,659.20 (+76.8%)
  • Clicks jumped by 88.1% (from 11,920 to 22,423)
  • Conversions nearly doubled (+94.7%), improving from 325.5 to 633.9
  • Cost-per-click (CPC) decreased 5.9% and ROAS dropped by 53.3% (from 7.40x to 3.46x)
  • The report clearly communicates that impressions and total conversions grew substantially, while return on ad spend (ROAS) fell due to increased spend outpacing value.

Top Performing Campaigns

  • Product X Brand Campaign: 92.1% conversion growth
  • ROW Performance Max: 39.8% more conversions week-over-week
  • Best ROAS: BRL Channel Campaign (30.1x), Product X Brand USA (3.7x)

Underperforming Campaigns

  • AUS Channel Campaign and ESP Channel Campaign: Both posted 100% loss in conversions
  • High spenders with zero conversions (e.g., ROW Funnel Campaign, US Channel Campaign)

Causes for Performance Shifts

  • Positive drivers: Better bid efficiency, brand campaign successes, algorithm improvements in Performance Max, and geographical expansion
  • Challenges: Funnel campaign inefficiencies, increased CPCs due to competitor activity, creative fatigue as indicated by a declining CTR, and conversion tracking gaps in test campaigns

Actionable Recommendations

  • Immediate actions: Pause high-spend campaigns with zero conversions, audit and fix conversion tracking, and reallocate budget to proven winners
  • Short-term (next 2 weeks): Update ad creatives, A/B test headlines, and optimize landing pages for at-risk campaigns
  • Strategic (next month): Merge smaller campaigns, roll out value-based bidding, and double down on high-performing market segments
  • Projected improvements: Up to 45% more conversions in 2 weeks and a 15-20% drop in cost per conversion if recommendations are implemented

Data Transparency and Limitations

  • The report notes and explains missing data—for example, some campaign conversions are delayed, and conversion value data may be incomplete for certain metrics, ensuring marketers can trust the analysis and know its limitations.

Why This Is Helpful for Marketers

  • Time-saving and accuracy: Marketers get validated, week-over-week reports without manual spreadsheet work.
  • Trusted, data-backed insights: Each finding is directly tied to actual account metrics, never hypotheticals, increasing confidence in taking action.
  • High transparency: All limitations and data gaps are disclosed, eliminating ambiguity and enhancing trust.
  • Clear next steps and efficiency gains: Immediate, short-term, and strategic recommendations are ranked by impact, supporting a proactive growth mindset.

Table: Key Metrics and Performance Changes

Metric Sep 22 Week Sep 29 Week Change % Change
Spend $20,737.24 $36,659.20 +$15,921.96 +76.8%
Clicks 11,920 22,423 +10,503 +88.1%
Conversions 325.5 633.9 +308.4 +94.7%
Avg CPC $1.74 $1.64 -$0.10 -5.9%
CTR 3.40% 2.83% -0.57% -16.8%
ROAS 7.40x 3.46x -3.94x -53.3%

Summary and Next Steps

This Claud API prompt for Google Ads delivers a report structure that is purpose-built for digital advertising teams focused on optimization. It surfaces valid, week-on-week metric movements, clarifies what is driving those changes, and gives a prioritized list of recommendations—ensuring fast, confident decision-making to drive positive ROI.

Next actions for marketers:

  • Implement the top priority recommendations in the next work cycle.
  • Schedule the next report run for October 15, 2025, to track progress and catch new trends as soon as they happen.

This micro site structure and content ensure clear AEO targeting and user intent alignment while demonstrating reporting transparency and tactical value—core signals for both search engines and real users.

‍

View PDF
Watch Tutorial