Posts tagged with google-bigquery

I'm trying to upload all customer data from BigQuery into Google Ads to improve our customer match on audiences.

I was able to make the integration, but for some reason I'm getting an unknown error and no data is being pulled.

Runs results

Error Details or lack of ...

This is the data we are sending, we have followed the requested format and not doing any data transformation to avoid weird issues.

I'm a bit lost on what else I should be checking on this - and I felt like google ads gives more instructions on how to upload CSV data rather than how to automate with BigQuery.

Anyone been through this or has any ideas?

Field Mapping

Thanks in advance :)

I have a bigquery google ads datatransfer, I'm only interested in the products table.

Each day I only get 22 000 products, google ads dashboard would show me way more (*10).

I know products without performances (no impressions / no clicks) are not transfered. But still, I'm lacking too much lines.

If anybody knows what could cause this ? Thanks a lot in advance

I tried to compare the products with performances on the google ads dashboard with those in my bigquery datatransfers, the two don't add up

I have a BigQuery export set up for my Google account, and colleagues working on this account sometimes do name edits on campaigns, ad groups and so on.

Issue is, those changes get recorded in BigQuery as new rows, under the same asset ID:

This messes my reports up, as campaign metrics like Impressions are being duplicated in tools like Power BI:

I am not sure what the best approach would be here, so I'd gladly accept your support on this matter.

I am creating bigquery data transfer service for google ads data. the data transfer service was created successfully. while retrieving the data the transfer service is getting failed with below error.

generic::permission_denied: Error while processing subtask:  The caller does not have permission Raw error response from Google Ads API: { "error": { "code": 403, "message": "The caller does not have permission", "errors": [ { "message": "The caller does not have permission", "domain": "global", "reason": "forbidden", "debugInfo": "detail: \"[ORIGINAL ERROR] generic::permission_denied: User doesn\\'t have permission to access customer. Note: If you\\'re accessing a client customer, the manager\\'s customer id must be set in the \\'login-customer-id\\' header. See https://developers.google.com/google- 

I checked the google documentation the user should have permissions in google ads and GCP as well

in my case both of them are different user,for example my email id in GCP is different and my email id in google ads is different.

once i setup the transfer service i updated the credentials with update credentials option. which mean i authorized retransfer using the email id which has access to google ads.

the update credentials step was success didn't throw any error,

even after this my data transfer is failing with same error.

is it not at possible use different user to authorize google ads data transfer?

how can i solve this problem.