We are using the Google Ads transfer in BigQuery to ingest our Google Ads data. One thing I have noticed when querying the results is that all of the metrics are exactly 156x of the values we would expect in the Google Ads UI (cost, clicks, etc.)

We have tested multiple transfers and each time we have this same issue. The transfer process seems pretty straight forward, but am I missing something? Has anyone else noticed a similar issue or have any ideas of what to look at to adjust in the data transfer?

So I'm trying to get raw google ads user data (including events, journeys etc), which i need to send to a Data-Warehouse.

Data From all my sources are send to Google Analytics & then to Data-Warehouse.

What i need is the RAW-Hit/Session level data that Google-Ads Monitor via Campaigns (from my account) to my Data-Warehouse directly, without any intermediate services.

Services like stitch-data does it directly, what all options do we have.

Thank you.

How to get an access to Google Ads Data Hub (ADH). https://developers.google.com/ads-data-hub

I am using a third-party tool that use the Adwords Reporting https://developers.google.com/adwords/api/docs/appendix/reports/all-reports to retrieve data.

At the moment all the "Performance Max" campaigns are lost from the Adwords Reporting and I need to retrieve them to include their costs. With the migration from Adwords to Ads, also, I need to find a solution before April 2022.

I only need to move that data into my Google BigQuery project.

At the moment the solution using the BigQuery Data Transfer is NOT OK because use the same v201809 reporting of Adwords ( https://cloud.google.com/bigquery-transfer/docs/adwords-transfer?hl=en-GB ) .

Also the Google Ads Script don't support Google Ads but only report name of Adwords v201809 ( https://developers.google.com/google-ads/scripts/docs/solutions/bigquery-exporter )

Do you have a suggestion to help me? Thanks

I have a Google Ads account which has a single Smart Campaign and multiple usual campaigns. Also I've set up a data transfer to Google BigQuery. When I try to compare BigQuery data using the query

SELECT sum(Cost) FROM `project.dataset.AccountBasicStats_XXXXXX`  where Date between '2021-12-01' and '2021-12-31' 

the query result shows a less cost than I see in the Google Ads interface for the same time period. The difference is equal to the spend of my smart campaign. To check this, I've tried the queries:

SELECT * FROM `project.dataset.CampaignBasicStats_XXXXXX`  where Date between '2021-12-01' and '2021-12-31' AND CampaignId = {ID of my smart campaign} SELECT * FROM `project.dataset.CampaignStats_XXXXXX`  where Date between '2021-12-01' and '2021-12-31' AND CampaignId = {ID of my smart campaign} 

The both give me no results.

Is it true that BigQuery data transfer discards the data of smart campaigns? What are other ways to get statistics for them?