BigQuery SA360 Data Transfer Says Custom Columns Do Not Exist But They Do

[jdhassall]

I am trying to create an SA360 data transfer into BigQuery using the UI.

In the Custom Columns field I am using the following configuration.

```

[

{

"id": "123456789",

"destination_table_name": ["Conversion", "AdGroupConversionActionAndDeviceStats", "CampaignConversionActionAndDeviceStats" ],

"bigquery_column_name": "my_custom_col_name"

}

]

```

I recieve the error code 3: Custom column with id '123456789' does not exist.

Does anyone know what could be causing this issue?

[caryna]

Hi @jdhassall,

Welcome to Google Cloud Community!

The error you have encountered might be caused by the following: 

• Misconfigured or mismatched in the custom column fields: Check if your id actually exists in the SA360 account and verify that you are referencing the correct destination table.  Ensure the spellings are correct and there are no extra whitespaces.
• Insufficient Permissions: Ensure that your service account has the necessary permissions to access both SA360 and BigQuery.

If the issue persists, please contact Google Cloud Support. When reaching out, include detailed information and relevant screenshots of the errors you’ve encountered. This will assist them in diagnosing and resolving your issue more efficiently.

I hope the above information is helpful.

[jdhassall]

Hi Caryna, thanks for getting in touch. How can I check which table would be the correct destination table?

[caryna]

Hello @jdhassall,

I apologize for any confusion. In my previous response, I was only referring to your configured destination table if you configured it correctly. After re-checking on Search Ads 360 reports and Search Ads 360 data transfer documentation, your destination_table_name values appear to be spelled correctly. 

Have you tried to define your custom column id in SA360? As mentioned in the documentation, custom columns have to be owned by the Search Ads 360 account specified by the Customer ID in the transfer config, and the ID will only be assigned after the custom column is created. If this will not work, I recommend reaching out to SA360 Support for assistance to help you identify the correct ID, as well as the Google Cloud Support. Their team has specialized expertise in diagnosing underlying problems. 

I hope the above information is helpful.