PaidOrganicQuery

The Paid and Organic Query report provides a holistic view of your search stats across ads and organic listings at the query level. This lets you analyze strengths and gaps in your overall search pres

Table Specific Information

Select

Google AdWords 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 AdWords 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 AdWords API.

Columns

Name	Type	Behavior	DisplayName	Description
AccountCurrencyCode	String	Attribute	Currency	Currency for the PaidOrganicQuery report.
AccountDescriptiveName	String	Attribute	Account	Account for the PaidOrganicQuery report.
AccountTimeZone	String	Attribute	Time Zone	Time Zone for the PaidOrganicQuery report.
AdGroupId	Long	Attribute	Ad Group ID	Ad Group ID for the PaidOrganicQuery report.
AdGroupName	String	Attribute	Ad Group	Ad Group for the PaidOrganicQuery report.
AdGroupStatus	String	Attribute	Ad Group State	Ad Group State for the PaidOrganicQuery report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CampaignId	Long	Attribute	Campaign ID	Campaign ID for the PaidOrganicQuery report.
CampaignName	String	Attribute	Campaign	Campaign for the PaidOrganicQuery report.
CampaignStatus	String	Attribute	Campaign State	Campaign State for the PaidOrganicQuery report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CustomerDescriptiveName	String	Attribute	Client Name	Client Name for the PaidOrganicQuery report.
ExternalCustomerId	Long	Attribute	Customer ID	Customer ID for the PaidOrganicQuery report.
KeywordId	Long	Attribute	Keyword ID	Keyword ID for the PaidOrganicQuery report.
KeywordTextMatchingQuery	String	Attribute	Keyword	Keyword for the PaidOrganicQuery report.
SearchQuery	String	Attribute	Query	Query for the PaidOrganicQuery report.
Date	Date	Segment	Day	Day for the PaidOrganicQuery report.
DayOfWeek	String	Segment	Day Of Week	Day Of Week for the PaidOrganicQuery report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
Month	String	Segment	Month	Month for the PaidOrganicQuery report.
MonthOfYear	String	Segment	Month Of Year	Month Of Year for the PaidOrganicQuery report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.
Quarter	String	Segment	Quarter	Quarter for the PaidOrganicQuery report.
QueryMatchType	String	Segment	Match Type	Match Type for the PaidOrganicQuery report. The allowed values are AUTO, BROAD, EXACT, EXPANDED, PHRASE.
SerpType	String	Segment	Search Result Type	Search Result Type for the PaidOrganicQuery report. The allowed values are UNKNOWN, ADS_ONLY, ORGANIC_ONLY, ADS_AND_ORGANIC.
Week	String	Segment	Week	Week for the PaidOrganicQuery report.
Year	Integer	Segment	Year	Year for the PaidOrganicQuery report.
AverageCpc	Decimal	Metric	Ad Avg CPC	Ad Avg CPC for the PaidOrganicQuery report.
AveragePosition	Double	Metric	Ad Avg Position	Ad Avg Position for the PaidOrganicQuery report.
Clicks	Long	Metric	Ad Clicks	Ad Clicks for the PaidOrganicQuery report.
CombinedAdsOrganicClicks	Long	Metric	Combined Clicks	Combined Clicks for the PaidOrganicQuery report.
CombinedAdsOrganicClicksPerQuery	Double	Metric	Combined Clicks Per Query	Combined Clicks Per Query for the PaidOrganicQuery report.
CombinedAdsOrganicQueries	Long	Metric	Combined Queries	Combined Queries for the PaidOrganicQuery report.
Ctr	Double	Metric	Ad CTR	Ad CTR for the PaidOrganicQuery report.
Impressions	Long	Metric	Ad Impressions	Ad Impressions for the PaidOrganicQuery report.
OrganicAveragePosition	Double	Metric	Organic Average Position	Organic Average Position for the PaidOrganicQuery report.
OrganicClicks	Long	Metric	Organic Clicks	Organic Clicks for the PaidOrganicQuery report.
OrganicClicksPerQuery	Double	Metric	Organic Clicks Per Query	Organic Clicks Per Query for the PaidOrganicQuery report.
OrganicImpressions	Long	Metric	Organic Listings	Organic Listings for the PaidOrganicQuery report.
OrganicImpressionsPerQuery	Double	Metric	Organic Listings Per Query	Organic Listings Per Query for the PaidOrganicQuery report.
OrganicQueries	Long	Metric	Organic Queries	Organic Queries for the PaidOrganicQuery report.

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
StartDate	String	Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
EndDate	String	End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.