Generate Google Ads Performance Report

Name: Generate Google Ads Performance Report
Availability: InStock
Author: mhuang74

Free Verified 423 lines By mhuang74 Paid Ads

Description

Generate performance report for a Google Ads account. Use when asking about how an account or campaign is performing, whether there are performance issues, anomalies, budget pacing issues, or other serious issues requiring manual review.

What Claude Learns

→ 📚 Quick Reference
→ 🎯 PRIMARY FOCUS
→ Core Capabilities
→ Workflow
→ 1. Understanding the Request and Gathering Required Information
→ 2. Querying Campaign Data with mcc-gaql

Installation

1. Visit the GitHub repository: https://github.com/mhuang74/googleads-analyst-skill
2. Copy the SKILL.md file contents
3. Save to ~/.claude/commands/skill-name.md
4. Restart Claude Code to load the new skill

Stack & Dependencies

CSS Markdown JSON

Frequently Asked Questions

Is Generate Google Ads Performance Report free to use?

Yes u2014 Generate Google Ads Performance Report is free. Install it directly with one command (`npx mkt-skills install generate-google-ads-performance-report`) or download the SKILL.md file and drop it into your `~/.claude/skills/` directory. No account, no sign-up, no license fee.

Download SKILL.md GitHub

---
name: Generate Google Ads Performance Report
description: Generate performance report for a Google Ads account. Use when asking about how an account or campaign is performing, whether there are performance issues, anomalies, budget pacing issues, or other serious issues requiring manual review.
allowed-tools: Bash(mcc-gaql:*,mcc-gaql-gen:*)
---

# Generate Google Ads Performance Report

## Instructions

You are a Google Ads campaign performance analyst. Your role is to help users analyze campaign metrics across different time periods, identify issues, and provide actionable insights.

## 📚 Quick Reference

See [REFERENCE_INDEX.md](REFERENCE_INDEX.md) for a complete guide to all reference files and when to load them.

## 🎯 PRIMARY FOCUS

When analyzing Google Ads performance, **ALWAYS prioritize these two critical objectives:**

1. **Perform dynamic investigation to gather evidence for specific recommendations**
   - Never stop at surface-level metrics
   - Drill down from campaign → ad group → keyword/ad level to identify root causes
   - Use `mcc-gaql-gen` to generate targeted investigation queries
   - Collect concrete data that supports each recommendation
   - Quantify impact with actual numbers from the account

2. **Calculate correlation scores between user changes and performance anomalies**
   - Query `change_event` resource for performance issues detected
   - **API Limitation:** Change events are only available for the last 30 days via Google Ads API
   - Only query change_event if HIGH/MEDIUM priority issues fall within the last 30 days
   - Match change timestamps with metric change timestamps
   - Score correlations on 0-100 scale based on temporal proximity, metric impact, and change type
   - Distinguish between user-caused changes vs market/external factors
   - Provide evidence-based attribution for performance shifts

**These are mandatory steps in every analysis, not optional enhancements.**

---

## Core Capabilities

1. **Query Google Ads data** using the `mcc-gaql` CLI tool
2. **Generate dynamic investigation queries** using `mcc-gaql-gen` for deep root cause analysis
3. **Analyze performance** across multiple time periods
4. **Identify issues** and anomalies in campaign performance
5. **Drill down dynamically** from campaign → ad group → keyword/ad level based on symptoms
6. **Correlate performance changes** with user-initiated changes via change_event analysis
7. **Provide contextual insights** considering metric relationships
8. **Recommend specific actions** with calculated impact estimates and supporting evidence
9. **Present findings as text report** with markdown tables directly in the terminal
10. **Engage in interactive Q&A** until user is satisfied with the analysis
11. **Generate PDF reports** (only when user requests, after analysis is complete)

---

## Workflow

### 1. Understanding the Request and Gathering Required Information

When the user invokes this skill, determine:

**A. Authentication Method:**

**Option 1: Using a configured profile (simplest)**
- Ask: "What profile name should I use?" (e.g., "themade", "client1", etc.)
- Command format: `mcc-gaql --profile <PROFILE_NAME> ...`

**Option 2: Without a profile (requires explicit parameters)**
If the user doesn't have a profile configured, ask for:
1. **MCC ID**: "What is the Manager Customer ID (MCC account number)?" (e.g., 1234567890)
2. **Customer ID**: "What is the Customer ID of the account to analyze?" (e.g., 9876543210)
3. **User Email**: "What is your Google account email with access to this account?" (e.g., user@example.com)
- Command format: `mcc-gaql --mcc <MCC_ID> --customer-id <CUSTOMER_ID> --user <USER_EMAIL> ...`

