EndPoint Get Campaign Keywords
Name
get_campaign_keywords
Description
Get Campaign Keywords (For all AdGroup) [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 |
|---|---|---|---|---|---|
| CampaignId |
DT_WSTR
|
nvarchar(30)
|
30 | False |
|
| CampaignName |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| CampaignResourceName |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| CampaignStatus |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| AdGroupId |
DT_WSTR
|
nvarchar(30)
|
30 | False |
|
| AdGroupName |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| AdGroupResourceName |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| AdGroupStatus |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
| CriterionId |
DT_WSTR
|
nvarchar(30)
|
30 | False |
This is Keyword Id |
| CriterionStatus |
DT_WSTR
|
nvarchar(30)
|
30 | False |
|
| CriterionApprovalStatus |
DT_WSTR
|
nvarchar(30)
|
30 | False |
|
| CriterionResourceName |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| CriterionFinalUrls |
DT_WSTR
|
nvarchar(2000)
|
2000 | False |
|
| CriterionFinalMobileUrls |
DT_WSTR
|
nvarchar(2000)
|
2000 | False |
|
| KeywordText |
DT_WSTR
|
nvarchar(500)
|
500 | False |
|
| KeywordMatchType |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
| KeywordCpcBid |
DT_R8
|
float
|
False |
||
| KeywordCpcBidMicros |
DT_I8
|
bigint
|
False |
||
| KeywordCpmBid |
DT_R8
|
float
|
False |
||
| KeywordCpmBidMicros |
DT_I8
|
bigint
|
False |
||
| KeywordResourceName |
DT_WSTR
|
nvarchar(1000)
|
1000 | 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 Campaign Keywords using API Source
Google Ads
Get Campaign Keywords
Get Campaign Keywords using API Destination
Google Ads
Get Campaign Keywords
ODBC application
Use these SQL queries in your ODBC application data source:
Get keywords information (all campaigns / ad groups)
Get keywords for all campaigns and all ad groups (criterion_id is basically keyword_id)
select * from get_campaign_keywordsSQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get keywords information (all campaigns / ad groups)
Get keywords for all campaigns and all ad groups (criterion_id is basically keyword_id)
DECLARE @MyQuery NVARCHAR(MAX) = 'select * from get_campaign_keywords';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_GOOGLE_ADS_IN_DATA_GATEWAY];