Google Ads Filters

LightLead builds a GAQL WHERE clause from filters based on aliases. Logic: AND / OR.

Filterable Fields (aliases → GAQL)

Alias	GAQL	Note
`account_id`	`customer.id`
`account_name`	`customer.descriptive_name`	LIKE / NOT LIKE
`campaign_id`	`campaign.id`	minResource: campaign
`campaign_name`	`campaign.name`
`campaign_status`	`campaign.status`
`adset_id`	`ad_group.id`	minResource: ad_group
`adset_name`	`ad_group.name`
`adgroup_status`	`ad_group.status`
`ad_id`	`ad_group_ad.ad.id`	minResource: ad_group_ad
`ad_name`	`ad_group_ad.ad.name`
`keyword_text`	`ad_group_criterion.keyword.text`	minResource: keyword_view
`device`	`segments.device`	segment
`network`	`segments.ad_network_type`	segment
`spend`	`metrics.cost_micros`	value × 1e6
`clicks`	`metrics.clicks`	metric filter
`impressions`	`metrics.impressions`	metric filter
`conversions`	`metrics.conversions`	metric filter

A filter on a field with a minResource above the current report resource is ignored.

sql

segments.date DURING LAST_30_DAYS
segments.date BETWEEN '2026-07-01' AND '2026-07-25'

Default — LAST_30_DAYS.

sql

WHERE campaign.status = 'ENABLED'
  AND metrics.impressions > 0
  AND segments.date DURING LAST_30_DAYS

sql

WHERE campaign.name LIKE '%brand%'
  AND metrics.cost_micros > 10000000

Metric filters (spend/clicks/impressions/conversions) apply to numeric values; for spend — converted to micros
The device/network segments split rows
Computed roas / cost_per_result cannot be filtered directly