In this talk, Derek will look at BigQuery schemas for the native Search Console BigQuery export, GA4, and schemas with rank tracking data.
He will show how to blend that data by joining across datasets, getting more insights than each dataset can provide individually.
Derek will also show how to take advantage of BigQuery materialized views, and other ways to make queries run fast and cost-efficiently.