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