Use case 03
A warehouse in dbt across the platforms
Ads, analytics, the shop, and the CRM land in one warehouse, and dbt turns them into one customer and one order.
The situation
Google Ads, Meta, GA4, the shop, and the CRM each kept their own export. The weekly meeting started from four different revenue numbers, and nobody could say which one the business should use.
What we implement
Each export lands as it arrives. dbt cleans those landings into one customer, one order, and one channel. Marketing, finance, and operations read the same models. The interactive warehouse on this site is the picture of that stack: sources as they arrive, a cleaned layer, and the models teams share.
The result
The platforms stay where the media team works. The number the company reports comes from the warehouse, with one definition for the customer and the order.