# 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.

Source: https://cotera.co/solutions/marketing/google-ads-performance-report

---

- **Team:** Marketing
- **Tools:** Google Ads, Slack, Google Sheets
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 3-4 hrs/week

## How it works
1. **Campaign Metrics** — Pulls spend, conversions, CPA, and CTR for all active campaigns
2. **Keyword Analysis** — Uses GAQL to find top converting and wasted-spend keywords
3. **Trend Detection** — Highlights campaigns with big week-over-week changes
4. **Slack Report** — Posts a formatted report with highlights and action items

## Example requests
- 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?

## Prompt

```markdown
## Task

Generate a weekly performance report for a Google Ads account. Use @Google Ads/List Campaigns to pull campaign-level metrics for the last 7 days. Use @Google Ads/Search with GAQL to get ad group and keyword breakdowns for top campaigns. Compile the report and share it via @Slack/Send Message, and optionally log key metrics to @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
```

## Related reading
- [We Killed Our Friday Reporting Ritual. An AI Agent Replaced It.](https://cotera.co/articles/automated-google-ads-reporting-guide.md)
- [The Best AI Tools for Google Ads in 2026 (Tested by a Media Buyer)](https://cotera.co/articles/best-ai-tools-google-ads.md)