Digital Marketing Dashboard with BigQuery for Facebook Ads, Google Ads, Pinterest Ads and Google Analytics 4
Digital Marketing Dashboard with BigQuery
Watch the Full Tutorial
View on GitHub
For use with BigQuery
+40,000 marketers have downloaded our dashboards
About this template
This template includes: A live web dashboard reading from a master table in BigQuery, Detrics transfers for Meta Ads, Google Ads, Pinterest and GA4 (campaign performance), Overview with the main KPIs: spend, revenue, ROAS, purchases, CPA, CTR, CPC and CPM, Full conversion funnel from impressions to purchases, Channel analysis (Paid, Organic, Direct, AI Chats), Platform comparison and top 25 campaigns, A step-by-step video tutorial showing how to build it with Claude Code and deploy it on Vercel.
What you can do with this template:
Monitor paid performance across Meta Ads, Google Ads and Pinterest in one place
Track the full funnel from impressions to purchases and spot the biggest drop-offs
Compare ROAS, CPA and CPM across platforms to reallocate budget
Measure revenue by channel, including organic, direct and AI chats traffic
Identify your top campaigns by spend and return
Own your reporting stack: your data in BigQuery, your dashboard in your own code
Step-by-step video tutorial
FAQs
Frequently asked questions about templates
Most templates are ready in less than 5 minutes, depending on how complex the report is and how many data sources you need to connect.
Each template has a step-by-step guide built into the report. Open the one you want and follow the instructions to finish the setup.
Yes. Once you set up a template it's yours, and you can change it to fit each client or project with no restrictions.
No. All our templates are 100% free and available to any Detrics user, even if you don't have a paid subscription.