BigQuery 🔀 Google Ads Transfer: Everything you need to know!

„It’s definitely not the day you want to have…“
Thomas and Alex are talking about the transfer from Google Ads to #BigQuery. The big amount of tables and views, the secret behind the refresh window and that we always have to check how to set the correct backfill date range are topics we cover in this video.
-----
Important #Google #Ads tables:
dataset.AdStats_1234567890
dataset.Ad_1234567890
dataset.AdGroup_1234567890
dataset.Campaign_1234567890
-----
Company Website: www.datadice.io/
Playlist: bit.ly/3oqBt9n
Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): bit.ly/3trJPRr
LinkedIn (stay informed about most important company news): bit.ly/3qqJKeX
Udemy (Course about Essentials of BigQuery and Data Studio and building an own DWH): bit.ly/3tIMIxB
BIG Thanks to Hub633 for the video recording support. bit.ly/3I0QXry
Video Content:
00:00 Introduction
01:36 Transfer Google Ads data to BigQuery
02:15 Set the correct refresh time
04:10 What is the refresh window
06:06 Other Transfer Settings
07:38 Structure of the raw data
09:05 Backfill data
12:46 Missing Campaigns in Transfer?
15:07 Conclusion

[@yuritemiraev2759]

Thank you!

[@JuanSagua]

I receive this message when I try to transfer: "Billing is disabled for this project. Please ask the project owner to enable it."
How much money does it cost?

[@datadice]

Hi @JuanSagua
To initiate the transfer, you must add payment information (e.g., credit card) to your GCP (Google Cloud Platform) project. To do this, navigate to GCP, click on the "Hamburger button" located in the top left corner, and then scroll to "Billing". In the Billing section, you will be able to add your payment details.
Regarding Costs:
Although adding payment information is a prerequisite for this process, the transfer itself is free of charge. For further details, visit: console.cloud.google.com/marketplace/product/bigquery-data-connectors/google_ads.
Please note, while the transfer is free, querying data in BigQuery does incur costs. However, there are monthly and one-time free usage tiers. You can monitor your cloud expenses under the "Billing" menu at any time.
Greetings Alex