DynamicSearchAdsSearchTermView
A dynamic search ads search term view.
Table Specific Information
Select
Google Ads 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 Ads 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 Ads API.
Columns
Name | Type | Behavior | Description |
DynamicSearchAdsSearchTermViewHasMatchingKeyword | Bool | Attribute | HasMatchingKeyword column for table DynamicSearchAdsSearchTermView |
DynamicSearchAdsSearchTermViewHasNegativeKeyword | Bool | Attribute | HasNegativeKeyword column for table DynamicSearchAdsSearchTermView |
DynamicSearchAdsSearchTermViewHasNegativeUrl | Bool | Attribute | HasNegativeUrl column for table DynamicSearchAdsSearchTermView |
DynamicSearchAdsSearchTermViewHeadline | String | Attribute | Headline column for table DynamicSearchAdsSearchTermView |
DynamicSearchAdsSearchTermViewLandingPage | String | Attribute | LandingPage column for table DynamicSearchAdsSearchTermView |
DynamicSearchAdsSearchTermViewPageUrl | String | Attribute | PageUrl column for table DynamicSearchAdsSearchTermView |
DynamicSearchAdsSearchTermViewResourceName | String | Attribute | ResourceName column for table DynamicSearchAdsSearchTermView |
DynamicSearchAdsSearchTermViewSearchTerm | String | Attribute | SearchTerm column for table DynamicSearchAdsSearchTermView |
CustomerId | Long | Attribute | ClientCustomerId column for table DynamicSearchAdsSearchTermView |
AllConversions | Double | Metric | AllConversions column for table Metrics |
AllConversionsFromInteractionsRate | Double | Metric | AllConversionsFromInteractionsRate column for table Metrics |
AllConversionsValue | Double | Metric | AllConversionsValue column for table Metrics |
AverageCpc | Double | Metric | AverageCpc column for table Metrics |
AverageCpm | Double | Metric | AverageCpm column for table Metrics |
Clicks | Long | Metric | Clicks column for table Metrics |
Conversions | Double | Metric | Conversions column for table Metrics |
ConversionsFromInteractionsRate | Double | Metric | ConversionsFromInteractionsRate column for table Metrics |
ConversionsValue | Double | Metric | ConversionsValue column for table Metrics |
CostMicros | Long | Metric | CostMicros column for table Metrics |
CostPerAllConversions | Double | Metric | CostPerAllConversions column for table Metrics |
CostPerConversion | Double | Metric | CostPerConversion column for table Metrics |
CrossDeviceConversions | Double | Metric | CrossDeviceConversions column for table Metrics |
Ctr | Double | Metric | Ctr column for table Metrics |
Impressions | Long | Metric | Impressions column for table Metrics |
ValuePerAllConversions | Double | Metric | ValuePerAllConversions column for table Metrics |
ValuePerConversion | Double | Metric | ValuePerConversion column for table Metrics |
ConversionAction | String | Segment | ConversionAction column for table Segments |
ConversionActionCategory | String | Segment | ConversionActionCategory column for table Segments |
ConversionActionName | String | Segment | ConversionActionName column for table Segments |
Date | Date | Segment | Date column for table Segments |
DayOfWeek | String | Segment | DayOfWeek column for table Segments |
ExternalConversionSource | String | Segment | ExternalConversionSource column for table Segments |
Month | Date | Segment | Month column for table Segments |
MonthOfYear | String | Segment | MonthOfYear column for table Segments |
Quarter | Date | Segment | Quarter column for table Segments |
Webpage | String | Segment | Webpage column for table Segments |
Week | Date | Segment | Week column for table Segments |
Year | Int | Segment | Year column for table Segments |
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 |
ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |
Last updated