Google ads cli
Skill almoretti/martech-ai-skills-and-tools/CLI/google-ads-cli/skills/google-ads-cli
Martech AI Skills and Tools — Claude skills & read-only CLIs for the marketing-technology stack (martech teardown, Google Ads, Microsoft Ads, Google Merchant Center).
npx -y skills add almoretti/martech-ai-skills-and-tools --skill google-ads-cliAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
3 things to look at
- 19 days oldThe repository was created 19 days ago. New is not bad, but a brand new repository carrying a familiar-sounding name is the shape a typosquat arrives in, and there has been no time for anyone else to find a problem with it.
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Google Ads data analysis and reporting via google-ads-cli. Use when the user wants to check Google Ads performance, pull campaign/ad group/keyword stats, explore account structure, audit conversions, or run custom GAQL queries. Triggers: "Google Ads", "ad performance", "campaign stats", "GAQL", "ad spend", "keyword report", "search terms", "conversion tracking", "impression share", "ad account".
SKILL.md
15.7 KB, as published. Nobody here has run it
Google Ads CLI Skill
You have access to google-ads-cli, a read-only CLI for the Google Ads API (v23). Use it to query ad accounts, pull performance stats, and run custom GAQL queries.
Quick start
# Check if the CLI is available
google-ads-cli --help
# List accessible accounts
google-ads-cli customers
If the CLI is not installed, install it:
npm install -g google-ads-cli
Authentication
The CLI uses OAuth2 user credentials (Google Ads API does not support service accounts). Credentials are stored in ~/.config/google-ads-cli/credentials.json.
Before running any command, verify credentials are configured by running google-ads-cli customers. If it fails with a credentials error, ask the user to set up authentication:
google-ads-cli auth login \
--developer-token=xxx \
--client-id=xxx \
--client-secret=xxx
How to get the values:
- developer_token: Sign in to a Google Ads manager account and open the API Center. Copy the developer token.
- client_id & client_secret: Go to Google Cloud Console > Credentials, create an OAuth client ID (Desktop app type). Make sure the Google Ads API is enabled.
This opens a browser for authorization. Make sure the user signs in with a Google account that has access to the Google Ads data they want to use. After approval, credentials are saved automatically. All subsequent commands work with auto-refreshing tokens.
For MCC (manager) accounts, add "login_customer_id": "1234567890" to the credentials file.
Alternative: set GOOGLE_ADS_ACCESS_TOKEN and GOOGLE_ADS_DEVELOPER_TOKEN environment variables (useful for CI/CD).
Entity hierarchy
Manager Account (MCC)
└── Customer Account (10-digit ID, e.g. 1234567890)
├── Campaign
│ └── Ad Group
│ ├── Ad (Ad Group Ad)
│ └── Keyword (Ad Group Criterion)
├── Campaign Budget
├── Conversion Action
├── User List (remarketing)
└── Asset (images, videos, sitelinks)
Customer IDs are 10-digit numbers. Dashes are stripped automatically.
Monetary values
Google Ads uses micros: 1 currency unit = 1,000,000 micros. All cost/bid/budget values returned by the CLI are in micros. Always divide by 1,000,000 when presenting monetary values to the user.
Output format
All commands output pretty-printed JSON by default. Use --format compact for single-line JSON (useful for piping).
Built-in commands
Account discovery
# List all accessible accounts
google-ads-cli customers
# Get details for a specific account
google-ads-cli customer 1234567890
# List sub-accounts under an MCC
google-ads-cli account-hierarchy 1234567890
Browsing entities
# Campaigns (filter by status: ENABLED, PAUSED, REMOVED)
google-ads-cli campaigns 1234567890
google-ads-cli campaigns 1234567890 --status ENABLED
# Get a specific campaign
google-ads-cli campaign 1234567890 98765
# Campaign budgets
google-ads-cli campaign-budgets 1234567890
# Ad groups (filter by campaign, status)
google-ads-cli ad-groups 1234567890 --campaign 98765
# Get a specific ad group
google-ads-cli ad-group 1234567890 11111
# Ads (filter by campaign, ad group, status)
google-ads-cli ads 1234567890 --campaign 98765 --ad-group 11111
# Get a specific ad (requires ad-group-id and ad-id)
google-ads-cli ad 1234567890 11111 22222
# Keywords
google-ads-cli keywords 1234567890 --campaign 98765 --status ENABLED
All listing commands support --limit <n> (default 100).
Performance stats
Stats commands require --start and --end dates (YYYY-MM-DD):
# Campaign stats
google-ads-cli campaign-stats 1234567890 --start 2026-01-01 --end 2026-01-31
# Campaign stats with device segment
google-ads-cli campaign-stats 1234567890 --start 2026-01-01 --end 2026-01-31 --segments device
# Ad group stats (filter by --campaign and/or --ad-group)
google-ads-cli ad-group-stats 1234567890 --start 2026-01-01 --end 2026-01-31 --campaign 98765
# Ad-level stats (filter by --campaign and/or --ad-group)
google-ads-cli ad-stats 1234567890 --start 2026-01-01 --end 2026-01-31
# Keyword stats (sorted by impressions desc; filter by --campaign and/or --ad-group)
google-ads-cli keyword-stats 1234567890 --start 2026-01-01 --end 2026-01-31
Available segments for campaign-stats --segments: device, ad_network_type, day_of_week (comma-separated).
Stats commands default to --limit 1000.
Other commands
# Audiences and remarketing lists
google-ads-cli audiences 1234567890
google-ads-cli user-lists 1234567890
# Assets and extensions
google-ads-cli assets 1234567890 --type SITELINK
google-ads-cli extensions 1234567890 --campaign 98765
# Conversions and billing
google-ads-cli conversion-actions 1234567890
google-ads-cli billing 1234567890
# Change history
google-ads-cli change-status 1234567890 --limit 20
# Negative keyword lists
google-ads-cli negative-keywords 1234567890
Asset types: IMAGE, MEDIA_BUNDLE, TEXT, YOUTUBE_VIDEO, LEAD_FORM, CALL, CALLOUT, SITELINK, STRUCTURED_SNIPPET.
Custom GAQL queries
The query command is the escape hatch for anything not covered by built-in commands. It runs arbitrary GAQL (Google Ads Query Language) against the Google Ads API.
google-ads-cli query <customer-id> "<GAQL>"
GAQL syntax
SELECT field1, field2, ...
FROM resource_name
WHERE conditions
ORDER BY field [ASC|DESC]
LIMIT count
PARAMETERS key=value
SELECTandFROMare required.WHERE,ORDER BY,LIMIT,PARAMETERSare optional.- Keywords (
SELECT,FROM,WHERE, etc.) are case-insensitive. - Field names, resource names, and enum values are case-sensitive.
- No
ORoperator -- all WHERE conditions areAND-ed together. - No
JOIN,GROUP BY,HAVING, or subqueries.
WHERE operators
| Operator | Example |
|---|---|
=, !=, >, <, >=, <= | campaign.status = 'ENABLED' |
IN, NOT IN | campaign.status IN ('ENABLED', 'PAUSED') |
LIKE, NOT LIKE | campaign.name LIKE '%brand%' (case-insensitive) |
REGEXP_MATCH | campaign.name REGEXP_MATCH '(?i)brand' |
BETWEEN ... AND ... | segments.date BETWEEN '2026-01-01' AND '2026-01-31' |
DURING | segments.date DURING LAST_30_DAYS |
IS NULL, IS NOT NULL | ad_group_ad.ad.final_urls IS NOT NULL |
CONTAINS ANY/ALL/NONE | For repeated fields |
Date filtering
Custom range:
WHERE segments.date BETWEEN '2026-01-01' AND '2026-01-31'
Predefined ranges (with DURING):
TODAY,YESTERDAYLAST_7_DAYS,LAST_14_DAYS,LAST_30_DAYS(NOT including today)THIS_MONTH,LAST_MONTHTHIS_WEEK_SUN_TODAY,THIS_WEEK_MON_TODAYLAST_WEEK_SUN_SAT,LAST_WEEK_MON_SUNLAST_BUSINESS_WEEK
Common resource names (FROM clause)
Entities: customer, campaign, campaign_budget, ad_group, ad_group_ad, ad_group_criterion, campaign_criterion
View resources (for metrics): keyword_view, search_term_view, geographic_view, gender_view, age_range_view, landing_page_view, ad_group_audience_view, shopping_performance_view, click_view
Other: change_status, change_event, conversion_action, asset, bidding_strategy, label, recommendation, shared_set, shared_criterion
Common metrics
Performance: metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.ctr, metrics.average_cpc, metrics.average_cpm, metrics.interactions
Conversions: metrics.conversions, metrics.conversions_value, metrics.all_conversions, metrics.cost_per_conversion, metrics.conversion_rate, metrics.value_per_conversion
Impression share: metrics.search_impression_share, metrics.search_budget_lost_impression_share, metrics.search_rank_lost_impression_share, metrics.absolute_top_impression_percentage, metrics.top_impression_percentage
Video: metrics.video_views, metrics.video_view_rate, metrics.average_cpv
Common segments
Date: segments.date, segments.week, segments.month, segments.quarter, segments.year, segments.hour_of_day, segments.day_of_week
Device/network: segments.device, segments.ad_network_type, segments.slot, segments.click_type
Conversion: segments.conversion_action, segments.conversion_action_name, segments.conversion_action_category
Important GAQL rules
-
Date range required with date segments. If
segments.date(orsegments.week,segments.month, etc.) is in SELECT, a finite date range filter MUST be in WHERE. -
Non-date segments in WHERE must be in SELECT. Exception: date segments can appear in WHERE without being in SELECT.
-
Removed entities are included by default. The API does NOT filter out removed entities. Add
campaign.status != 'REMOVED'(or equivalent) to match Google Ads UI behavior. -
Field compatibility. Not all fields can be selected together. If you get an error about incompatible fields, remove fields one at a time or consult the Google Ads API field compatibility documentation.
-
ORDER BY fields must be in SELECT. You can only order by fields that appear in the SELECT clause.
-
Attributed resources. You can select parent entity fields without them being in FROM. For example,
campaign.nameis available whenFROM ad_group.
GAQL query examples
Search terms that triggered ads:
google-ads-cli query 1234567890 "SELECT search_term_view.search_term, search_term_view.status, campaign.name, ad_group.name, metrics.clicks, metrics.impressions, metrics.ctr, metrics.cost_micros FROM search_term_view WHERE segments.date DURING LAST_30_DAYS ORDER BY metrics.impressions DESC LIMIT 50"
Campaign performance by device:
google-ads-cli query 1234567890 "SELECT campaign.name, segments.device, metrics.impressions, metrics.clicks, metrics.ctr, metrics.cost_micros, metrics.conversions FROM campaign WHERE segments.date DURING LAST_30_DAYS AND campaign.status != 'REMOVED'"
Impression share analysis:
google-ads-cli query 1234567890 "SELECT campaign.name, metrics.search_impression_share, metrics.search_budget_lost_impression_share, metrics.search_rank_lost_impression_share, metrics.clicks, metrics.impressions, metrics.cost_micros FROM campaign WHERE segments.date DURING LAST_7_DAYS AND campaign.status = 'ENABLED' ORDER BY metrics.search_budget_lost_impression_share DESC"
Landing page performance:
google-ads-cli query 1234567890 "SELECT landing_page_view.unexpanded_final_url, metrics.clicks, metrics.impressions, metrics.ctr, metrics.cost_micros, metrics.conversions FROM landing_page_view WHERE segments.date DURING LAST_30_DAYS ORDER BY metrics.clicks DESC LIMIT 20"
Demographics -- age breakdown:
google-ads-cli query 1234567890 "SELECT ad_group_criterion.age_range.type, campaign.name, metrics.clicks, metrics.impressions, metrics.ctr, metrics.cost_micros FROM age_range_view WHERE segments.date DURING LAST_30_DAYS"
Geographic performance (by user location):
google-ads-cli query 1234567890 "SELECT geographic_view.country_criterion_id, geographic_view.location_type, campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros FROM geographic_view WHERE segments.date DURING LAST_30_DAYS ORDER BY metrics.clicks DESC LIMIT 50"
Ad copy performance (responsive search ads):
google-ads-cli query 1234567890 "SELECT ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.final_urls, ad_group_ad.status, metrics.clicks, metrics.impressions, metrics.ctr, metrics.cost_micros FROM ad_group_ad WHERE segments.date DURING LAST_30_DAYS AND ad_group_ad.status != 'REMOVED' AND ad_group_ad.ad.type = 'RESPONSIVE_SEARCH_AD' ORDER BY metrics.clicks DESC LIMIT 20"
Conversion actions audit:
google-ads-cli query 1234567890 "SELECT conversion_action.name, conversion_action.type, conversion_action.status, conversion_action.category, conversion_action.counting_type, conversion_action.click_through_lookback_window_days, conversion_action.view_through_lookback_window_days FROM conversion_action WHERE conversion_action.status = 'ENABLED'"
Shopping product performance:
google-ads-cli query 1234567890 "SELECT segments.product_item_id, segments.product_title, metrics.clicks, metrics.impressions, metrics.ctr, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM shopping_performance_view WHERE segments.date DURING LAST_30_DAYS ORDER BY metrics.conversions_value DESC LIMIT 50"
Account-level daily trend:
google-ads-cli query 1234567890 "SELECT segments.date, metrics.clicks, metrics.impressions, metrics.ctr, metrics.cost_micros, metrics.conversions, metrics.conversions_value FROM customer WHERE segments.date DURING LAST_30_DAYS ORDER BY segments.date"
Workflow guidance
When the user asks for a quick overview
- Run
google-ads-cli customersto find accessible accounts - Use
campaign-statswith a recent date range for a performance snapshot - Present the data with costs converted from micros to currency
When the user asks for deep analysis
- Start with
campaign-statsto identify the scope - Drill down with
ad-group-statsorkeyword-statsfor underperforming campaigns - Use custom GAQL queries for specific analysis (search terms, demographics, impression share, landing pages)
- Cross-reference with
conversion-actionsto verify tracking setup
When the user asks about specific metrics not in built-in commands
Use the query command with GAQL. Common scenarios:
- Search terms report -- use
search_term_view - Geographic data -- use
geographic_view - Demographics -- use
gender_view,age_range_view - Landing pages -- use
landing_page_view - Impression share -- select
metrics.search_impression_shareand related fields fromcampaign - Shopping products -- use
shopping_performance_view - Change history -- use
change_eventfor detailed logs
Error handling
- Authentication errors -- ask the user to verify their access token and developer token
- "field is not compatible" -- some fields cannot be selected together; remove incompatible fields and retry
- Empty results -- check date range, status filters, and whether the account has data for the requested entities
- "MISALIGNED_DATE_FOR_FILTER" -- when filtering
segments.monthorsegments.quarter, the date must be the first day of the period