ClickView

A click view with metrics aggregated at each click level, including both valid and invalid clicks. For non-Search campaigns, metrics.clicks represents the number of valid and invalid interactions. Queries including ClickView must have a filter limiting the results to one day and can be requested for dates back to 90 days before the time of the request.

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.

Queries to ClickView must have a filter limiting the results to one day and can be requested for dates back to 90 days before the time of the request.\

SELECT * FROM ClickView WHERE Date DURING Yesterday

Columns

Name

Type

Behavior

Description

ClickViewAdGroupAd

String

Attribute

AdGroupAd column for table ClickView

ClickViewAreaOfInterestCity

String

Attribute

AreaOfInterestCity column for table ClickView

ClickViewAreaOfInterestCountry

String

Attribute

AreaOfInterestCountry column for table ClickView

ClickViewAreaOfInterestMetro

String

Attribute

AreaOfInterestMetro column for table ClickView

ClickViewAreaOfInterestMostSpecific

String

Attribute

AreaOfInterestMostSpecific column for table ClickView

ClickViewAreaOfInterestRegion

String

Attribute

AreaOfInterestRegion column for table ClickView

ClickViewCampaignLocationTarget

String

Attribute

CampaignLocationTarget column for table ClickView

ClickViewGclid

String

Attribute

Gclid column for table ClickView

ClickViewKeyword

String

Attribute

Keyword column for table ClickView

ClickViewKeywordInfoMatchType

String

Attribute

KeywordInfoMatchType column for table ClickView

ClickViewKeywordInfoText

String

Attribute

KeywordInfoText column for table ClickView

ClickViewLocationOfPresenceCity

String

Attribute

LocationOfPresenceCity column for table ClickView

ClickViewLocationOfPresenceCountry

String

Attribute

LocationOfPresenceCountry column for table ClickView

ClickViewLocationOfPresenceMetro

String

Attribute

LocationOfPresenceMetro column for table ClickView

ClickViewLocationOfPresenceMostSpecific

String

Attribute

LocationOfPresenceMostSpecific column for table ClickView

ClickViewLocationOfPresenceRegion

String

Attribute

LocationOfPresenceRegion column for table ClickView

ClickViewPageNumber

Long

Attribute

PageNumber column for table ClickView

ClickViewResourceName

String

Attribute

ResourceName column for table ClickView

ClickViewUserList

String

Attribute

UserList column for table ClickView

CustomerId

Long

Attribute

ClientCustomerId column for table ClickView

Clicks

Long

Metric

Clicks column for table Metrics

AdNetworkType

String

Segment

AdNetworkType column for table Segments

ClickType

String

Segment

ClickType column for table Segments

Date

Date

Segment

Date column for table Segments

Device

String

Segment

Device column for table Segments

MonthOfYear

String

Segment

MonthOfYear column for table Segments

Slot

String

Segment

Slot 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