Read Tools

Read Tools — 47 GAQL Queries

All queries use pull_google_ads_data with an action parameter. Default date range: LAST_30_DAYS (overridable via params.dateRange).

Account & Overview

Action	Description	Resource
account_summary	Account-level spend, clicks, impressions, conversions	customer
daily_performance	Day-by-day account metrics	customer (segments.date)
hourly_performance	Hour-by-hour account metrics (last 7 days)	customer (segments.hour)

Campaigns

Action	Description	Resource
list_campaigns	All campaigns with metrics, bidding, budgets	campaign
campaign_daily	Per-campaign daily metrics	campaign (segments.date)
list_budgets	Campaign budgets and spend	campaign_budget
list_bidding_strategies	All bidding strategies	bidding_strategy
list_labels	All labels	label
list_experiments	All experiments	experiment
list_extensions	Sitelinks, callouts, snippets, call extensions	asset
list_campaign_criteria	Campaign-level targeting criteria	campaign_criterion
shared_budget_detail	Shared budgets across campaigns	campaign
list_negative_keyword_lists	Shared negative keyword lists	shared_set

Ad Groups & Ads

Action	Description	Resource
list_ad_groups	All ad groups with metrics	ad_group
list_ads	All ads with RSA headlines/descriptions, strength	ad_group_ad

Keywords & Search Terms

Action	Description	Resource
list_keywords	All keywords with quality scores	keyword_view
list_search_terms	Triggered search terms (top 200)	search_term_view
wasted_spend	Search terms with $0 conversions (top 100)	search_term_view
quality_score_report	Keyword quality scores with components	keyword_view

Audience & Demographics

Action	Description	Resource
list_audiences	Campaign audience targeting	campaign_audience_view
ad_group_audience_performance	Ad group audience metrics	ad_group_audience_view
list_user_lists	Customer match and remarketing lists	user_list
age_performance	Performance by age range	age_range_view
gender_performance	Performance by gender	gender_view
parental_status_performance	Performance by parental status	parental_status_view
income_performance	Performance by income range	income_range_view

Device & Geography

Action	Description	Resource
device_performance	Performance by device type	campaign (segments.device)
geo_performance	Performance by location (top 100)	geographic_view

Competitive Intelligence

Action	Description	Resource
auction_insights	Search impression share vs competitors	campaign
impression_share	Impression share, budget/rank lost IS	campaign

Change & Recommendation

Action	Description	Resource
change_history	Recent account changes (last 14 days)	change_event
list_recommendations	Google's optimization recommendations	recommendation

Conversions

Action	Description	Resource
list_conversions	All conversion actions with metrics	conversion_action
conversion_action_detail	Full conversion action configuration	conversion_action

Landing Pages

Action	Description	Resource
landing_page_performance	Landing page metrics, mobile-friendly, speed score	landing_page_view

Video

Action	Description	Resource
video_campaign_performance	Video campaign metrics (views, quartiles, CPV)	campaign (VIDEO)
video_ad_performance	Video ad-level metrics	ad_group_ad (VIDEO)

Shopping

Action	Description	Resource
shopping_performance	Product-level shopping metrics	shopping_performance_view
product_group_performance	Product group metrics	product_group_view

Performance Max

Action	Description	Resource
list_asset_groups	PMax asset groups with performance labels	asset_group
pmax_asset_performance	Per-asset performance in PMax	asset_group_asset
pmax_listing_groups	PMax listing group filters	asset_group_listing_group_filter

Display & Placements

Action	Description	Resource
placement_performance	Display placement metrics	detail_placement_view
topic_performance	Topic targeting metrics	topic_view
ad_schedule_performance	Performance by day/hour schedule	ad_schedule_view

Common Parameters

All read queries support these optional parameters:

Parameter	Description	Example
dateRange	Override date range	LAST_7_DAYS, LAST_90_DAYS, THIS_MONTH
campaignId	Filter to specific campaign	123456789
adGroupId	Filter to specific ad group	123456789
status	Filter by status	ENABLED, PAUSED
costMin	Minimum cost filter (micros)	1000000 ($1)
limit	Max rows returned	50
sortBy	Sort field	cost_micros, conversions
sortOrder	Sort direction	DESC, ASC