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
Setup is quick and easy. Most templates are ready in less than 5 minutes, depending on the complexity of the report and the number of data sources you need to connect.
Each template includes a step-by-step guide integrated directly into the report. Simply open the template you want to use and follow the detailed instructions to complete the setup. Our system will guide you through each stage of the process.
Absolutely. Once you set up a template, it's completely yours. You can modify, adapt, and customize it according to the specific needs of each client or project without any restrictions.
No. All our templates are 100% free and available to any Detrics user, even if you don't have a paid subscription.