Meta Ads Dashboard in Looker Studio: Build One Free

1. Introduction

Quick Answer: This guide builds the artefact, not the theory. You will end up with a working Meta Ads Looker Studio dashboard on one screen, showing nine metrics a Malaysian business owner can act on, refreshed daily, shared by link, and free to run.

Most Malaysian SME owners already know which Facebook ad numbers matter. Our guide to which Facebook Ads metrics to track and which to ignore covers that list. What owners usually lack is somewhere to see those numbers without opening Ads Manager or waiting for someone to email a report.

That gap is what a Meta Ads Looker Studio dashboard closes. Looker Studio is Google's free reporting tool: it pulls your Meta Ads data in, draws the charts, and keeps the page live. We build one for every Meta Ads client as standard, because an owner who can check cost per lead on a Tuesday asks better questions than one reading a PDF three weeks later.

Before the build, here is a short walkthrough of the connector step — the one part of the process where people usually get stuck.

2. Why a Live Dashboard Beats the Monthly PDF

Quick Answer: A monthly PDF reports a period that has already closed, so every decision it triggers is at least four weeks late. A Meta Ads Looker Studio dashboard shows the same numbers while the budget is still being spent, which is the only window where changing something still matters.

The PDF is not wrong. It is just slow. By the time you read that cost per lead climbed in week two, weeks three and four have already been bought at the same price. Nobody set out to waste that money; the reporting cycle simply gave nobody a chance to stop it.

The second problem is quieter. A PDF is written by someone, and whoever builds it chooses which charts go in. That choice tends to flatter the work. A live dashboard shows the same fields every day regardless of how the month went — most of the reporting mistakes that make marketers look bad come from curated reports rather than dishonest ones.

What a Meta Ads Looker Studio dashboard actually changes:

• Timing. You see week two while week three is still buying, not after the invoice.
• Consistency. The same nine fields every time, so month-to-month comparisons are real comparisons.
• Access. A shared link works on a phone. A PDF sits in an email thread somebody has to find.
• Cost. Looker Studio itself is free, so the reporting line disappears from your quote.
• Neutrality. Nobody chooses which chart to include this month, because the layout is fixed.

This does not replace the strategy conversation. It replaces the fifteen minutes of that meeting spent reading numbers off a slide.

Key takeaway: The dashboard's real advantage is not prettier charts — it is seeing the number early enough to still do something about it.

3. The 9 Metrics an Owner Actually Needs

Quick Answer: Nine metrics carry almost every Meta Ads decision a Malaysian SME owner makes: spend, leads, cost per lead, purchases, cost per purchase, ROAS, link CTR, CPM and frequency. Everything else belongs to whoever manages the account day to day.

We tracked which metrics actually get raised in client review meetings. The pattern is consistent, and narrower than most reporting templates assume.

Share of Meta Ads client review meetings where each metric was raised, Malaysia.

Metric	Share of reviews	%
Cost per lead		94%
Leads or purchases		91%
Amount spent		88%
ROAS or revenue		67%
Cost per purchase		61%
Link CTR		44%
CPM		38%
Frequency		29%
Hook rate		21%

Source: ZenWeb client sample, Meta Ads accounts, 2024–2026. Licence.

Cost per lead sits at the top for a reason: it is the one number that converts straight into a decision about money. If you benchmark one field, benchmark that one against our Malaysian cost per lead figures by industry and our wider Facebook Ads cost benchmarks.

Frequency and hook rate sit at the bottom, and rightly so. They are diagnostic fields that explain why cost per lead moved. Keep them on the dashboard, but below the fold.

Key takeaway: Build for the five metrics that get raised in almost every review, and treat the other four as the explanation layer underneath them.

4. Your Connector Options and What Each One Limits

Quick Answer: Google does not publish a native Meta Ads connector, so every Meta Ads Looker Studio dashboard runs on one of four routes: manual CSV export, a free-tier community connector, a paid community connector, or your own data pipeline. Each trades cost against history depth.

This decision shapes everything else, so settle it before you start clicking. Google builds first-party connectors for its own products, but Meta data has to arrive through a third party.

Typical setup time, refresh cadence, history depth and monthly cost by Meta Ads connector route.

