Saved Columns

The new Search Ads 360 Reporting API is now available. The new API provides enhanced flexibility to build custom reports and integrate the data into your reporting applications and processes. Learn more about migrating to and using the new Search Ads 360 Reporting API.

To report on Floodlight activities, Google Analytics goals, or custom KPIs, an advertiser can sign into Search Ads 360 UI and create one or more saved columns, such as Floodlight activity columns, Google Analytics activity columns, or formula columns. You can include a saved column in a report request either to download its data or to filter a report.

Get a list of saved columns

To see all of the saved columns that an advertiser has created, send a SavedColumns.list() request. The response includes the savedColumnName for each of the advertiser's columns.

Request reports for saved columns

To include a saved column in a report request, add a column with the savedColumnName attribute set to the name of the column:

{
  "reportType": "advertiser",
  "columns": [
    {
      "savedColumnName": string,
      "headerText": string,
    }
  ],
  "filters": [
    {
      "column": {
        "savedColumnName": string,
      },
      ...
    },
    ...
  ],
  ...
}

When using saved columns, keep in mind that:

  • Saved columns are defined at the advertiser level. If you are including a saved column in a request, request.reportScope must specify an advertiser or lower scope. Consequently, each report can include saved columns only for a single advertiser.

  • Saved column names are case sensitive, whitespace sensitive and punctuation sensitive. The savedColumnName attribute needs to match the saved column name exactly. If the name of a saved column is identical to the name of another column in the same request, Search Ads 360 requires you to specify an alternate, unique headerText for one or both of the columns.

  • Saved columns can be modified or removed in the Search Ads 360 campaign management UI at any time; if a request that specifies saved columns fails, try removing the saved columns from the request and sending it again.

  • Incremental reports cannot contain metrics that are not explicitly supported by the API (for example, Google Analytics activity columns). In addition, because Search Ads 360 users can redefine saved columns, incremental reports containing saved columns might not be accurate.