EndPoint Get Campaigns
Name
get_campaigns
Description
Get Google Ads campaign data [API reference]
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

Get Campaigns using API Destination
Google Ads
Get Campaigns

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];