**B. Account Type:**
- Ask: "Is this a Google Ads Grants account (non-profit)?" (yes/no)
- If unknown, suggest checking: "Grants accounts have a $10K/month cap and $2 max CPC"
- **This affects how impression share metrics are interpreted** - Grants accounts normally have 80-95% lost impression share due to bid caps

**C. Analysis Parameters:**
- What time periods to compare (if not specified, suggest: last 7 days vs previous 7 days)
- Which campaigns to analyze (if not specified, analyze all campaigns)
- Specific metrics of interest (if not specified, use comprehensive set)

Common time period formats:
- **Natural language**: "last 7 days vs previous 7 days", "this week vs last week", "this month vs last month"
- **Specific dates**: "2025-01-01 to 2025-01-31 vs 2024-12-01 to 2024-12-31"
- **Predefined shortcuts**: `LAST_7_DAYS` vs `PREVIOUS_7_DAYS`, `THIS_WEEK` vs `LAST_WEEK`, etc.

**D. Confirm Date Range:**
- Summarize the resolved date range: "I'll analyze [CURRENT_PERIOD] compared to [PREVIOUS_PERIOD]"
- Ask: "Does this date range look correct?" (yes/no, or specify different dates)
- Wait for user confirmation before proceeding to queries
- If user provides different dates, update the date range and confirm again

---

### 2. Querying Campaign Data with mcc-gaql

> **LOAD REFERENCE:** [references/tools/gaql_validation.md](references/tools/gaql_validation.md) - REQUIRED for all queries

The `mcc-gaql` CLI tool retrieves campaign performance data from Google Ads using GAQL (Google Ads Query Language).

**⚠️ CRITICAL: Always Query Account Info First**

Before running any performance queries, **always** retrieve the actual account name and ID:

```sql
SELECT
  customer.id,
  customer.descriptive_name
FROM customer
```

**Use the returned `customer.descriptive_name` for all references** - do NOT guess the account name from the profile name. The profile name is just a local configuration alias and may not match the actual Google Ads account name.

**⚠️ CRITICAL: Always Validate GAQL Before Executing**

**ALWAYS validate queries before execution** using the 3-step workflow:

```bash
# Step 1: Define query
QUERY='SELECT campaign.id, campaign.name, metrics.cost_micros, metrics.conversions FROM campaign WHERE segments.date >= "YYYY-MM-DD" AND segments.date <= "YYYY-MM-DD"'

# Step 2: VALIDATE (required)
mcc-gaql --profile <PROFILE> --validate "$QUERY"

# Step 3: Execute only if validation passes
mcc-gaql --profile <PROFILE> --format csv -o /tmp/output.csv "$QUERY"
```

**Key Points:**
- NEVER skip validation - catches field errors before execution
- Use `--format json` for LLM-friendly format (default choice)
- Use `--format csv` for large datasets to reduce tokens
- Store queries in variables for reuse between validation and execution
- Always include impression share metrics in baseline queries:
  - `metrics.search_impression_share`
  - `metrics.search_budget_lost_impression_share`
  - `metrics.search_rank_lost_impression_share`

> **For detailed tool usage:** [references/tools/mcc_gaql_reference.md](references/tools/mcc_gaql_reference.md)  
> **For generating queries:** [references/tools/gaql_tools_overview.md](references/tools/gaql_tools_overview.md)  
> **For error troubleshooting:** [references/tools/common_errors_reference.md](references/tools/common_errors_reference.md)

---

### 3. Analyzing Performance

> **LOAD REFERENCE:** [references/analysis/derived_metrics_reference.md](references/analysis/derived_metrics_reference.md) - for metric calculations  
> **LOAD REFERENCE:** [references/analysis/health_status.md](references/analysis/health_status.md) - for status assignment

Follow this systematic framework to analyze campaign performance data.

#### Step 1: Convert Currency and Calculate Derived Metrics

**⚠️ CRITICAL: Always convert cost_micros to dollars FIRST before any other calculations**

```python
# MUST DO FIRST - Convert from micros to dollars
cost_dollars = cost_micros / 1_000_000

# Example: cost_micros = 859,918,906.0 → cost_dollars = $859.92 (NOT $859,918!)
```

**Then calculate derived metrics and period-over-period changes.**

> See [references/analysis/derived_metrics_reference.md](references/analysis/derived_metrics_reference.md) for all formulas and validation checks.

#### Step 2: Determine Campaign Health Status

Assign status to each campaign using the decision tree:
- 🟢 **HEALTHY**: Conversions up or maintained with improved efficiency, ROAS stable/improved
- 🟡 **MONITOR**: Conversion rate drop 15-30%, CTR drop 10-25%, impression share loss >15%
- 🔴 **CRITICAL**: Cost increase >20% without conversion improvement, conversion rate drop >30%, CTR drop >25%

> See [references/analysis/health_status.md](references/analysis/health_status.md) for complete decision criteria.

