Cost in table p_HourlyCampaignStats

[Yaniv nhm]

We used the Google API in order to automatically transfer data from AdWords directly to our BigQuery account. For some reason the Cost in table p_HourlyCampaignStats seems ridiculously high.

Please kindly assist how we can calculate it.

Thanks in advance.

[Dannison Yao (AdWords API Team)]

Hi Yaniv,

From the AdWords API report's perspective, it is possible that the amount you see is not yet converted from micros. You can follow this guide for further details. If this is not the case, can you send a screenshot of your report showing the Cost value via Reply privately to author so I can further investigate on this? 

Regards,

Dannison

AdWords API Team

[ya...@glidingdeer.com]

Hi Dannison,

After a discussion on the advertisers community: https://www.en.advertisercommunity.com/t5/AdWords-Tracking-and-Reporting/Costs-on-BigQuery-API-Table-CampaignStats/m-p/1725437#

I understand that I should have clarified myself better. Please note that we are using  the google-cloud's big-query data transfer-services, with the ad-account's report-data.

Again the problem is that the costs seem about 50% of the actual numbers we get from AdWrods.

Thanks again,

Yaniv

[Peter Oliquino (AdWords API Team)]

Hi Yaniv,

Thank you for providing more context about your concern. However, Big Query integration and any information related to it is not supported via the AdWords API, hence this is out of scope for us. I would recommend that you contact the Google Cloud Support team via this link instead for further assistance.

Best regards,
Peter
AdWords API Team