Segmented Reports

The Search Ads 360 API returns only aggregated data unless you request more detailed, segmented data. For example, the clicks column in a keyword report lists the total number of clicks on a keyword during the time range you specify.

But if you request a keyword report that segments by quarter, for each keyword you'll see one row for each quarter, and the clicks column will list the quarterly totals.

Note that a segmented report returns a row only if data is available for a segment. For example, in a keyword report with the floodlightActivity column, a keyword and Floodlight activity pair will not appear in the report if there are no metrics attributed to it for the report date range.

Some segments are incompatible with specific columns

Some segments may cause specific columns to return invalid data. For example, segmenting by floodlightActivity is meaningful only if you include columns that report Floodlight data, such as dfaActions, dfaRevenue, dfaTransactions, and dfaWeightedActions. Other types of conversion columns (such as adWordsConversions), or columns that report engine metrics (such as clicks and impressions), don't contain data reported by Floodlight, so they return invalid values if you segment a report by floodlightActivity.

How to request a segmented report

To request a segmented report, include a column that lists segment as its behavior in the Types of Reports reference.

The following asynchronous request is for a keyword report segmented by quarter. The clicks column in each row will contain the total number of clicks for the quarter:

{
  "reportScope": {
    "agencyId": "20700000000000123", // Replace with your IDs
    "advertiserId": "2170000012345" // Replace with your IDs
  },
  "reportType": "keyword",

  "columns": [
     { "columnName": "campaignId" },
     { "columnName": "keywordText" },
     { "columnName": "keywordLandingPage" },

     { "columnName": "quarterStart" },
     { "columnName": "quarterEnd" },
     { "columnName": "clicks" },
  ]
  "timeRange" : {
    "startDate" : "2012-01-01",
    "endDate" : "2012-12-31"
  },
  "downloadFormat": "csv",
  "maxRowsPerFile": 5000000,
  "statisticsCurrency": "agency",
  "verifySingleTimeZone": false,
  "includeRemovedEntities": false
}