Building a marketing dashboard in Looker Studio: one view for GA4, ads and sales
A good marketing dashboard shows a founder in two minutes whether marketing is working. This guide covers which metrics to include, connecting GA4, Google Ads, Meta and sales data in Looker Studio, layout, blended metrics and common mistakes.
A marketing dashboard should answer three questions at a glance: are we acquiring customers efficiently, which channels and campaigns drive it, and is anything breaking? Build it in Looker Studio with GA4 and Google Ads (native connectors), Meta and sales data (through connectors or sheets), and lead with business metrics such as revenue, new customers and blended cost per customer.
Most dashboards fail because they show everything: forty charts, no story. Module one and module nine of Performance Marketing & Growth Hacking cover the numbers that matter and how to diagnose them; this guide turns those into a dashboard.
Which metrics belong on the first page?
Channel and campaign details go on later pages. The first page is for decisions, not exploration.
How do you connect the data sources?
Google’s Looker Studio help centre lists connectors and data blending features.
How should the dashboard be laid out?
How do you calculate blended metrics?
Blend spend from all platforms with revenue from your store or CRM in Looker Studio using data blending on date, or prepare a combined daily table in Google Sheets or BigQuery. Calculate MER as revenue divided by total spend, and new customer CAC as total acquisition spend divided by new customers. Use the business source of truth (store or CRM) for revenue rather than platform-reported revenue.
Never add up platform-reported revenue across Meta and Google; they overlap. Use store or CRM revenue for totals, and platform numbers for comparisons within each platform. Our attribution guide explains why.
Source: Careers Ninza classroom dashboard example; illustrative. A dip like week 3 is a prompt to check creative fatigue, tracking or stock.
Which design choices make dashboards useful?
What mistakes do teams make?
What are the limits?
A dashboard shows what happened, not why. Pair it with a weekly review where someone explains changes and decides actions. And it is only as good as its data: invest in tracking and consistent naming before polishing charts.
What does a dashboard for a lead-generation business look like?
For a coaching institute or real estate developer, the outcome is not revenue on the website but leads that progress in a CRM. The overview page changes accordingly:
A channel page then shows these by source (Google search, Meta lead ads, click-to-WhatsApp, organic, referrals), which is where budget decisions get made. Most lead businesses discover that the cheapest leads are not the cheapest enrolments.
How do you keep the data fresh and reliable?
How should dashboards be used in meetings?
A dashboard that drives a 20-minute weekly decision meeting is worth far more than a beautiful one nobody opens. Start simple, use it every week, and add pages only when a real question needs them.
KEY TAKEAWAYS
What to do this week
Our Performance Marketing & Growth Hacking batches run live online, so the same class reaches learners and business owners in metros such as Kolkata, Mumbai, Delhi NCR, Bengaluru and Hyderabad, growing cities such as Surat, Jaipur, Indore, Lucknow and Coimbatore, and smaller industrial towns such as Siliguri, Durgapur, Tiruppur, Rajkot and Guwahati, at the same fee. Each city page explains how local businesses use marketing analytics, for example in Kolkata, Surat, Tiruppur.
Learn this live: Performance Marketing & Growth Hacking
Learn the numbers that govern growth, build tracking and dashboards, and run a live-budget capstone. 30 live hours, ₹24,999 paid in full or ₹30,000 as No-Cost EMI of ₹15,000 × 2.
Own the growth number — acquisition, experiments and CAC discipline.
Frequently asked questions
Related reading
We teach this, live
Every article here comes from something we teach. Sit in on a free masterclass and judge the mentors yourself.