CampaignNegativeLocations

Although negative locations do not hold statistics, you can use this structured report to efficiently retrieve attributes of location-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 CampaignNegativeLocations report.
AccountDescriptiveName	String	Attribute	Account	Account for the CampaignNegativeLocations report.
AccountTimeZone	String	Attribute	Time Zone	Time Zone for the CampaignNegativeLocations report.
BaseCampaignId	Long	Attribute	Base Campaign ID	Base Campaign ID for the CampaignNegativeLocations report.
CampaignId	Long	Attribute	Campaign ID	Campaign ID for the CampaignNegativeLocations report.
CampaignName	String	Attribute	Campaign	Campaign for the CampaignNegativeLocations report.
CampaignStatus	String	Attribute	Campaign State	Campaign State for the CampaignNegativeLocations report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CustomerDescriptiveName	String	Attribute	Client Name	Client Name for the CampaignNegativeLocations report.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the CampaignNegativeLocations report.
Id	Long	Attribute	Location	Location for the CampaignNegativeLocations report.
IsNegative	String	Attribute	Is Negative	Is Negative for the CampaignNegativeLocations report. The allowed values are TRUE, FALSE.

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.