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.
columnName
Description
Behavior
Type
Filterable
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
