DisplayKeywordView

A display keyword 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

DisplayKeywordViewResourceName

String

Attribute

ResourceName column for table DisplayKeywordView

CustomerId

Long

Attribute

ClientCustomerId column for table DisplayKeywordView

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