Campaigns with highest CTR
SQL query for Google Ads
Find campaigns with the highest click-through rate.
SELECT campaign_name, ctr FROM CampaignPerformanceReport ORDER BY ctr DESC LIMIT 10
Google Ads data model
Accessible Bidding Strategies
Accounts
Ads
Ad Group Criterion
Ad Groups
Bidding Strategies
Call Details
Campaign Budgets
Campaign Criterion
Campaigns
Campaign Labels
Carrier Constant
Feed
Feed Item
Labels
Language Constant
Mobile App Category Constant
Mobile Device Constant
Operating System Version Constant
Topic Constant
User Interest
User List
Account Performance Report
Ad Group Performance Report
Ad Group Audience Performance Report
Campaign Audience Performance Report
Campaign Performance Report
Keywords Performance Report
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed