Google Ads

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

Google Ads
Table Accessible Bidding Strategies

Google Ads
Table Accounts

Google Ads
Table Ads

Google Ads
Table Ad Group Criterion

Google Ads
Table Ad Groups

Google Ads
Table Bidding Strategies

Google Ads
Table Call Details

Google Ads
Table Campaign Budgets

Google Ads
Table Campaign Criterion

Google Ads
Table Campaigns

Google Ads
Table Campaign Labels

Google Ads
Table Carrier Constant

Google Ads
Table Feed

Google Ads
Table Feed Item

Google Ads
Table Labels

Google Ads
Table Language Constant

Google Ads
Table Mobile App Category Constant

Google Ads
Table Mobile Device Constant

Google Ads
Table Operating System Version Constant

Google Ads
Table Topic Constant

Google Ads
Table User Interest

Google Ads
Table User List

Google Ads
Table Account Performance Report

Google Ads
Table Ad Group Performance Report

Google Ads
Table Ad Group Audience Performance Report

Google Ads
Table Campaign Audience Performance Report

Google Ads
Table Campaign Performance Report

Google Ads
Table Keywords Performance Report

Use SQL on all your SaaS data

Magical SQL for Google Ads with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Peliqan Ask AI willl write your SQL queries from plain English

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.