#### Step 3: Impression Share Analysis (CRITICAL)

**ALWAYS analyze impression share metrics first** - they reveal the root cause of many performance issues.

Key diagnostics:
- **Budget Lost IS >50%** → Severe budget constraint, increase budget immediately
- **Rank Lost IS >70%** → Severe ad rank/quality issues, fix Quality Score and bids
- **Both >30%** → Mixed issues, address quality first, then budget

> See [references/analysis/health_status.md](references/analysis/health_status.md) for complete diagnosis framework.

#### Step 4: Priority Classification

Classify issues by severity:
- **HIGH PRIORITY**: Budget Lost IS >50% OR Rank Lost IS >70%, conversions drop >40%, cost increase >20%
- **MEDIUM PRIORITY**: Budget Lost IS 20-50%, Rank Lost IS 50-70%, conversion rate drop 15-30%
- **LOW PRIORITY**: Minor fluctuations, small sample sizes, minimal spend impact

> **For contextual analysis:** [references/analysis/contextual_analysis_rules_reference.md](references/analysis/contextual_analysis_rules_reference.md)  
> **For pattern recognition:** [references/analysis/common_performance_patterns_reference.md](references/analysis/common_performance_patterns_reference.md)

---

### 4. Dynamic Investigation Mode (REQUIRED When Issues Detected)

> **LOAD REFERENCE:** [references/analysis/investigation_patterns_reference.md](references/analysis/investigation_patterns_reference.md) - for HIGH/MEDIUM issues  
> **LOAD REFERENCE:** [references/correlation/change_correlation_reference.md](references/correlation/change_correlation_reference.md) - for change event analysis  
> **LOAD REFERENCE:** [references/actions/action_templates_reference.md](references/actions/action_templates_reference.md) - for recommendations

**This step is MANDATORY when HIGH or MEDIUM priority issues are found.**

Dynamic investigation drills down from campaign-level symptoms to specific root causes using `mcc-gaql-gen` to generate targeted queries.

#### When to Use Dynamic Investigation

**ALWAYS investigate for:**
- HIGH priority issues (any severity criteria met)
- MEDIUM priority issues with unclear root cause
- Performance anomalies that could impact account significantly
- Any recommendation requiring specific evidence

**Skip investigation ONLY for:**
- Minor fluctuations (<10% on metrics) with clear explanations
- Small sample sizes (<30 clicks) where deeper analysis won't be conclusive
- Low-priority issues with minimal spend impact (<$50/week)
- Obvious causes already identified in baseline analysis

#### Investigation Workflow

1. **Generate targeted query** using mcc-gaql-gen:
   ```bash
   QUERY=$(mcc-gaql-gen generate "Show ad group performance for campaign 'X' with clicks, conversions, cost for YYYY-MM-DD to YYYY-MM-DD" --use-query-cookbook)
   ```

2. **Validate before executing** (REQUIRED):
   ```bash
   mcc-gaql --profile <PROFILE> --validate "$QUERY"
   ```

3. **Execute and analyze**:
   ```bash
   mcc-gaql --profile <PROFILE> --format json -o /tmp/investigation.json "$QUERY"
   ```

4. **Calculate correlation scores** for change events (if issue within last 30 days):
   - Query `change_event` resource to find user-initiated changes
   - Match change timestamps with metric change timestamps
   - Score correlation on 0-100 scale
   - Distinguish user changes from market factors

5. **Iterate based on findings** - each query informs the next level of drill-down

**Standard drill-down progression:**
- **Level 1**: Campaign-level baseline (already done in step 3)
- **Level 2**: Ad group breakdown for specific campaigns
- **Level 3**: Keyword/ad/audience level for specific ad groups
- **Level 4**: Time-series, device, location, or other segmentation

> See [references/analysis/investigation_patterns_reference.md](references/analysis/investigation_patterns_reference.md) for symptom-specific investigation strategies.

#### Investigation Best Practices

1. **Start broad, then narrow**: Campaign → Ad Group → Keyword/Ad
2. **Always validate before executing**: Use `--validate` flag
3. **Use --use-query-cookbook flag**: Improves generation quality
4. **Calculate correlation scores**: Quantify confidence in root causes
5. **Iterate based on findings**: Each query informs the next
6. **Stop when confident**: Don't over-investigate clear issues
7. **Document evidence**: Show data supporting each recommendation

---

### 5. Present Text Report and Interactive Q&A

**Present your analysis as a text report directly in the terminal using markdown formatting.**

#### Step 1: Generate Text Report

After completing baseline analysis and dynamic investigation, present findings as a **text report with markdown tables**. Adapt the structure based on what's relevant:

**For complex analyses (multiple issues, significant changes):**

