Report Type: paidAndOrganic

The paidAndOrganic report shows the search terms that either triggered your ads to appear on Google, triggered Google to display unpaid (organic) search results for your site, or both. The report only returns results if you have already set up the Paid and Organic report for the engine account you are reporting on.

This report can only be returned by an asynchronous request (that is, via the Reports.request() method).

Request excerpt

Send a regular Reports.request() request body, but specify "reportType": "paidAndOrganic". 

{
...
  "reportType": "paidAndOrganic",
  "columns": [
    {
      "columnName": string,
      "headerText": string,
      "startDate": string,
      "endDate": string
    }
  ],
  "filters": [
    {
      "column": {
        "columnName": string,
      },
      ...
    },
    ...
  ],
...
}

For each column that you want returned or filtered in the report, specify the columnName listed in the table below. You can also optionally specify headerText, startDate, and endDate. Note that some columns cannot be filtered; refer to "Filterable" in the table below.

columnNameDescriptionBehaviorTypeFilterable
agency Agency name. attribute String Yes
agencyId DS agency ID. attribute ID Yes
advertiser Advertiser name. attribute String Yes
advertiserId DS advertiser ID. attribute ID Yes
account Engine account name. attribute String Yes
accountId DS engine account ID. attribute ID Yes
accountEngineId ID of the account in the external engine account. attribute String Yes
accountType Engine account type: Google AdWords, Bing Ads, Yahoo Japan Listing Ads, Yahoo Search Marketing, Yahoo Gemini, Baidu, or Comparison Shopping. attribute Engine type Yes
searchQuery The search terms that Google users entered. attribute String Yes
serpType

The type of search result that Google users clicked.

Possible values are:

  • Organic only: Users who entered this query only clicked unpaid search results.
  • Paid only: Users who entered this query only clicked ads.
  • Paid and Organic: Some users who entered this query clicked unpaid search results while others clicked ads (and some may have clicked both).
 attribute SERP type Yes
paidClicks The number of times someone clicked an ad after entering the searchQuery. metric Integer Yes
organicClicks The number of clicks on unpaid search results for your site after someone entered the searchQuery. metric Integer Yes
paidAndOrganicClicks The number of clicks on either one of your ads ad or an unpaid search result for your site after someone entered the searchQuery. metric Integer Yes
paidImpressions The number of times an ad has appeared on a search results page or on a website in the Google Network after someone entered the searchQuery. metric Integer Yes
organicQueries The total number of times users have entered the searchQuery and saw at least one organic search result from your site. metric Integer Yes
paidAndOrganicQueries The total number of times users have entered the searchQuery and saw at least one of your ads or at least one organic search result from your site. metric Integer Yes
paidCtr The click-through rate for an ad, which is how often people who see your ad end up clicking it after entering the searchQuery. metric Number Yes
organicCtr The rate at which people who see unpaid search results for your site end up clicking an unpaid result and landing on your site. metric Number Yes
paidAndOrganicCtr The rate at which people who see either one of your ads or an unpaid search result for your site end up clicking on either and landing on your site. metric Number Yes
paidAvgPos The average position in which the ad appears after someone entered the searchQuery. metric Number Yes
organicAvgPos The average top position of unpaid search results for your site. metric Number Yes
paidCostPerClick The average cost per click for an ad. This is the average amount you pay each time someone clicks your ad. metric Money Yes
date Segments the report by days; each row and its aggregate metrics are split into multiple rows, one for each day. This column returns the date of each row. segment Date Yes
monthStart Segments the report by months; each row and its aggregate metrics are split into multiple rows, one for each month. This column returns the first day of the month of each row. segment Date Yes
monthEnd Segments the report by months; each row and its aggregate metrics are split into multiple rows, one for each month. This column returns the last day of the month of each row. segment Date Yes
quarterStart Segments the report by quarters; each row and its aggregate metrics are split into multiple rows, one for each quarter. This column returns the first day of the quarter of each row. segment Date Yes
quarterEnd Segments the report by quarters; each row and its aggregate metrics are split into multiple rows, one for each quarter. This column returns the last day of the quarter of each row. segment Date Yes
weekStart Segments the report by weeks (Sunday to Saturday); each row and its aggregate metrics are split into multiple rows, one for each week. This column returns the first day (Sunday) of each row. segment Date Yes
weekEnd Segments the report by weeks (Sunday to Saturday); each row and its aggregate metrics are split into multiple rows, one for each week. This column returns the last day (Saturday) of each row. segment Date Yes
yearStart Segments the report by years; each row and its aggregate metrics are split into multiple rows, one for each year. This column returns the first day of the year of each row. segment Date Yes
yearEnd Segments the report by years; each row and its aggregate metrics are split into multiple rows, one for each year. This column returns the last day of the year of each row. segment Date Yes
campaign Segments the report by campaign; each row and its aggregate metrics are split into multiple rows, one for each campaign in the report scope. This column returns the campaign name. segment String Yes
campaignId Segments the report by campaign; each row and its aggregate metrics are split into multiple rows, one for each campaign in the report scope. This column returns the DS campaign ID. segment ID Yes
adGroup Segments the report by ad group; each row and its aggregate metrics are split into multiple rows, one for each ad group in the report scope. This column returns the ad group name. segment String Yes
adGroupId Segments the report by ad group; each row and its aggregate metrics are split into multiple rows, one for each ad group in the report scope. This column returns the DS ad group ID. segment ID Yes
keywordId Segments the report by keyword; each row and its aggregate metrics are split into multiple rows, one for each keyword in the report scope. This column returns the DS keyword ID. segment ID Yes
keywordMatchType Segments the report by keyword; each row and its aggregate metrics are split into multiple rows, one for each keyword in the report scope. This column returns the keyword match type. segment Match type Yes
keywordText Segments the report by keyword; each row and its aggregate metrics are split into multiple rows, one for each keyword in the report scope. This column returns the keyword text. segment String Yes