PaidOrganicSearchTermView

A paid organic search term view providing a view of search stats across ads and organic listings aggregated by search term at the ad group level.

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
PaidOrganicSearchTermViewResourceName	String	Attribute	ResourceName column for table PaidOrganicSearchTermView
PaidOrganicSearchTermViewSearchTerm	String	Attribute	SearchTerm column for table PaidOrganicSearchTermView
CustomerId	Long	Attribute	ClientCustomerId column for table PaidOrganicSearchTermView
AverageCpc	Double	Metric	AverageCpc column for table Metrics
Clicks	Long	Metric	Clicks column for table Metrics
CombinedClicks	Long	Metric	CombinedClicks column for table Metrics
CombinedClicksPerQuery	Double	Metric	CombinedClicksPerQuery column for table Metrics
CombinedQueries	Long	Metric	CombinedQueries column for table Metrics
Ctr	Double	Metric	Ctr column for table Metrics
Impressions	Long	Metric	Impressions column for table Metrics
OrganicClicks	Long	Metric	OrganicClicks column for table Metrics
OrganicClicksPerQuery	Double	Metric	OrganicClicksPerQuery column for table Metrics
OrganicImpressions	Long	Metric	OrganicImpressions column for table Metrics
OrganicImpressionsPerQuery	Double	Metric	OrganicImpressionsPerQuery column for table Metrics
OrganicQueries	Long	Metric	OrganicQueries column for table Metrics
Date	Date	Segment	Date column for table Segments
DayOfWeek	String	Segment	DayOfWeek column for table Segments
Device	String	Segment	Device column for table Segments
KeywordAdGroupCriterion	String	Segment	KeywordAdGroupCriterion column for table Segments
KeywordInfoMatchType	String	Segment	KeywordInfoMatchType column for table Segments
KeywordInfoText	String	Segment	KeywordInfoText 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
SearchEngineResultsPageType	String	Segment	SearchEngineResultsPageType 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.