GAQL account hygiene: disapprovals, budget caps, conversions and change history
Four read-only queries that surface disapproved ads, budget-constrained campaigns, the state of your conversion actions and who changed what recently.
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.
Asset performance across RSA and Performance Max, in one query set
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.
Demand Gen performance: the GAQL to break open a single-line campaign
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.
GAQL for Performance Max: seeing what the black box will let you see
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.
GAQL waste finder: four queries for the spend that earns nothing
A pack of read-only Google Ads queries that surface search terms, keywords, placements and whole campaigns taking budget while returning no conversions.
GAQL query overview and the interactive query builder
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.
The Tuesday Briefing
One editor-curated email. The updates that matter, the noise filtered out.
Free. Occasionally includes sponsored messages from our partners. Unsubscribe anytime.