Google Search Ads 360 - Troubleshooting

While configuring your Google Search Ads 360 connection, you may encounter several issues. Understanding these common errors can help streamline the setup process and facilitate quick resolutions.

Permissions issue

‍If you only have access to the client account and do not have permissions for the manager or sub-manager accounts, labels, and other management data will not be extracted until the appropriate permissions are granted. You can learn more about this here.

Custom columns

How to enable custom columns for your report

Custom columns for Google Search Ads 360 are configured using the Google Search Ads 360 Custom Column ID option in the “Extraction Template Settings”:

To get the data from the custom columns, enter the required custom column IDs in the Google Search Ads 360 Custom Column ID field. Improvado will query the name of this column and you will see your custom column name in data table.

Data discrepancy in custom columns with the same naming

If you encounter missing data when importing columns that share identical names but have different IDs, this behavior is expected and reflects system design principles. To ensure data integrity, Improvado intentionally preserves platform-specific structures and does not merge or transform metrics during extraction. Identically named columns (even with different IDs) are treated as duplicates to mirror how platforms like Google Search Ads 360 handle reporting.

Solution

Set different names for different columns.

Custom columns issues

If you're getting the following error during the extraction process: The Custom Column ID selected in the Google Search Ads 360 custom settings does not comply with the API requirements..., It may appear in a few different cases:

Case 1. The custom columns specified in the referencedSystemColumns parameter may include segments or metrics that are not permitted for the report-type resource you are trying to extract data from.

If this occurs, the API will return an error message containing PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE, along with a list of custom columns that should be removed from the "Google Search Ads 360 Custom Column ID" setting.

Example of custom column:

{
  "resourceName": "customers/111111111/customColumns/12345",
  "id": "12345",
  "name": "Improvado - Imps (Lost to Budget)",
  "valueType": "DOUBLE",
  "referencesMetrics": true,
  "queryable": true,
  "referencedSystemColumns": [
    "metrics.impressions",
    "metrics.search_budget_lost_impression_share"
  ],
  "renderType": "NUMBER"
}

API error:

...
"errorCode": {
  "queryError": "PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE"
},
"message": "Cannot select or filter on the following metrics: 'custom_columns.id[12345]'(could not support requested resources: 'AD_GROUP_AD'), since metric is incompatible with the resource in the FROM clause or other selected segmenting resources."
...

Case 2. The custom columns failed due to an unknown API issue, the error message will look like this:

...
"errorCode": {
  "internalError": "INTERNAL_ERROR"
},
"message": "An internal error has occurred."
...

In such cases, please contact Improvado Support through the Improvado Service Desk for further assistance.

‍

Conversion Action cannot be combined with impressions, clicks or cost

If the extraction builder refuses a selection containing Conversion Action, Conversion Action Name or Conversion Action Category together with Impressions, Clicks or Cost, that is the Search Ads 360 API rejecting the combination, not an Improvado restriction.

Those three are conversion segments. Search Ads 360 allows them only alongside conversion and revenue metrics — conversions, all conversions, conversions value, revenue, orders, units sold, gross profit and the like. Delivery metrics such as impressions, clicks and cost are not selectable with them, because a single conversion cannot be attributed to a single impression in the way the report shape would imply.

Which of the three you can pick also depends on the report level. Campaign-level reports offer all three; the ad-level report offers only Conversion Action Name, because Search Ads 360 does not support the Conversion Action and Conversion Action Category segments at that level at all.

The practical pattern is two extractions rather than one:

• One report with the conversion segments and conversion metrics, giving conversions broken down by conversion action.
• One report with delivery metrics at the same entity and date grain, giving impressions, clicks and cost.

Join them on the entity and date columns they share. Do not expect the conversion totals to reconcile row for row against the delivery report: the segmented report repeats an entity once per conversion action, so its rows multiply while the delivery report does not.