PROGRAM ZERO 18-month live AI, LLM & full-stack programme · ₹89,999 or ₹7,500/month · Starts 9 January 2027
Explore Program Zero →
Careers Ninza — business and startup leadership training
JOIN ZERO NINZA KIDS
JOIN ZERO NINZA KIDS
See all programs → Free live masterclass → Guides & articles → Newsletter →
Careers Ninza
PERFORMANCE MARKETING 6 min read · Updated 8 November 2026

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.

CN
Careers Ninza performance marketing faculty
Careers Ninza · Kolkata, India
Learn this live in our Performance Marketing & Growth Hacking course

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?

MetricWhySource
Revenue or qualified leadsBusiness outcomeStore, CRM
New customersGrowth, not just repeat salesStore, CRM
Total marketing spendAll channels togetherAd platforms, invoices
MER (revenue ÷ total spend)Blended efficiencyCalculated
New customer CACAcquisition costCalculated
Conversion rate (site)Funnel healthGA4
Trend vs last period and last yearContextAll

Channel and campaign details go on later pages. The first page is for decisions, not exploration.

How do you connect the data sources?

—GA4 and Google Ads: native Looker Studio connectors.
—Search Console: native connector for organic visibility.
—Meta Ads: through a third-party connector or by exporting data into Google Sheets on a schedule.
—Sales and CRM: from Shopify, WooCommerce or CRM exports into Google Sheets or BigQuery, or connectors where available.
—Costs not in ad platforms: creator fees, agency fees in a simple sheet.

Google’s Looker Studio help centre lists connectors and data blending features.

How should the dashboard be laid out?

1Page 1, Overview: scorecards for revenue or leads, new customers, spend, MER and CAC, with comparisons; one trend chart.
2Page 2, Channels: spend, results and cost per result by channel, plus share of new customers.
3Page 3, Campaigns and creatives: top and bottom performers.
4Page 4, Funnel: sessions, product views, add to cart, checkout, purchase or lead stages.
5Page 5, Data health: event counts vs orders, missing data warnings.

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.

Illustration: weekly MER for a sample brand
Week 13.4
Week 23.1
Week 32.6
Week 43.2

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?

—Use the same date range controls on every page.
—Show comparisons (vs previous period, vs last year) next to every key number.
—Use consistent colours for channels across pages.
—Label metrics in plain language with definitions in a notes box.
—Keep it fast: fewer, well-chosen charts load better than many.

What mistakes do teams make?

—Leading with impressions, clicks and followers instead of business outcomes.
—Mixing currencies or time zones (set INR and Asia/Kolkata everywhere).
—Inconsistent UTM naming that splits channels.
—No data-health page, so broken tracking goes unnoticed.
—Building once and never reviewing whether people use it.

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:

ScorecardSource
Total leads and qualified leadsCRM
Cost per qualified leadAd spend ÷ qualified leads
Counselling sessions or site visitsCRM
Enrolments or bookingsCRM
Cost per enrolment or bookingCalculated
Median time to first contactCRM

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?

—Schedule exports from platforms and CRM daily into Google Sheets or BigQuery.
—Use one date column format and one time zone (Asia/Kolkata) everywhere.
—Add a "last updated" field on the overview page.
—Create alerts or a data-health page that flags missing days or sudden drops in event counts.
—Document every metric definition so everyone reads the numbers the same way.

How should dashboards be used in meetings?

1Open the overview: are outcomes and efficiency on track versus last week and last year?
2If not, drill into channels to find where the change happened.
3Then campaigns and creatives to find the cause.
4Agree actions with owners and deadlines; record them in the notes box on the dashboard.

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

—Lead with business outcomes: revenue or qualified leads, new customers, spend and CAC.
—Use store or CRM data for totals and never sum platform revenue.
—Put channels, campaigns, funnel and data health on later pages.
—Use consistent UTMs, INR and Asia/Kolkata time across sources.
—Show comparisons with the previous period and last year on every key number.
—Use the dashboard in a short weekly decision meeting.

What to do this week

1Write the five numbers your founder or manager asks about most; they become the overview page.
2Connect GA4 and Google Ads natively, and set up a scheduled sheet for Meta and CRM data.
3Agree one UTM naming document and share it with everyone who creates links.
4Build only the overview page first and use it in a weekly meeting for a month.
5Add channel and funnel pages when a real question needs them.

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.

LONG-TERM PROGRAM · LIVE ONLINE
Performance Marketing & Growth Hacking

Own the growth number — acquisition, experiments and CAC discipline.

₹24,999 paid in full · EMI ₹15,000 × 230 hoursLive, mentor-ledCertificate on completion

Frequently asked questions

What should a marketing dashboard include?+

Business outcomes such as revenue or qualified leads, new customers, total spend, blended efficiency (MER), new customer CAC, conversion rate and trends, with channel and campaign details on later pages.

Is Looker Studio free?+

Looker Studio is free to use with native connectors for Google products such as GA4, Google Ads and Search Console. Some third-party connectors for other platforms, such as Meta Ads, are paid.

How do I add Meta Ads data to Looker Studio?+

Use a third-party Looker Studio connector or export Meta Ads data on a schedule into Google Sheets or BigQuery, then connect that source.

What is MER in a marketing dashboard?+

MER, the marketing efficiency ratio, is total revenue divided by total marketing spend across all channels, showing overall efficiency without platform attribution overlap.

Should I sum ROAS from Meta and Google?+

No. Platform-reported revenue overlaps. Use store or CRM revenue for totals and compare platform metrics within each platform.

Where can I learn marketing dashboards and analytics?+

Careers Ninza Performance Marketing & Growth Hacking covers growth metrics, tracking, measurement and scaling diagnostics. 30 live hours, ₹24,999 paid in full or No-Cost EMI of ₹15,000 × 2.

Related reading

PERFORMANCE MARKETING Meta Ads Metrics Explained: How to Diagnose CPM, CTR, CPC and CPA Problems When cost per result rises, the cause is in one of a few places: auction cost (CPM), creative (CTR and hook rate), landing page (conversion rate) or tracking. This guide gives a diagnostic tree with Indian examples so you fix the right thing. 6 min read PERFORMANCE MARKETING Meta Ads for D2C Brands in India: From First Sale to Profitable Scale Most Indian D2C brands are built on Meta. This guide covers the stages: launch with tracking and creative, find first winners, build a creative engine, manage COD and RTO, protect margins and scale without losing profit. 6 min read PERFORMANCE MARKETING Google Ads for B2B Lead Generation in India: Manufacturers, Exporters and Service Firms B2B buyers search with precise, technical intent, but volumes are small and leads vary widely in quality. This guide covers keyword strategy, filtering out retail and job seekers, landing pages, CRM integration and measuring pipeline for Indian B2B advertisers. 6 min read

We teach this, live

Every article here comes from something we teach. Sit in on a free masterclass and judge the mentors yourself.