Clicks by keyword
SQL query for Google Ads
Get the number of clicks by keyword from Google Ads data.
SELECT keyword, SUM(clicks) as total_clicks FROM google_ads_table GROUP BY keyword;
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