SQL examples for ODBC

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Google Ads.

• Get campaign performance report by date
• Get campaign performance report by month
• Get campaigns
• Get customers
• Get keywords (all campaigns / ad groups)
• Get resource data (e.g. ad_group, campaign, keyword_view)
• Query campaign performance (metrics / segments) using #DirectSQL
• Query data (Simple Mode) using #DirectSQL
• Query data using GAQL