Video
A video.
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 |
VideoChannelId | String | Attribute | ChannelId column for table Video |
VideoDurationMillis | Long | Attribute | DurationMillis column for table Video |
VideoId | String | Attribute | Id column for table Video |
VideoResourceName | String | Attribute | ResourceName column for table Video |
VideoTitle | String | Attribute | Title column for table Video |
CustomerId | Long | Attribute | ClientCustomerId column for table Video |
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 |
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 |
ConversionsFromInteractionsValuePerInteraction | Double | Metric | ConversionsFromInteractionsValuePerInteraction column for table Metrics |
ConversionsValue | Double | Metric | ConversionsValue column for table Metrics |
ConversionsValuePerCost | Double | Metric | ConversionsValuePerCost 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 |
Impressions | Long | Metric | Impressions 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