Google Ads Connector
Documentation
Version: 1
Documentation

EndPoint Get Campaigns


Parameters

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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(30) 30 False
Name DT_WSTR nvarchar(500) 500 False
Status DT_WSTR nvarchar(30) 30 False
StartDate DT_DBDATE date False
EndDate DT_DBDATE date False
CampaignBudgetAmount DT_R8 float False
CampaignBudgetAmountMicros DT_I8 bigint False
TargetCpa DT_R8 float False
TargetCpaMicros DT_I8 bigint False
MaximizeConversionsTargetCpa DT_R8 float False
MaximizeConversionsTargetCpaMicros DT_I8 bigint False
KeywordMatchType DT_WSTR nvarchar(50) 50 False
ResourceName DT_WSTR nvarchar(500) 500 False
BiddingStrategyType DT_WSTR nvarchar(100) 100 False
FinalUrlSuffix DT_WSTR nvarchar(500) 500 False
AdServingOptimizationStatus DT_WSTR nvarchar(500) 500 False
AdvertisingChannelType DT_WSTR nvarchar(500) 500 False
NetworkSettingsTargetGoogleSearch DT_BOOL bit False
NetworkSettingsTargetSearchNetwork DT_BOOL bit False
NetworkSettingsTargetContentNetwork DT_BOOL bit False
NetworkSettingsTargetPartnerSearchNetwork DT_BOOL bit False
NetworkSettingsTargetYoutube DT_BOOL bit False
NetworkSettingsTargetGoogleTvNetwork DT_BOOL bit False
ExperimentType DT_WSTR nvarchar(100) 100 False
ServingStatus DT_WSTR nvarchar(100) 100 False
DynamicSearchAdsSettingDomainName DT_WSTR nvarchar(500) 500 False
DynamicSearchAdsSettingLanguageCode DT_WSTR nvarchar(50) 50 False
DynamicSearchAdsSettingUseSuppliedUrlsOnly DT_BOOL bit False
TargetingSettingTargetRestrictions DT_WSTR nvarchar(1000) 1000 False
GeoTargetTypeSettingPositiveGeoTargetType DT_WSTR nvarchar(100) 100 False
GeoTargetTypeSettingNegativeGeoTargetType DT_WSTR nvarchar(100) 100 False
PaymentMode DT_WSTR nvarchar(100) 100 False
BaseCampaign DT_WSTR nvarchar(500) 500 False
Labels DT_WSTR nvarchar(500) 500 False
BiddingStrategySystemStatus DT_WSTR nvarchar(500) 500 False
PrimaryStatus DT_WSTR nvarchar(100) 100 False
PrimaryStatusReasons DT_WSTR nvarchar(1050) 1050 False
CampaignBudget DT_WSTR nvarchar(500) 500 False
ManualCpcEnhancedCpcEnabled DT_BOOL bit False
CampaignGroup DT_WSTR nvarchar(500) 500 False
AdvertisingChannelSubType DT_WSTR nvarchar(100) 100 False
TargetSpend DT_R8 float False
TargetSpendMicros DT_I8 bigint False
FrequencyCaps DT_WSTR nvarchar(4000) 4000 False
VideoBrandSafetySuitability DT_WSTR nvarchar(500) 500 False
AssetAutomationSettings DT_WSTR nvarchar(1090) 1090 False
TargetImpressionShareLocation DT_WSTR nvarchar(500) 500 False
TargetImpressionShareLocationFraction DT_R8 float False
TargetImpressionShareLocationFractionMicros DT_I8 bigint False
TargetImpressionShareCpcBidCeiling DT_R8 float False
TargetImpressionShareCpcBidCeilingMicros DT_I8 bigint False
UrlExpansionOptOut DT_BOOL bit False
AudienceSettingUseAudienceGrouped DT_BOOL bit False
PerformanceMaxUpgradePerformanceMaxCampaign DT_WSTR nvarchar(500) 500 False
PerformanceMaxUpgradeStatus DT_WSTR nvarchar(500) 500 False
OptimizationScore DT_R8 float False

Input Columns

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.

Examples

SSIS

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

Get Campaigns using API Source

Google Ads
Get Campaigns
SSIS API Source - Read from table or endpoint

Get Campaigns using API Destination

Google Ads
Get Campaigns
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get Campaigns

Get all Campaigns for Google Ads account

SELECT * FROM get_campaigns

SQL Server

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

Get Campaigns

Get all Campaigns for Google Ads account

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

EXEC (@MyQuery) AT [LINKED_SERVER_TO_GOOGLE_ADS_IN_DATA_GATEWAY];