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:
|
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 |