cotera

Google Ads Weekly Performance Report

Get a full performance breakdown of your Google Ads campaigns delivered to Slack every week. No more pulling reports manually.

Weekly reportingCampaign analyticsKeyword insightsAutomated reports

The Challenge

Every week, someone on the marketing team spends 2-4 hours pulling data from Google Ads, formatting it into a report, calculating week-over-week changes, and posting it to Slack. It is the same workflow every single time, and it takes half a morning that could be spent on actual optimization.

What This Prompt Does

Campaign Metrics

Pulls spend, conversions, CPA, and CTR for all active campaigns

Keyword Analysis

Uses GAQL to find top converting and wasted-spend keywords

Trend Detection

Highlights campaigns with big week-over-week changes

Slack Report

Posts a formatted report with highlights and action items

The Prompt

The Prompt

Task

Generate a weekly performance report for a Google Ads account. Use @Google Ads/List CampaignsName it "Google Ads/List Campaigns" and call it with @Google Ads/List Campaigns to pull campaign-level metrics for the last 7 days. Use @Google Ads/Search with GAQLName it "Google Ads/Search with GAQL" and call it with @Google Ads/Search with GAQL to get ad group and keyword breakdowns for top campaigns. Compile the report and share it via @Slack/Send MessageName it "Slack/Send Message" and call it with @Slack/Send Message, and optionally log key metrics to @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row.

Input

The user provides their Google Ads customer ID and the Slack channel to post the report to.

Example: "Generate a weekly Google Ads report for account 123-456-7890 and post it to #marketing-reports"

Context

Report Sections

Executive summary:

  • Total spend, impressions, clicks, conversions for the week
  • Week-over-week changes (compare LAST_7_DAYS vs previous period)
  • Overall CPA, ROAS, and CTR

Campaign performance:

  • All active campaigns ranked by spend
  • For each: spend, conversions, CPA, CTR, impression share
  • Flag campaigns with significant week-over-week changes

Top and bottom performers:

  • Top 3 campaigns by conversion volume
  • Bottom 3 campaigns by CPA (worst efficiency)
  • Any campaigns with zero conversions but spend over $50

Keyword insights (via GAQL):

  • Top 10 converting keywords
  • Top 10 keywords by spend with no conversions (waste)
  • Any new keywords driving significant traffic

GAQL Queries to Run

For keyword data: "SELECT ad_group_criterion.keyword.text, metrics.impressions, metrics.clicks, metrics.conversions, metrics.cost_micros FROM keyword_view WHERE segments.date DURING LAST_7_DAYS ORDER BY metrics.cost_micros DESC LIMIT 20"

Output

Weekly Report formatted for Slack:

  • High-level numbers with week-over-week deltas
  • Campaign performance breakdown
  • Top/bottom performers callout
  • Keyword insights
  • 2-3 actionable recommendations

Sheet Row (optional): Date, total spend, conversions, CPA, CTR appended to tracking sheet

Example Usage

Try asking:

  • →"Generate my weekly Google Ads report and send it to #paid-media"
  • →"How did our Google Ads campaigns perform last week compared to the week before?"
  • →"What are our top converting keywords from the last 7 days?"