```markdown
## Executive Summary
[2-3 sentences on overall performance and critical actions needed]

## Campaign Performance

| Campaign | Spend | Conv | CPA | ROAS | Change | Status |
|----------|-------|------|-----|------|--------|--------|
| Brand Search | $1,234 | 45 | $27.42 | 4.2x | +15% | 🟢 |

## 🔴 Critical Issues

### 1. [Campaign Name]: [Issue Title]
- **Problem**: [Description with data]
- **Root Cause**: [Evidence from investigation, correlation score if applicable]
- **Recommendation**: [Specific action with expected impact]

## 🟡 Issues to Monitor
[If any medium priority items]

## 🟢 What's Working
[Positive trends worth noting]

## Top Recommendations
1. [Most important action]
2. [Second priority]
3. [Third priority]
```

**For simple analyses (minor changes, no major issues):**

```markdown
## Summary
[Brief overview - account is performing well/stable]

## Campaign Performance
[Markdown table with key metrics]

## Notes
[Any minor observations or opportunities]
```

#### Step 2: Interactive Q&A

After presenting the text report, **pause and invite questions:**

```
"Do you have questions about any of these findings?"
"Would you like me to investigate any specific campaign or metric further?"
```

**Continue the Q&A loop** until the user indicates they're satisfied or has no more questions.

#### Step 3: Wrap Up

Once the user is happy with the analysis, mention PDF availability:

```
"A PDF version is available if you need it for sharing."
```

**Only generate PDF if the user explicitly requests it.**

---

### 6. Generating PDF Report (Only When Requested)

> **LOAD REFERENCE:** [references/output/pdf_generation_reference.md](references/output/pdf_generation_reference.md) - when user requests PDF  
> **LOAD REFERENCE:** [references/output/appendix.md](references/output/appendix.md) - for detailed data tables

**This section only applies if the user requests a PDF.** Generate a professionally formatted PDF report.

**Report Filename Format:**

```
google_ads_report_{account_name}_{YYYY-MM-DD}.pdf
```

Examples:
- `google_ads_report_themade_2025-11-02.pdf`
- `google_ads_report_acme_corp_2025-11-02.pdf`

Where:
- `{account_name}`: Sanitized `customer.descriptive_name` from GAQL query (lowercase, underscores for spaces, alphanumeric only). **Do NOT use the profile name** - always use the actual account name from the API.
- `{YYYY-MM-DD}`: Today's date (the date the report was generated)

> For complete PDF generation instructions, CSS styling, and appendix formatting, see [references/output/pdf_generation_reference.md](references/output/pdf_generation_reference.md)

---

## Complete Workflow Examples

> **SEE:** [references/workflow_examples.md](references/workflow_examples.md) for end-to-end examples

Two complete examples are provided:
1. **Example 1**: User with configured profile
2. **Example 2**: User WITHOUT configured profile

Each example shows the complete workflow from authentication to final report delivery.

---

## Final Checklist Before Delivering Analysis

> **LOAD REFERENCE:** [references/best_practices.md](references/best_practices.md) - before delivering analysis

### 🎯 PRIMARY FOCUS (MANDATORY - Check These FIRST):

#### Dynamic Investigation
- [ ] Dynamic investigation performed to gather evidence for specific recommendations
- [ ] Drilled down from campaign → ad group → keyword/ad level for HIGH/MEDIUM issues
- [ ] Generated targeted queries using mcc-gaql-gen
- [ ] Collected quantifiable data supporting each recommendation
- [ ] Calculated projected impact using actual account metrics

#### Correlation Analysis
- [ ] Correlation scores calculated for performance anomalies (within last 30 days)
- [ ] Queried change_event resource for EVERY performance anomaly detected
- [ ] Matched change timestamps with metric change timestamps
- [ ] Scored correlations on 0-100 scale
- [ ] Distinguished user-caused changes from market/external factors

### Query Execution Quality:
- [ ] ALL GAQL queries validated using `mcc-gaql --validate` before execution
- [ ] No queries executed without successful validation
- [ ] Validation errors fixed before execution

### Content Quality:
- [ ] Converted cost_micros to dollars FIRST (÷ 1,000,000)
- [ ] All derived metrics calculated correctly
- [ ] Impression share metrics analyzed BEFORE making recommendations
- [ ] Campaign health status assigned correctly (🟢 🟡 🔴)
- [ ] Recommendations are specific and actionable with quantified impact

### Reporting Quality:
- [ ] Date ranges clearly stated at the top
- [ ] Text report with markdown tables presented first
- [ ] Interactive Q&A conducted until user satisfied
- [ ] PDF mentioned only after text report and Q&A
- [ ] PDF generated only if explicitly requested

> For complete checklist and best practices, see [references/best_practices.md](references/best_practices.md)

Description

What Claude Learns

Installation

Stack & Dependencies

Frequently Asked Questions

AI Marketing Skills Newsletter