The AdWords API is no longer available. Use the Google Ads API instead.

Paid Organic Query Report

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 presence, and gives insight into how your paid and organic search listings work together to connect your business with people searching on Google.

 Attribute

 Segment

 Metric

Ctr

Download this table in CSV format

PAID_ORGANIC_QUERY_REPORT

AccountCurrencyCode

The currency of the Customer account.

TypeString
Display NameCurrency
XML Attributecurrency
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AccountDescriptiveName

The descriptive name of the Customer account.

TypeString
Display NameAccount
XML Attributeaccount
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AccountTimeZone

Name of the timezone selected for the Customer account. For example: "(GMT-05:00) Eastern Time". This field does not reflect the current state of daylight saving time for the timezone.

TypeString
Display NameTime zone
XML AttributetimeZone
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupId

The ID of the AdGroup.

TypeLong
Display NameAd group ID
XML AttributeadGroupID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupName

The name of the AdGroup.

TypeString
Display NameAd group
XML AttributeadGroup
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AdGroupStatus

Status of the ad group.

TypeAdGroupStatus
Display NameAd group state
XML AttributeadGroupState
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

AverageCpc

The total cost of all clicks divided by the total number of clicks received. Values can be one of: a) a money amount in micros, b) "auto: x" or "auto" if this field is a bid and Google Ads is automatically setting the bid via the chosen bidding strategy, or c) "--" if this field is a bid and no bid applies to the row.

TypeMoney
Display NameAd Avg. CPC
XML AttributeadAvgCPC
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

AveragePosition

Your ad's position relative to those of other advertisers. To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameAd Avg. position
XML AttributeadAvgPosition
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CampaignId

The ID of the Campaign.

TypeLong
Display NameCampaign ID
XML AttributecampaignID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CampaignName

The name of the Campaign.

TypeString
Display NameCampaign
XML Attributecampaign
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

CampaignStatus

The status of the Campaign.

TypeCampaignStatus
Display NameCampaign state
XML AttributecampaignState
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Clicks

The number of clicks.

TypeLong
Display NameAd Clicks
XML AttributeadClicks
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CombinedAdsOrganicClicks

Clicks from ads or organic search results.

TypeLong
Display NameCombined Clicks
XML AttributecombinedClicks
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CombinedAdsOrganicClicksPerQuery

CombinedAdsOrganicClicks divided by CombinedAdsOrganicQueries. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameCombined Clicks/Query
XML AttributecombinedClicksQuery
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CombinedAdsOrganicQueries

Total number of searches that returned pages from your site in the organic search results or triggered one of your ads.

TypeLong
Display NameCombined Queries
XML AttributecombinedQueries
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

Ctr

The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Percentage returned as "x.xx%". To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameAd CTR
XML AttributeadCTR
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

CustomerDescriptiveName

The descriptive name of the Customer.

TypeString
Display NameClient name
XML AttributeclientName
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Date

The date formatted as yyyy-MM-dd.

TypeDate
Display NameDay
XML Attributeday
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

DayOfWeek

The name of the day of the week, e.g., "Monday".

TypeDayOfWeek
Display NameDay of week
XML AttributedayOfWeek
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

ExternalCustomerId

The Customer ID.

TypeLong
Display NameCustomer ID
XML AttributecustomerID
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Impressions

Count of how often your ad has appeared on a search results page or website on the Google Network.

TypeLong
Display NameAd Impressions
XML AttributeadImpressions
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

KeywordId

The ID of the Keyword that triggered the ad.

Typelong
Display NameKeyword ID
XML AttributekeywordID
BehaviorAttribute
FilterableFalse
Supports Zero ImpressionsFalse

KeywordTextMatchingQuery

Keyword that matched the query and triggered the ad.

TypeString
Display NameKeyword
XML Attributekeyword
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

Month

The first day of the month, formatted as yyyy-MM-dd.

TypeString
Display NameMonth
XML Attributemonth
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

MonthOfYear

The name of the month of the year, e.g., "December".

TypeMonthOfYear
Display NameMonth of Year
XML AttributemonthOfYear
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

OrganicAveragePosition

Average top position of your organic listing (or multiple listings) for each query. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameOrganic Average Position
XML AttributeorganicAveragePosition
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

OrganicClicks

Number of times someone clicked your site's listing in the unpaid results for a particular query.

TypeLong
Display NameOrganic Clicks
XML AttributeorganicClicks
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

OrganicClicksPerQuery

Number of clicks you've received on your organic search listings divided by the total number of searches that returned pages from your site. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameOrganic Clicks/Query
XML AttributeorganicClicksQuery
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

OrganicImpressions

Number of organic search listing impressions.

TypeLong
Display NameOrganic Listings
XML AttributeorganicListings
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

OrganicImpressionsPerQuery

Average number of times a page from your site was listed per query. This field is formatted with dot (".") for decimal separator, precision of two decimal positions and no thousands separator (e.g. 1000000.00). To prevent calculation accuracy issues, fields whose data type is Double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN. This is also true for AWQL: Only the operators < and > are allowed in the WHERE clause.

TypeDouble
Display NameOrganic Listings/Query
XML AttributeorganicListingsQuery
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

OrganicQueries

Total number of searches that returned organic search results for your site over the given period.

TypeLong
Display NameOrganic Queries
XML AttributeorganicQueries
BehaviorMetric
FilterableTrue
Supports Zero ImpressionsFalse

Quarter

The first day of the quarter, formatted as yyyy-MM-dd. Uses the calendar year for quarters, e.g., the second quarter of 2014 starts on 2014-04-01.

TypeString
Display NameQuarter
XML Attributequarter
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

QueryMatchType

Match type of the keyword that triggered the ad.

TypeQueryMatchType
Display NameMatch type
XML AttributematchType
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

SearchQuery

Query that led to the impression.

TypeString
Display NameQuery
XML Attributequery
BehaviorAttribute
FilterableTrue
Supports Zero ImpressionsFalse

SerpType

The type of search result.

TypeSerpType
Display NameSearch Result Type
XML AttributesearchResultType
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

Week

The date for the Monday of the week, formatted as yyyy-MM-dd.

TypeString
Display NameWeek
XML Attributeweek
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse

Year

The year, formatted as yyyy.

TypeInteger
Display NameYear
XML Attributeyear
BehaviorSegment
FilterableTrue
Supports Zero ImpressionsFalse