By following this guide, you will build a live paid social reporting dashboard in Looker Studio (formerly Google Data Studio) that pulls data from Meta Ads, TikTok Ads, and LinkedIn Ads into a single view. The full build takes roughly two to three hours and requires no coding. Once live, your dashboard refreshes automatically and eliminates the weekly spreadsheet ritual that slows down most marketing teams.

What You'll Build

  • A single Looker Studio dashboard that displays spend, impressions, clicks, CTR, and ROAS across Meta, TikTok, and LinkedIn Ads
  • Automated data connectors that refresh on a schedule without manual exports
  • Date-range controls and platform filters so any team member can slice the data instantly
  • A reusable template you can duplicate for new clients or campaigns

Prerequisites

  • A Google account with access to Looker Studio (free at lookerstudio.google.com)
  • Active ad accounts on at least one of: Meta Ads Manager, TikTok Ads Manager, LinkedIn Campaign Manager
  • A Supermetrics, Windsor.ai, or Porter Metrics subscription — any paid plan works (plans start around USD $29–$49/month as of 2026)
  • Editor-level access to the ad accounts you want to connect
  • Basic familiarity with Looker Studio charts (helpful but not required)

Step 1: Choose and Install Your Data Connector

Why does the connector choice matter so much?

Looker Studio's native integrations do not cover TikTok Ads or LinkedIn Ads directly. A third-party connector bridges that gap and handles API authentication, rate limits, and schema normalisation automatically.

The three most reliable connectors in 2026 are:

  • Supermetrics — largest feature set, best for agencies managing multiple accounts
  • Windsor.ai — strong multi-touch attribution, good for performance marketers
  • Porter Metrics — cleanest Looker Studio UI, easiest for SMB teams new to reporting

For this tutorial, Porter Metrics is used as the example. The steps are nearly identical across all three.

  1. Go to portermetrics.com and sign up for a free trial or paid plan.
  2. Navigate to Connect → Meta Ads and authorise your Meta Business account.
  3. Repeat for TikTok Ads and LinkedIn Ads.
  4. For each connection, select the specific ad account IDs you want to include.

Common pitfall: If you manage ads for clients, connect the connector using their ad account ID — not your own agency account. Mixing account IDs is the most common cause of inflated or missing spend figures.

Step 2: Create a New Looker Studio Report

  1. Open lookerstudio.google.com and click Create → Report.
  2. When prompted to add a data source, search for Porter Metrics (or your chosen connector) in the connector search bar.
  3. Select Meta Ads first and click Add to Report.
  4. Repeat the process to add TikTok Ads and LinkedIn Ads as additional data sources to the same report.

Open a new browser tab and go to the Looker Studio connector gallery at lookerstudio.google.com/datasources/create. Search by connector name there. Once you authorise it once, it appears in all future reports.

Pro tip: Name each data source clearly (e.g. "Meta Ads — AcmeCo", "TikTok Ads — AcmeCo") before saving. Ambiguous source names cause confusion when you duplicate the template for future clients.

Step 3: Set Up Your Core Metrics and Dimensions

Each ad platform uses slightly different field names. Normalising them now saves hours of confusion later.

Which metrics should every paid social dashboard include?

At minimum, track these six metrics across every platform:

  • Spend — total ad spend in local currency
  • Impressions — total ad views
  • Clicks — link clicks (not total engagements)
  • CTR — click-through rate (Clicks ÷ Impressions × 100)
  • Conversions — purchases, leads, or sign-ups depending on campaign objective
  • ROAS — return on ad spend (Revenue ÷ Spend)

In Looker Studio, go to Resource → Manage Added Data Sources. Click Edit on the Meta Ads source. Rename fields to standardised labels: change "amount_spent" to "Spend", change "link_click" to "Clicks". Do the same for TikTok and LinkedIn sources.

Common pitfall: LinkedIn reports clicks as "Clicks" but includes both link clicks and social actions. Add a filter on the LinkedIn source to show only EXTERNAL_WEBSITE_CLICKS so your CTR calculation stays accurate.

Step 4: Build the Dashboard Layout

A clean dashboard structure reduces the time it takes stakeholders to extract insight. Use this three-section layout:

  1. Top row — Scorecards: Total Spend, Total Impressions, Total Clicks, Blended CTR, Total Conversions, Blended ROAS
  2. Middle row — Time series chart: Daily Spend over time, broken down by platform using a colour dimension
  3. Bottom row — Table: Campaign-level breakdown showing Spend, Impressions, Clicks, CTR, Conversions, CPA, ROAS per campaign

How do you blend data from three platforms into one chart?

Use Looker Studio's Blend Data feature.

  1. Select your time series chart on the canvas and click Add a blend in the data panel on the right.
  2. Set the Join Key to Date for all three sources.
  3. Select Full Outer Join so days with zero spend on one platform do not drop other platform rows.
  4. Add a calculated field: COALESCE(Meta_Spend, 0) + COALESCE(TikTok_Spend, 0) + COALESCE(LinkedIn_Spend, 0) and label it "Total Spend".

Blended data sources in Looker Studio as of mid-2026 support up to five joined tables, which is enough for most multi-channel setups.

Step 5: Add Date Range and Platform Filter Controls

