Documentation

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 two specific options in the “Extraction Template Settings”:

• Load Dynamic Metrics
• Google Search Ads 360 Custom Column ID

To enable custom columns in your extract, set "Load Dynamic Metrics" to "Yes" and input the required custom column IDs in the "Google Search Ads 360 Custom Column ID" field.

{%docs-informer info%}

if the Load Dynamic Metrics = ```True``` and Google Search Ads 360 Custom Column ID is empty only standard fields will be requested within the extraction.

{%docs-informer-end%}

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.