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: https://www.datadice.io/
Playlist: https://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): https://bit.ly/3trJPRr
LinkedIn (stay informed about most important company news): https://bit.ly/3qqJKeX
Udemy (Course about Essentials of BigQuery and Data Studio and building an own DWH): https://bit.ly/3tIMIxB
BIG Thanks to Hub633 for the video recording support. https://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