Paid Organic Query Report

The currency of the Customer account.

The descriptive name of the Customer account.

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.

The ID of the AdGroup.

The name of the AdGroup.

Status of the ad group.

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.

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.

The ID of the Campaign.

The name of the Campaign.

The status of the Campaign.

The number of clicks.

Clicks from ads or organic search results.

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.

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

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.

The descriptive name of the Customer.

The date formatted as yyyy-MM-dd.

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

The Customer ID.

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

The ID of the Keyword that triggered the ad.

Keyword that matched the query and triggered the ad.

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

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

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.

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

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.

Number of organic search listing impressions.

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.

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

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.

Match type of the keyword that triggered the ad.

Query that led to the impression.

The type of search result.

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

The year, formatted as yyyy.