Static dashboards become stale within days. Controls make the report self-service.

  1. Click Insert → Date range control and place it in the top-right corner of the report.
  2. Set the default date range to Last 30 days.
  3. Click Insert → Drop-down list to add a platform filter. Set the dimension to Platform (a field your connector should provide — if not, add a calculated field with a fixed string value per source).
  4. Add a second drop-down for Campaign Name so users can isolate individual campaigns.

Pro tip: Group the date control and filter controls inside a styled rectangle shape to visually separate them from the charts. Stakeholders in Australia and Singapore often share these dashboards directly with clients — a polished layout builds trust before anyone reads a single number.

Step 6: Configure Automatic Data Refresh

Manual refreshes defeat the purpose of a live dashboard.

  1. In your connector account (e.g. Porter Metrics), go to Settings → Data Refresh.
  2. Set the refresh frequency to every 6 hours for most use cases. Daily campaigns can use a 24-hour refresh.
  3. Back in Looker Studio, go to Resource → Manage Added Data Sources → Edit and confirm Data freshness is set to match your connector schedule.

Most connectors on paid plans refresh every 1–12 hours. If you need near-real-time data for high-budget campaigns, Supermetrics' Team plan supports hourly refresh as of 2026.

Step 7: Add Conditional Formatting and Targets

Why does conditional formatting improve reporting outcomes?

Colour-coded performance signals reduce the time a manager spends interpreting a table from minutes to seconds. A US-based DTC brand running Meta and TikTok simultaneously, for example, can spot underperforming ad sets at a glance rather than exporting to a spreadsheet.

  1. Select your campaign table and click Style → Add conditional formatting.
  2. For ROAS: set green for values above your target (e.g. 3.0), yellow for 1.5–3.0, red for below 1.5.
  3. For CPA: invert the scale — green for below target, red for above.

Set your target values based on historical account benchmarks. If you are starting fresh, Meta's 2026 average ROAS for ecommerce sits around 2.5–3.5x depending on vertical and audience size.

Step 8: Share and Permission the Dashboard

  1. Click Share → Manage access in the top-right corner.
  2. For internal teams, add individual Google accounts as Viewer or Editor.
  3. For clients, use Share → Schedule email delivery to send a PDF snapshot weekly. This avoids giving clients direct dashboard access while still keeping them informed.
  4. If clients need live access, share as a view-only link and enable Viewer can see shared filter controls.

If your agency manages social content planning alongside paid ads, pairing this dashboard with a structured content calendar helps you connect organic and paid performance. Lenka Studio offers a free social media toolkit that includes a content calendar template you can use alongside your reporting setup.

Step 9: Save the Report as a Template

  1. Click File → Make a copy to create a clean duplicate of the report.
  2. In the copy, go to Resource → Manage Added Data Sources and swap each connector to a new client's ad account.
  3. Save the original as your "Master Template" — never modify it directly.

Teams at Lenka Studio use this exact template approach when onboarding new clients: duplicating a master and swapping data sources takes under 20 minutes per client, compared to roughly three hours to build from scratch each time.

Frequently Asked Questions

Can I build this dashboard without a paid connector?

You can connect Meta Ads directly to Looker Studio using the native connector under Google Connectors. However, TikTok Ads and LinkedIn Ads have no official native Looker Studio connector as of mid-2026, so you will need a third-party tool or a manual CSV import workflow for those platforms.

How is this different from using each platform's native reporting tool?

Native tools like Meta Ads Manager and LinkedIn Campaign Manager only show data from their own platform. This dashboard lets you compare performance and total spend across all three in one view, which is essential when making cross-channel budget decisions.

What if my ROAS data does not match what I see inside Meta Ads Manager?

Connector-reported ROAS uses the conversion value sent to the platform via pixel or API. Discrepancies usually happen because of attribution window differences (Meta defaults to 7-day click, 1-day view) or because your connector is pulling a different conversion event. Check your connector's field mapping and align attribution windows across platforms before comparing.

Does this work for Google Ads as well?

Yes. Looker Studio has a native Google Ads connector that requires no third-party tool. Add it as a fourth data source using the same blending approach in Step 4, and your dashboard can cover Meta, TikTok, LinkedIn, and Google Ads simultaneously.

How many ad accounts can one dashboard handle?

Looker Studio supports up to five data sources per blend and up to 20 data sources per report as of 2026. For agencies managing 10 or more clients, create one dashboard per client rather than one mega-dashboard — it keeps load times fast and permissions clean.

Next Steps

Once your dashboard is live, the next layer of value comes from connecting it to your broader marketing strategy. Consider adding a Google Analytics 4 data source to track what happens after a paid click lands on your site — Looker Studio's native GA4 connector makes this straightforward. You can also use the campaign-level data in your dashboard to inform budget reallocation decisions on a weekly basis rather than waiting for a monthly review.

If you want to take your brand's overall performance measurement further, the free brand health score assessment from Lenka Studio is a useful starting point for identifying where paid social fits within your broader growth picture.

Need help designing a reporting infrastructure tailored to your business? Get in touch with the Lenka Studio team — we help SMBs in Australia, Singapore, Canada, and the US build marketing systems that are actually used, not just built.