Detrics Academy

12 chapters · 41 min of video

Build your marketing data warehouse with Claude

Full video tutorial: build a BigQuery data warehouse with all your ad-level data from Meta and TikTok Ads, historical and real-time, using Detrics and Claude via MCP. 12 step-by-step chapters.

1. 1. The problem: ad-level data
2. 2. The solution: warehouse, history and incremental deduplication
3. 3. A look at the final result in BigQuery
4. 4. Step one: connect Claude to Detrics via MCP
5. 5. Step two: explore the sources and design the data schema with Claude
6. 6. How the Detrics warehouse works
7. 7. The table groups created in Detrics
8. 8. Step three: create the destination in your own Google Cloud
9. 9. Step four: transfers and the historical load
10. 10. The data in BigQuery: tables, rows and creatives in your bucket
11. 11. Analyzing the data with Claude and the BigQuery MCP
12. 12. Final step: the unified Meta + TikTok view

6 chapters · 34 min of video

Build a marketing dashboard with Claude Code and BigQuery

Full video tutorial: unify Meta Ads, Google Ads, Pinterest and GA4 in BigQuery with Detrics, consolidate attribution via UTMs and build a web dashboard with Claude Code, deployed on Vercel.

1. 1. A look at the final dashboard
2. 2. Architecture and steps to build it
3. 3. Step one: connect data sources and destinations with Detrics
4. 4. Step two: create the tables and transfers to BigQuery
5. 5. Step three: consolidate the tables and build the dashboard with Claude Code
6. 6. Final step: deploy with Vercel