Route	Setup time	Refresh	History	Monthly cost
Manual CSV to Sheets	30–45 min	Manual only	Unlimited	RM 0
Free-tier connector	10–15 min	Daily	~30 days	RM 0
Paid connector	10–15 min	1–4× daily	13–37 months	RM 60–260
Own data pipeline	2–5 days	Hourly	Unlimited	RM 400+

Illustrative scenario based on typical Looker Studio connector tiers, Malaysia, 2026. Licence.

For most Malaysian SMEs spending under RM 15,000 a month, the free-tier connector is the honest answer. The 30-day history limit sounds restrictive until you notice that almost every question you ask a Meta Ads Looker Studio dashboard is about the last four weeks.

The trap is history. Run a free tier for a year, then ask for a year-on-year comparison, and that year does not exist. If seasonality matters to you — and it does if you sell around Raya or year-end campaigns — export a monthly CSV into a Sheet from day one.

Key takeaway: Start on a free-tier connector, but archive a monthly CSV to Google Sheets from the first month so the history is there when you eventually need it.

5. How to Build the Dashboard in Eight Steps

Quick Answer: Building a Meta Ads Looker Studio dashboard takes about 40 minutes end to end: authorise the connector, create the data source, add a date control, place nine scorecards, add two charts and one table, then share by link. No coding, no template purchase.

How to build a Meta Ads dashboard in Looker Studio

Work through these in order, in one sitting. Stopping halfway usually means re-authorising the connector later.

1. Authorise the connector. In Looker Studio, choose Create then Data source and search the gallery for a Meta or Facebook Ads connector. Sign in with the Facebook account holding admin rights on the ad account.
2. Pick the right ad account. Match on account ID, not name — names get reused, IDs do not. Copy the ID from Ads Manager first.
3. Create a blank report. Attach the data source you just made and name it with the brand plus the word Meta, so it is findable in six months.
4. Add the date range control first. Place it top-right, default to Last 28 days. Adding it before any chart means every chart inherits it automatically.
5. Place nine scorecards across the top. Spend, leads, cost per lead, purchases, cost per purchase, ROAS, link CTR, CPM, frequency. Switch on comparison so each shows the change against the previous period.
6. Add a time-series chart. Plot spend and cost per lead together by day. This one chart answers most owner questions.
7. Add a campaign table below it. Campaign name as rows; spend, results and cost per result as columns; sorted by spend, capped at ten rows.
8. Set data freshness and share. In data source settings, set the refresh interval, then share by link with view access.

Step eight is where people leave value behind. Looker Studio caches query results, and Google's documentation on managing data freshness notes a default threshold of 12 hours on many connectors — usually the reason a dashboard looks stale. You can also switch on auto refresh for the report. If the report loads but shows nothing, that is a separate and common problem covered in our guide to fixing a blank Looker Studio dashboard.

Key takeaway: Add the date range control before you build any chart — retrofitting it across nine scorecards afterwards doubles the build time.

6. The One-Screen Layout That Replaces the PDF

Quick Answer: A dashboard that needs scrolling gets ignored. Put the date control and five headline scorecards in the top third, the spend-versus-cost-per-lead trend in the middle, and the campaign table at the bottom. Diagnostics go on page two.

Most self-built dashboards fail on layout, not data. People add every field the connector offers, the page runs to three screens, and after a fortnight nobody opens it. The discipline is subtraction. The layout we use on every account:

• Top strip. Report title, client logo, date range control. Nothing else competes for that space.
• Row one — five scorecards. Spend, leads, cost per lead, purchases, ROAS. Comparison arrows on. This row answers "are we fine?" in under three seconds.
• Row two — one time-series chart. Daily spend as bars, cost per lead as a line. Two axes, nothing more.
• Row three — campaign table. Top ten campaigns by spend, with results and cost per result.
• Page two — diagnostics. CTR, CPM, frequency, placement split, top creatives by spend.

That is the whole thing. When someone asks for another chart, the honest question is which existing chart it replaces. It is the same discipline behind a one-page GA4 marketing summary and a marketing report your boss will actually read.

If the answer to "are we fine?" needs scrolling, the dashboard has already failed.

One practical note for Malaysian accounts: set the currency to MYR in the data source, not per chart. Doing it per chart is how one scorecard ends up quietly showing USD.

Key takeaway: Five scorecards, one trend chart, one campaign table, all above the fold. Every extra chart is a chart nobody reads.

7. What Actually Happens After You Roll It Out

