EndPoint Get Customers

Name

get_customers

Get Google Ads customer data [API reference]

Parameter	Label	Required	Options	Description
CustomerId	CustomerId (without dash e.g. 2125557752)	NO		Login to your Google Ads account and see top-right corner for your CustomerId

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(50)`	50	`False`
DescriptiveName	`DT_WSTR`	`nvarchar(500)`	500	`False`
Status	`DT_WSTR`	`nvarchar(100)`	100	`False`
Manager	`DT_BOOL`	`bit`		`False`
TestAccount	`DT_BOOL`	`bit`		`False`
ResourceName	`DT_WSTR`	`nvarchar(500)`	500	`False`
CallReportingSettingCallReportingEnabled	`DT_BOOL`	`bit`		`False`
CallReportingSettingCallConversionReportingEnabled	`DT_BOOL`	`bit`		`False`
CallReportingSettingCallConversionAction	`DT_WSTR`	`nvarchar(500)`	500	`False`
ConversionTrackingSettingConversionTrackingId	`DT_WSTR`	`nvarchar(100)`	100	`False`
ConversionTrackingSettingAcceptedCustomerDataTerms	`DT_BOOL`	`bit`		`False`
ConversionTrackingSettingConversionTrackingStatus	`DT_WSTR`	`nvarchar(500)`	500	`False`
ConversionTrackingSettingGoogleAdsConversionCustomer	`DT_WSTR`	`nvarchar(500)`	500	`False`
RemarketingSettingGoogleGlobalSiteTag	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
PayPerConversionEligibilityFailureReasons	`DT_WSTR`	`nvarchar(500)`	500	`False`
CurrencyCode	`DT_WSTR`	`nvarchar(50)`	50	`False`
TimeZone	`DT_WSTR`	`nvarchar(500)`	500	`False`
TrackingUrlTemplate	`DT_WSTR`	`nvarchar(1080)`	1080	`False`
AutoTaggingEnabled	`DT_BOOL`	`bit`		`False`
HasPartnersBadge	`DT_BOOL`	`bit`		`False`
OptimizationScore	`DT_R8`	`float`		`False`
OptimizationScoreWeight	`DT_R8`	`float`		`False`
LocationAssetAutoMigrationDone	`DT_BOOL`	`bit`		`False`
ImageAssetAutoMigrationDone	`DT_BOOL`	`bit`		`False`
LocationAssetAutoMigrationDoneDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`
ImageAssetAutoMigrationDoneDateTime	`DT_DBTIMESTAMP`	`datetime`		`False`

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Use Google Ads Connector in API Source component to read data or in API Destination component to read/write data:

Google Ads

Get Customers

Google Ads

Get Customers

Use these SQL queries in your ODBC application data source:

Get all customers you can query in your account

SELECT * FROM get_customers

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get all customers you can query in your account

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_customers';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_GOOGLE_ADS_IN_DATA_GATEWAY];