google-ads-report

google-ads-report

Paid Media
Open Claudia
Pulls campaign, keyword and conversion data straight from the Google Ads API, so a spend question gets answered in the terminal instead of in a report builder.
REPO
OpenClaudia/openclaudia-skills
INSTALL
npx openclaudia
NEEDS
Ads developer token
Last updated
August 4, 2026

Preview

google-ads-report

What it is.

It authenticates against the Google Ads API and queries campaign, keyword, quality score and conversion data, so a spend question gets answered from the account instead of a pasted screenshot.

Setup is the whole job: an OAuth client, a developer token you apply for through a manager account, the customer ID without dashes, and the login customer ID when a manager account sits in the chain.

Once the credentials are in a dotenv file the questions get cheap. Wasted spend by match type, quality score by keyword, conversion counts by campaign, all in one sentence each.

What you get.

  • Campaign, keyword and conversion data queried live from the account
  • Quality score and cost per click reporting without opening the interface
  • An OAuth flow documented step by step, including the adwords scope
  • Credentials read from .env, .env.local or ~/.claude/.env.global
  • Output you can pass into another skill, because it arrives as data
HOW TO USE IT

How to set it up.

1

Install with npx openclaudia install google-ads-report.

2

Apply for a developer token through a Google Ads manager account. This is the step with a waiting period, so start it first.

3

Create an OAuth client and set GOOGLE_CLIENT_ID and GOOGLE_CLIENT_SECRET.

4

Set GOOGLE_ADS_CUSTOMER_ID without dashes. The account ID is displayed as XXX-XXX-XXXX and the API wants the digits only.

5

Add GOOGLE_ADS_LOGIN_CUSTOMER_ID when you access the account through a manager account, or the calls come back empty.

6

Run the OAuth exchange once with the adwords scope and store the refresh token alongside the rest.

Pricing Plans

Free. MIT license.

The Google Ads API is free to query at normal volumes. Checked against the skill file in July 2026.

Use cases

A spend question, answered live

Someone asks what a campaign spent last month and you don't want to open a report builder. Ask in plain language with a date range and the answer comes straight off the account.

Quality score without the interface

You want quality score by keyword across the account. One query returns it alongside cost per click and conversions, with no export step in the way.

Data for other skills

Iterate mode in ad-creative and a waste audit both want performance data. The output arrives as data, so no screenshot to retype, so it passes straight into the next skill.

Best for

Answering a spend question fast

The account is the source, so there is no export step and no stale screenshot in the conversation.

Wasted spend audits

Keyword-level cost and conversion data in the same query is what a negative keyword decision needs.

Feeding ad-creative with performance data

Iterate mode in ad-creative wants CSV or pasted performance data, and this is where it comes from.

Read the source

Published by Open Claudia. Opens in a new tab.
Open the Tool

Questions about google-ads-report

What is the hardest part of setup?
Where do credentials go?
Can it change campaigns?
Do I need a manager account?

Questions about Paid Media

What belongs in a paid report?
Why do platform numbers disagree with analytics?
Strengths
  • Queries the API and not scraping an interface, so the numbers match the account.
  • Documents the whole OAuth path, including the scope, which is where most API skills go quiet.
  • Reads credentials from a global dotenv, so one setup serves every Google skill in the library.
  • MIT licensed and runs on your machine, so account data stays with you.
Limitations
  • The developer token application is a genuine gate, and approval takes time.
  • A manager account needs the login customer ID as well, and leaving it out returns nothing instead of an error you can read.
  • Last touched in February 2026, older than most of this library.
  • It reports. Changing bids or budgets is outside what it does.
Skip this if
  • Skip it if your ads reporting already arrives without you asking.

The team behind these plays.

We build inbound GTM engines for B2B software teams, and these are the plays we build from. Tell us the pipeline target and we'll show the plan under it.