Quick Answer: Owner usage of a Meta Ads Looker Studio dashboard peaks in month one and settles at roughly one check a week. Marketing executives go the other way, climbing steadily as the dashboard becomes their working tool rather than a reporting artefact.

We tracked dashboard opens for six months after rollout. The two user types diverge quickly, and that changes who you should build for — a point worth reading alongside our review of Looker Studio as a marketing tool.

The owner curve is not a failure. Five opens a month means the owner checks weekly, which is exactly the cadence a Meta Ads Looker Studio dashboard should settle into. The month-one spike is curiosity, not a benchmark.

The executive curve is the interesting one. It climbs because the dashboard stops being a report and becomes the place they check before changing anything. That is why page one should serve the owner and page two the executive: same dashboard, two very different jobs.

Key takeaway: Judge adoption at month three, not month one. Weekly owner checks and daily executive use is a healthy steady state.

8. Why Your Dashboard Will Never Match Ads Manager Exactly

Quick Answer: Small gaps between your dashboard and Ads Manager are normal and usually come from attribution settings, time zones and late-arriving conversions. A gap under about 5% is not a bug. Anything larger points at the connector or the attribution window.

Every new dashboard owner asks this in week one, and the answer is reassuring. Meta counts a conversion against the day the ad was clicked, not the day the conversion happened, and the attribution setting decides how far back it looks — Meta's documentation on changing your attribution window in Ads Manager explains the mechanics. Here is how much one identical week can move.

Website purchases move most, because the gap between click and purchase is longest. Pick one setting, label it on the dashboard, and stop comparing across settings. Meta's guidance on attribution settings is worth reading once so you can defend the choice.

Two other causes worth checking before you blame the connector:

• Time zone mismatch. Your ad account may run on a different time zone from your report. A day-boundary shift makes every daily figure look wrong.
• Late conversions. The last 72 hours keep moving. Never decide anything on yesterday alone.

Cross-platform gaps share the same root cause, which is why GA4 and Google Ads numbers rarely match either, and why WhatsApp enquiries need their own tracking before they can reach any dashboard.

Key takeaway: Lock one attribution setting, label it on the dashboard, and treat gaps under 5% as normal rather than as something to chase.

9. Conclusion

Quick Answer: Build the Meta Ads Looker Studio dashboard once, keep it to nine metrics on one screen, archive a monthly CSV for history, and lock your attribution setting. That combination replaces the monthly PDF permanently and costs nothing to run.

The build is genuinely one afternoon. Keeping it small afterwards is the harder part, because the pressure to add charts never stops and every addition makes the page slightly less likely to be opened.

If an agency runs your Meta Ads, ask for dashboard access rather than a report. It costs them nothing, and how they answer tells you a lot about how the account is run — the same test that applies when you are deciding what a fair Facebook Ads management fee looks like.

If you would rather not maintain it yourself, every ZenWeb Meta Ads engagement includes a live dashboard from week one. See the rest of what we do at ZenWeb, including Malay versus English ad copy and targeting for Malaysian audiences.

10. Frequently Asked Questions

1. Is a Meta Ads Looker Studio dashboard really free?

Looker Studio itself is free from Google, with no seat cost and no report limit. The only possible cost is the connector bringing Meta data in. Free tiers cover one or two ad accounts with around 30 days of history, which is enough for most Malaysian SMEs. Paid tiers start when you need longer history.

2. How often does the dashboard refresh?

Most free-tier Meta connectors refresh once a day. Looker Studio also caches results, with a default data freshness threshold of 12 hours on many connectors. You can lower that interval in the data source settings, or click Refresh data at any time to force a fresh pull.

3. Can I show Meta Ads and Google Ads on the same dashboard?

Yes. Google Ads has a native Looker Studio connector, so you add it as a second data source in the same report. Keep each platform on its own page rather than blending them, because the two count conversions differently and a combined total misleads more than it helps.

4. Why don't my dashboard numbers match Meta Ads Manager?

Almost always attribution settings, time zone differences, or conversions still arriving. Meta credits a conversion to the day of the click, so recent days keep moving for about 72 hours. A gap under roughly 5% is normal. A consistently larger gap means the connector is pulling a different attribution window.

5. Do I still need my agency's monthly report?

You need the monthly conversation, not the monthly PDF. Once the dashboard is live the numbers are already visible, so the meeting can move on to what changed, what was tested, and what happens next month. That is a better use of the hour than reading figures aloud.