AdPerformance
The Ad Performance report includes all statistics aggregated at the ad level, one row per ad.
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. For example, the following query uses ClickType instead of the default Date segment to query Ad Performance data:\
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. All filters must be joined by the AND keyword as OR is not supported by the AdWords API. For example, this query will return only Ads that are enabled with a conversion rate greater than 0:\
Columns
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.
Last updated