CampaignNegativeKeywordsPerformance
Although negative keywords do not hold statistics, you can use this structured report to efficiently retrieve attributes of keyword-based NegativeCampaignCriterion objects.
Table Specific Information
Select
Google AdWords does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the AdWords console.
To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the AdWords API.
Columns
Name | Type | Behavior | DisplayName | Description |
AccountCurrencyCode | String | Attribute | Currency | Currency for the CampaignNegativeKeywordsPerformance report. |
AccountDescriptiveName | String | Attribute | Account | Account for the CampaignNegativeKeywordsPerformance report. |
AccountTimeZone | String | Attribute | Time Zone | Time Zone for the CampaignNegativeKeywordsPerformance report. |
BaseCampaignId | Long | Attribute | Base Campaign ID | Base Campaign ID for the CampaignNegativeKeywordsPerformance report. |
CampaignId | Long | Attribute | Campaign ID | Campaign ID for the CampaignNegativeKeywordsPerformance report. |
CampaignName | String | Attribute | Campaign | Campaign for the CampaignNegativeKeywordsPerformance report. |
CampaignStatus | String | Attribute | Campaign State | Campaign State for the CampaignNegativeKeywordsPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
Criteria | String | Attribute | Negative Keyword | Negative Keyword for the CampaignNegativeKeywordsPerformance report. |
CustomerDescriptiveName | String | Attribute | Client Name | Client Name for the CampaignNegativeKeywordsPerformance report. |
ExternalCustomerId | Long | Attribute | Customer ID | Customer ID for the CampaignNegativeKeywordsPerformance report. |
Id | Long | Attribute | Keyword ID | Keyword ID for the CampaignNegativeKeywordsPerformance report. |
IsNegative | String | Attribute | Is Negative | Is Negative for the CampaignNegativeKeywordsPerformance report. The allowed values are TRUE, FALSE. |
KeywordMatchType | String | Attribute | Match Type | Match Type for the CampaignNegativeKeywordsPerformance report. The allowed values are EXACT, PHRASE, BROAD. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
StartDate | String | Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days. |
EndDate | String | End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days. |
Last updated