GAQL Reference

GAQL Reference

Google Ads Query Language (GAQL) cheat sheet for MiniAgent.

Syntax

SELECT field1, field2
FROM resource
WHERE condition
ORDER BY field [ASC|DESC]
LIMIT n

Top 10 Campaigns by Spend

SELECT campaign.name, campaign.status,
       metrics.cost_micros, metrics.impressions, metrics.clicks,
       metrics.conversions, metrics.search_impression_share
FROM campaign
WHERE segments.date DURING LAST_30_DAYS
  AND campaign.status != 'REMOVED'
ORDER BY metrics.cost_micros DESC
LIMIT 10

Wasted Spend (Zero-Conversion Search Terms)

SELECT search_term_view.search_term,
       metrics.cost_micros, metrics.clicks, metrics.conversions
FROM search_term_view
WHERE segments.date DURING LAST_30_DAYS
  AND metrics.conversions = 0
  AND metrics.cost_micros > 5000000
ORDER BY metrics.cost_micros DESC
LIMIT 50

Quality Score Distribution

SELECT ad_group_criterion.keyword.text,
       ad_group_criterion.quality_info.quality_score,
       metrics.impressions, metrics.cost_micros
FROM keyword_view
WHERE ad_group_criterion.quality_info.quality_score IS NOT NULL
ORDER BY metrics.cost_micros DESC

Shopping Performance by Product

SELECT segments.product_item_id, segments.product_title,
       metrics.impressions, metrics.clicks, metrics.cost_micros,
       metrics.conversions
FROM shopping_performance_view
WHERE segments.date DURING LAST_30_DAYS
ORDER BY metrics.cost_micros DESC
LIMIT 100

Competitor Analysis (Auction Insights)

SELECT auction_insights.display_url,
       metrics.search_impression_share,
       metrics.search_overlap_rate,
       metrics.search_outranking_share
FROM auction_insights
WHERE segments.date DURING LAST_30_DAYS

Date Predicates

Predicate	Meaning
LAST_7_DAYS	Last 7 days
LAST_30_DAYS	Last 30 days
THIS_MONTH	Month to date
LAST_MONTH	Previous full month
BETWEEN '2026-01-01' AND '2026-03-22'	Custom range

Important: When using date filters, segments.date must be in the SELECT.

Key Resources

Resource	What
campaign	Campaign-level data
ad_group	Ad group-level
keyword_view	Keyword performance
search_term_view	Actual search queries
shopping_performance_view	Shopping product data
auction_insights	Competitor metrics

Currency Note

cost_micros ÷ 1,000,000 = actual dollars. Example: 45000000 = $45.00