google-ads-query

Query Google Ads data via GAQL templates and export results to CSV.

58|9|Updated Apr 7, 2026

Search Tags:#automation #csv #data-extraction #google-ads #gaql #account-resolution

Ready to run

npx skills add https://github.com/fourteenwm/ppc-ai-skills --skill google-ads-query

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: google-ads-query
Source: https://github.com/fourteenwm/ppc-ai-skills/tree/main/google-ads-query
Command: npx skills add https://github.com/fourteenwm/ppc-ai-skills --skill google-ads-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-ads, proto, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Querying Google Ads data and exporting results to CSV is automated via GAQL templates, reducing manual scripting and data wrangling.

Core Features & Use Cases

Natural-language command parsing for common requests like "Get campaigns for account" and automatic CSV export.
8 GAQL templates (search-terms, campaigns, keywords, ad-groups, conversions, budgets, assets, geo) to cover major reporting needs.
CSV-first pattern: data is saved to CSV and only the file path and row count are returned to keep context concise.
Profile-locked workflow with account resolution from credentials to ensure safe access and auditable data handling.

Quick Start

Run the script with a profile, account, and resource to export the latest data to a CSV file.

Frequently Asked Questions about google-ads-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I export Google Ads data to CSV automatically?▼

Export Google Ads data to CSV by running GAQL query templates that fetch resources like campaigns or keywords and write the structured results directly to a file. This automation enforces profile-locked account resolution and returns only the file path and row count.

What GAQL templates are available for Google Ads reporting?▼

Available GAQL templates cover search-terms, campaigns, keywords, ad-groups, conversions, budgets, assets, and geo reporting. These templates automate querying Google Ads data and exporting results to CSV files.

How do I resolve account IDs from Google Ads credentials for reporting?▼

Account resolution happens automatically by enforcing a profile-locked workflow that extracts accessible accounts directly from your credentials. This ensures safe access and auditable data handling before executing GAQL queries.

Why does my Google Ads query return only a file path instead of data?▼

A CSV-first output pattern returns only the file path and row count to minimize context usage. By saving query results to CSV files, the process keeps context concise and enables downstream analysis without flooding the environment with raw data.

Can I query Google Ads data using natural language commands?▼

Natural-language command parsing supports common requests like getting campaigns for an account and automatically exports the queried Google Ads data to a CSV file. This simplifies generating reports without writing raw GAQL.

Do I need specific Python packages to run Google Ads queries?▼

You need the google-ads and proto Python packages installed to execute GAQL templates and handle data structures. These dependencies facilitate profile-locked account resolution, querying, and CSV export.