Saved Columns
Stay organized with collections
Save and categorize content based on your preferences.
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.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-28 UTC.
[null,null,["Last updated 2025-08-28 UTC."],[[["\u003cp\u003eThe new Search Ads 360 Reporting API offers increased flexibility for creating custom reports and integrating data.\u003c/p\u003e\n"],["\u003cp\u003eLeverage saved columns in the API to report on Floodlight activities, Google Analytics goals, or custom KPIs.\u003c/p\u003e\n"],["\u003cp\u003eRetrieve a list of saved columns using the \u003ccode\u003eSavedColumns.list()\u003c/code\u003e request and include them in report requests by referencing their \u003ccode\u003esavedColumnName\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eSaved columns are advertiser-specific and their names are case-sensitive, whitespace-sensitive, and punctuation-sensitive.\u003c/p\u003e\n"],["\u003cp\u003eIncremental reports have limitations with certain metrics and saved columns due to their dynamic nature.\u003c/p\u003e\n"]]],["The new Search Ads 360 Reporting API allows custom report building and data integration. Advertisers can create saved columns (Floodlight, Google Analytics, or formula) in the Search Ads 360 UI to report custom KPIs. To use these, send a `SavedColumns.list()` request to get a list of saved columns and their names. Include saved columns in report requests via the `savedColumnName` attribute. Saved columns are advertiser-specific, case-sensitive, and can be modified or removed. Incremental reports cannot contain unsupported metrics or saved columns.\n"],null,["# Saved Columns\n\nThe 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\nAPI](https://developers.google.com/search-ads/reporting/overview).\n\nTo report on Floodlight activities, Google Analytics goals, or custom\nKPIs, an advertiser can sign into Search Ads 360 UI and create one or\nmore **saved columns** , such as [Floodlight activity columns](https://support.google.com/searchads/answer/6051170), [Google Analytics activity columns](https://support.google.com/searchads/answer/6073934), or\n[formula columns](https://support.google.com/searchads/answer/6008636). You\ncan include a saved column in a report request either to download its data or to\n[filter a report](/search-ads/v2/how-tos/reporting/filtered-reports).\n\n### Get a list of saved columns\n\n\nTo see all of the saved columns that an advertiser has created, send a\n`\n`[SavedColumns.list()](/search-ads/v2/reference/savedColumns/list)`\n`\nrequest. The response includes the\n`\n`[savedColumnName](/search-ads/v2/reference/reports#request.columns.savedColumnName)`\n` for each of the advertiser's columns.\n\n### Request reports for saved columns\n\n\nTo include a saved column in a report request, add a column with the\n`savedColumnName` attribute set to the name of the column: \n\n```\n{\n \"reportType\": \"advertiser\",\n \"columns\": [\n {\n \"savedColumnName\": string,\n \"headerText\": string,\n }\n ],\n \"filters\": [\n {\n \"column\": {\n \"savedColumnName\": string,\n },\n ...\n },\n ...\n ],\n ...\n}\n```\n\n\nWhen using saved columns, keep in mind that:\n\n-\n Saved columns are defined at the advertiser level. If you are\n including a saved column in a request,\n [request.reportScope](/search-ads/v2/reference/reports#request.reportScope) must specify an advertiser or lower\n scope. Consequently, each report can include saved columns only for a\n single advertiser.\n\n-\n Saved column names are case sensitive, whitespace sensitive and\n punctuation sensitive. The\n [savedColumnName](/search-ads/v2/reference/reports#request.columns.savedColumnName) attribute needs to match the saved column name\n exactly. If the name of a saved column is identical to the name of\n another column in the same request, Search Ads 360 requires you to specify an\n alternate, unique [headerText](/search-ads/v2/reference/reports#request.columns.headerText) for one or both of the columns.\n\n-\n Saved columns can be modified or removed in the Search Ads 360 campaign management\n UI at any time; if a request that specifies saved columns fails, try\n removing the saved columns from the request and sending it again.\n\n-\n [Incremental reports](/search-ads/v2/how-tos/reporting/incremental-reports) cannot contain metrics that are not explicitly\n supported by the API (for example, Google Analytics activity columns). In\n addition, because Search Ads 360 users can redefine saved columns, incremental\n reports containing saved columns might not be accurate.\n\n\u003cbr /\u003e"]]
