The Query Cookbook
GAQL Library
Ready-to-run Google Ads Query Language for the reports the UI does not want to give you. Paste into the API, scripts or your favourite runner.
Entries in this section
Four read-only queries that surface disapproved ads, budget-constrained campaigns, the state of your conversion actions and who changed what recently.
Ready-to-run GAQL for creative asset ratings across responsive search ads and Performance Max asset groups, so you can find weak headlines and images in one query set.
A cookbook of Demand Gen GAQL queries that splits spend, conversions, asset ratings and audiences out of the campaign line Google reports as a single figure.
A pack of read-only queries that pull asset-group performance, the listing-group tree and campaign spend out of Performance Max, with an honest map of where the API stops.
A pack of read-only Google Ads queries that surface search terms, keywords, placements and whole campaigns taking budget while returning no conversions.
Google's own reference for the Google Ads Query Language, paired with an interactive builder for constructing and validating queries against the current API version.
6 of 6 tools on the shelf
Know a tool we’re missing? Tell us what you use and we will credit you when it is added.
Suggest a toolOne editor-curated email. The updates that matter, the noise filtered out.
Free. Occasionally includes sponsored messages from our partners. Unsubscribe anytime.