Which Google Ads campaigns have the best and worst CTR?
Pull campaign.name with metrics.ctr, metrics.impressions, and metrics.clicks from the campaign resource. Impressions matter alongside CTR - a campaign with a great CTR on a handful of impressions is a different situation from one with the same CTR at scale.
The report
| GAQL field | What it means |
|---|---|
campaign.name | The campaign's name. |
metrics.ctr | Click-through rate: clicks divided by impressions. |
metrics.impressions | The number of times an ad from the campaign was shown. |
metrics.clicks | The number of clicks the campaign received. |
Resource: campaign. Tool: get_campaign_performance - one of Caybl.ai's built-in Google Ads tools.
Ask it in plain English
Ask that in Claude or ChatGPT once Google Ads is connected through Caybl.ai, and your agent builds this exact report - you don't need to know the GAQL field names above at all.
What actually trips people up
CTR is not comparable across networks: Search campaigns typically run in the 3-7%+ range while Display and Video inventory is normal at well under 1%, since Display ads are shown to people who weren't actively searching for anything. Ranking campaigns by CTR without filtering by advertising_channel_type mostly just ranks them by network mix, not by creative or targeting quality - split Search from Display/Video first, then compare within each.
Ask your own Google Ads account this
Connect once, then ask in plain English. No tokens, no setup.
Get started freeFAQ
Which GAQL fields does "Which Google Ads campaigns have the best and worst CTR?" need?
campaign.name, metrics.ctr, metrics.impressions, metrics.clicks, from the campaign resource. These are the real Google Ads Query Language (GAQL) field names, so the same report can be built in the Google Ads UI, the API, or through Caybl.ai.
Can I just ask "Which campaigns have the highest and lowest CTR this month?" instead of writing GAQL?
Yes. Once Google Ads is connected through Caybl.ai, ask "Which campaigns have the highest and lowest CTR this month?" and your agent runs the report for you - no need to know the campaign.name field or write GAQL yourself.
Does asking about campaign change anything in my Google Ads account?
No. This is a read-only report - it uses Caybl.ai's read access to Google Ads and doesn't touch campaigns, budgets, or keywords. Making changes to your account is a separate, opt-in permission you control per connection.
Related recipes
Sources
- Google Ads Query Language (GAQL) reference - official Google documentation