Runs a read-only Google Ads Query Language (GAQL) report on a Google Ads account: any resources, fields, segments and metrics.
curl -X POST "https://api.primaryapi.com/v1/run/google-ads.query" \
-H "Authorization: Bearer $PRIMARYAPI_API_KEY" \
-H "Content-Type: application/json" \
-d '{"customerId":"123-456-7890","query":"SELECT campaign.name, campaign.id, metrics.clicks, metrics.impressions, metrics.cost_micros FROM campaign WHERE segments.date DURING LAST_7_DAYS ORDER BY metrics.clicks DESC"}'{
"output": {
"found": true,
"data": {
"fieldMask": "campaign.name,campaign.id,metrics.c…",
"nextCursor": null,
"rows": [
{
"campaign": { … },
"metrics": { … }
}, …
],
"customerId": "1234567890"
}
},
"credits": 1
}Input and output
6 fields
123-456-7890.SELECT campaign.name, campaign.id, metr….customerId THROUGH a manager (MCC) account: that manager account’s id (10 digits). Sent as the login-customer-id header. Omit for accounts the Google account can open directly.4 fields
Good to know
Runs as your connected Google account. Needs the Google Ads capability.
Read-only: GAQL can only SELECT.
Field names in the query are snake_case. The rows come back in lowerCamelCase (metrics.costMicros) and money is in micros.
Manager accounts have no metrics. Query a client account, passing the manager id as loginCustomerId.
Add a LIMIT to keep large reports fast.
A rejected query is an invalid input error (nothing is charged).
The same key and credits work for every API.