Skip to content

Google Ads Query Parameters ​

Queries to the Google Ads API are built using the Google Ads Query Language (GAQL). Below are the main parameters and language constructs.

SELECT Parameters ​

Core Fields ​

sql
SELECT
  campaign.id,
  campaign.name,
  campaign.status,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros

Aliases ​

sql
SELECT
  campaign.id AS campaign_id,
  campaign.name AS campaign_name,
  metrics.cost_micros AS cost

Aggregate Functions ​

sql
SELECT
  campaign.id,
  SUM(metrics.impressions) AS total_impressions,
  AVG(metrics.ctr) AS avg_ctr

FROM Parameters ​

The resource data is queried from:

ResourceDescription
campaignCampaigns
ad_groupAd groups
ad_group_adAds
keyword_viewKeywords
search_term_viewSearch terms
customerAccount

WHERE Parameters ​

Filtering by Value ​

sql
WHERE campaign.status = 'ENABLED'
  AND metrics.impressions > 100

Filtering by Date (DURING) ​

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

Operators ​

OperatorExample
=status = 'ENABLED'
!=type != 'VIDEO'
>impressions > 100
<cost_micros < 5000000
>=clicks >= 10
<=ctr <= 0.05
INstatus IN ('ENABLED', 'PAUSED')
NOT INtype NOT IN ('VIDEO', 'DISPLAY')
LIKEname LIKE '%brand%'
NOT LIKEname NOT LIKE '%test%'

ORDER BY Parameters ​

sql
ORDER BY metrics.cost_micros DESC
ORDER BY campaign.name ASC, metrics.clicks DESC

LIMIT Parameters ​

sql
LIMIT 100
LIMIT 1000

Maximum limit: 10,000 rows per query.

Pagination Parameters ​

For queries with more than 10,000 rows, a page_token is used:

POST /customers/{customer_id}/googleAds:search
{
  "query": "SELECT ...",
  "page_token": "abc123",
  "page_size": 10000
}

Segmentation (Segments) ​

Segmentation lets you break down data by additional dimensions:

sql
SELECT
  campaign.name,
  segments.device,
  segments.date,
  metrics.impressions
FROM campaign
WHERE segments.date DURING LAST_30_DAYS

Core Segments ​

SegmentDescription
segments.dateBy day
segments.weekBy week
segments.monthBy month
segments.quarterBy quarter
segments.deviceBy device (DESKTOP, MOBILE, TABLET)
segments.networkBy advertising network
segments.day_of_weekBy day of week
segments.hourBy hour

Maintained by the LightLead Documentation Team · Last verified: 2026-07-25