Google Ads data transfer in bigquery: missing or partial cost for demand gen campagn

[Giovanni Breccia]

Hi everyone,

I'm encountering discrepancies in cost data for Demand Gen campaigns between BigQuery and the Google Ads platform. When visualizing costs in Looker Studio using BigQuery data, the figures don’t match the values displayed directly in Google Ads.

Additionally, when exploring the tables in BigQuery, I noticed that for certain days or longer periods, the cost data for Demand Gen campaigns is completely missing—though clicks and impressions are present. This leads me to believe that the data might be corrupted.

I’ve checked the transfer configuration logs, and it shows that all data transfers to BigQuery were successful.

Has anyone else experienced this issue or know of any potential causes or solutions?

Thanks!

---

Le informazioni contenute nella presente e-mail e negli eventuali allegati, devono essere nella sola disponibilità del solo destinatario. Se avete ricevuto per errore questa e-mail siete pregati di informarci e di provvedere alla sua rimozione. Possono essere presenti informazioni riservate e non corrette (parzialmente o totalmente). Le e-mail in partenza e in arrivo possono essere oggetto di monitoraggio da parte di Omnigraf Italia Web Spec.Srl.  Del contenuto è responsabile il mittente della presente. Chiunque venga in possesso non autorizzato di questa e-mail è vincolato dalla Legge a non leggerne il contenuto, a non copiarla, a non diffonderla e a non usarla. La informiamo che per l'esercizio dei diritti di cui all'artt. 15-21 GDPR 679/16 può rivolgersi a Omnigraf Italia Web Spec. Srl.  per posta o per fax, indicando sulla busta o sul foglio "Inerente alla Privacy" o inviando una e-mail amministrazione@omnigrafitalia.it

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

To check further on your discrepancy and missing data issue, kindly get back to us with the complete API logs (request and response logs with request-id and request header) generated at your end when retrieving the data via the API so that we will check and get back to you. Also, kindly provide the uncropped Google Ads UI screenshot where you are observing the data mismatching with the “BigQuery” data as well as missing the data.

If you are using a client library and haven't enabled the logging yet, I would request that you enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

You can send the details via Reply privately to the author option or direct private reply to this email. 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vGaZ4:ref" (ADR-00269533)

Thanks,
 

Google Ads API Team

[Info Omnigraf Italia]

Hello,

I use the "data transfer" tool in Bigquery for the whole Manager Accounts (MCC)

Thanks

Giovanni Breccia ✆ +39 071732313 Int. 213 ✩ Web Analyst & SEO Specialist

[Google Ads API Forum Advisor]

Hi,

Please note that BigQuery Data Transfer related concerns are out of scope for our team. Hence, I would suggest you to contact the GCP Product support team by selecting the relevant option from this link. We can support only technical queries/concerns related to the Google Ads API.

[Info Omnigraf Italia]

Thank you, I will do that. 

Giovanni Breccia ✆ +39 071732313 Int. 213 ✩ Web Analyst & SEO Specialist