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.

Last updated