TopicView
A topic 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 |
TopicViewResourceName | String | Attribute | ResourceName column for table TopicView |
CustomerId | Long | Attribute | ClientCustomerId column for table TopicView |
ActiveViewCpm | Double | Metric | ActiveViewCpm column for table Metrics |
ActiveViewCtr | Double | Metric | ActiveViewCtr column for table Metrics |
ActiveViewImpressions | Long | Metric | ActiveViewImpressions column for table Metrics |
ActiveViewMeasurability | Double | Metric | ActiveViewMeasurability column for table Metrics |
ActiveViewMeasurableCostMicros | Long | Metric | ActiveViewMeasurableCostMicros column for table Metrics |
ActiveViewMeasurableImpressions | Long | Metric | ActiveViewMeasurableImpressions column for table Metrics |
ActiveViewViewability | Double | Metric | ActiveViewViewability column for table Metrics |
AllConversions | Double | Metric | AllConversions column for table Metrics |
AllConversionsFromInteractionsRate | Double | Metric | AllConversionsFromInteractionsRate column for table Metrics |
AllConversionsFromInteractionsValuePerInteraction | Double | Metric | AllConversionsFromInteractionsValuePerInteraction column for table Metrics |
AllConversionsValue | Double | Metric | AllConversionsValue column for table Metrics |
AllConversionsValuePerCost | Double | Metric | AllConversionsValuePerCost column for table Metrics |
AverageCost | Double | Metric | AverageCost column for table Metrics |
AverageCpc | Double | Metric | AverageCpc column for table Metrics |
AverageCpe | Double | Metric | AverageCpe column for table Metrics |
AverageCpm | Double | Metric | AverageCpm column for table Metrics |
AverageCpv | Double | Metric | AverageCpv 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 |
EngagementRate | Double | Metric | EngagementRate column for table Metrics |
Engagements | Long | Metric | Engagements column for table Metrics |
GmailForwards | Long | Metric | GmailForwards column for table Metrics |
GmailSaves | Long | Metric | GmailSaves column for table Metrics |
GmailSecondaryClicks | Long | Metric | GmailSecondaryClicks column for table Metrics |
Impressions | Long | Metric | Impressions column for table Metrics |
InteractionEventTypes | String | Metric | InteractionEventTypes column for table Metrics |
InteractionRate | Double | Metric | InteractionRate column for table Metrics |
Interactions | Long | Metric | Interactions column for table Metrics |
ValuePerAllConversions | Double | Metric | ValuePerAllConversions column for table Metrics |
ValuePerConversion | Double | Metric | ValuePerConversion column for table Metrics |
VideoQuartileP100Rate | Double | Metric | VideoQuartileP100Rate column for table Metrics |
VideoQuartileP25Rate | Double | Metric | VideoQuartileP25Rate column for table Metrics |
VideoQuartileP50Rate | Double | Metric | VideoQuartileP50Rate column for table Metrics |
VideoQuartileP75Rate | Double | Metric | VideoQuartileP75Rate column for table Metrics |
VideoViewRate | Double | Metric | VideoViewRate column for table Metrics |
VideoViews | Long | Metric | VideoViews column for table Metrics |
ViewThroughConversions | Long | Metric | ViewThroughConversions column for table Metrics |
AdNetworkType | String | Segment | AdNetworkType column for table Segments |
ClickType | String | Segment | ClickType column for table Segments |
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 |
Device | String | Segment | Device 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 |
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