Building a marketing data warehouse from scratch

How can you combine Google Big Query’s builtin data transfers like Google Ads, Shopping, Analytics 4 and other data to build powerful analyses? When should you use custom ingestion pipelines vs data loader tools like Fivetran to integrate data sources? Which mistakes should you avoid at the beginning? How can you build your team’s SQL skills in an interactive way? Christopher will share some highlights and key learnings from his two-year journey at Bergzeit and share many practical tips, tools and code to test. Even though some data engineering work is needed, the key goal is to enable your team and maximize the time for analysis and insights, while keeping costs low. Data lifecycle topics like reporting, version control, observability and security will also be discussed. We hope that with this talk, you’ll finally be psyched to start collecting your own first party data in one place!