Google Ads Weekly Performance Report

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