Google Ads Report

Pulls campaign, keyword, and conversion data straight from the Google Ads API using GAQL queries. You get the standard reports: campaign performance with spend and ROAS, keyword-level metrics including quality scores, search terms to find negative keyword candidates, and conversion tracking. The setup requires OAuth plus a developer token from Google, and you'll need to remember that all cost values come back in micros so divide by a million. Useful if you're auditing accounts, building dashboards, or just need to pull ad performance without clicking through the Google Ads UI. The quality score breakdowns are handy for diagnosing why certain keywords are expensive.

skills.sh installs: 487
GitHub stars: 736
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add openclaudia/openclaudia-skills --skill google-ads-report --agent claude-code

Installs into .claude/skills of the current project.

Files

Google Ads Report

Pull campaign, keyword, and conversion data from the Google Ads API.

Prerequisites

Requires:

GOOGLE_CLIENT_ID and GOOGLE_CLIENT_SECRET (OAuth)
GOOGLE_ADS_DEVELOPER_TOKEN (apply at https://ads.google.com/home/tools/manager-accounts/)
GOOGLE_ADS_CUSTOMER_ID (the account ID, format: XXX-XXX-XXXX, passed without dashes)
GOOGLE_ADS_LOGIN_CUSTOMER_ID (if using a manager account, the manager account ID)

Set in .env, .env.local, or ~/.claude/.env.global.

Getting an Access Token

# Same OAuth flow as other Google APIs
# Scope needed: https://www.googleapis.com/auth/adwords

echo "https://accounts.google.com/o/oauth2/v2/auth?client_id=${GOOGLE_CLIENT_ID}&redirect_uri=urn:ietf:wg:oauth:2.0:oob&scope=https://www.googleapis.com/auth/adwords&response_type=code&access_type=offline"

# Exchange code for tokens
curl -s -X POST "https://oauth2.googleapis.com/token" \
  -d "code={AUTH_CODE}" \
  -d "client_id=${GOOGLE_CLIENT_ID}" \
  -d "client_secret=${GOOGLE_CLIENT_SECRET}" \
  -d "redirect_uri=urn:ietf:wg:oauth:2.0:oob" \
  -d "grant_type=authorization_code"