skills.rest
fourteenwm
fourteenwmCOMMUNITY
Explore all skills by this author →
Website𝕏@KurtHenningerGitHub

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
One-click install
npx skills add https://github.com/fourteenwm/ppc-ai-skills --skill google-ads-query
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
jdrhynejdrhyne
239

google-ads

Query and manage Google Ads campaigns via the Python SDK or browser automation.

Community
Intermediate
CeeKay1901CeeKay1901

daten-aufbereiten

Clean CSV and spreadsheet files into analysis-ready tables with a change log.

Community
Intermediate
stratagastrataga

paid-ads

Plan, create, and optimize paid ad campaigns across Google Ads, Meta, LinkedIn, and Twitter/X.

Community
Advanced
zapierzapier
114

google-ads

Automate Google Ads campaign management using the Google Ads API v23.

Official
Advanced