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.