ODBC guide

Query data (Simple Mode) using #DirectSQL

Returns report data using GAQL in simple mode. Prefix the query with #DirectSQL and write the GAQL SELECT directly; use the Query Builder to pick fields and paste the query below.

#DirectSQL 

--Use Query Builder here https://developers.google.com/google-ads/api/fields/v18/overview_query_builder
--Paste Generated query below
				
SELECT  campaign.id, campaign.name, metrics.impressions, metrics.clicks, metrics.cost_micros
FROM campaign 
--WHERE campaign.status = 'ENABLED'
--ORDER BY campaign.id
--LIMIT 1000