Using Looker Studio to Build a Unified Social Media & GA4 Reporting Dashboard

Social media reporting usually breaks down into screenshots: one from each native platform, pasted into a slide every month. A single dashboard that pulls GA4 website results and native social metrics into one view saves hours and, more importantly, shows which networks actually send visitors who engage and buy. This guide builds that dashboard step by step with Google’s free reporting tool.

Two renames to know before you start. In April 2026 Google renamed Looker Studio back to Data Studio, and Looker Studio Pro became Data Studio Pro; existing reports carried over automatically. In GA4, “conversions” are now called key events, so the “conversion rate” metric you may remember appears as Session key event rate. This guide uses the current names.

The dashboard blueprint

Plan the layout before connecting anything. A one-page summary plus one page per question keeps the PDF readable for stakeholders who never open the live report.

Agree the reporting period and owners before building. A dashboard that two people update in different ways quickly loses trust, so name one person responsible for the monthly Sheet update and another for checking the PDF before it goes out.

Connecting GA4 and Google Sheets data sources

You need at least Viewer access to the GA4 property and edit access to the Sheet. Start from Data Studio → Create → Report.

1. Add GA4. In the Add data to report panel, choose the Google Analytics connector, then pick the account and GA4 property and click Add.
2. Prepare the Sheet. Put each network’s native export (from its own analytics tool) into one tab with identical column headers, one row per date per network.
3. Add the Sheet. Use Add data → Google Sheets, select the spreadsheet and worksheet, and keep Use first row as headers ticked.
4. Check field types. In the data source editor, make sure the date column is a Date and numeric columns are Numbers, not Text.

Filters that isolate each social network

GA4’s Session source / medium dimension is the most reliable way to split website traffic by network. Google defines it as the source and medium associated with a new session. Create one filter per network and reuse it across charts.

1. Select a chart, open the Setup tab in the Properties panel and click Add a filter → Create a filter.
2. Name it, e.g. Instagram – website, and choose Include.
3. Pick the dimension Session source / medium and the condition Regexp Contains.
4. Enter the pattern from the table below and click Save.

These patterns are starting points, not an official list. Referral domains vary (for example, mobile or link-shim subdomains), so open a table of Session source / medium in your own property and adjust the patterns to what you actually see. The (?i) flag makes a pattern case-insensitive.

Scorecards for engaged sessions, key event rate and revenue

Add scorecards with Add a chart → Scorecard, then apply one network filter to each row of scorecards. The GA4 definitions below come from Google’s traffic acquisition documentation.

In each scorecard’s Setup tab, set Comparison date range to Previous period so viewers see the change at a glance. Use a Date range control at page level so every scorecard moves together.

If you prefer one chart over many scorecards, a table with Session source / medium as the dimension and the same four metrics gives the full comparison in one place. Keep scorecards for the summary page, where a quick read matters more than detail.

Combining native reach with website results

The most useful view puts native reach next to the website visits it produced. Data Studio’s Blend data feature joins two sources on shared fields, which here are the date and the network name.

1. Select a table, then in the Setup tab click Blend data and add the Sheet as a second table.
2. For the GA4 side, create a calculated field that turns Session source / medium into a clean network name with a CASE statement that reuses the patterns above.
3. Join on Date and that network field, using a left outer join from the Sheet so networks without website traffic still appear.
4. Add a calculated metric such as SUM(Engaged sessions) / SUM(Reach) * 1000 to show engaged visits per 1,000 people reached.

Treat that ratio as a directional comparison between networks rather than an exact funnel. Each platform defines reach in its own way, and some website visits won’t be attributed to social at all.

Scheduling a monthly PDF by email

Data Studio can send the report as a PDF attachment with a link back to the live version. You need to be the owner, an editor or have scheduling permission on the report.

1. View the report and click Share → Schedule delivery.
2. Add recipients (you’re always included) and select the pages to send.
3. Set the start date and time, then choose a monthly frequency under Repeat, or Custom for patterns such as the first Monday.
4. On the Filters tab, set date range and filter control values for the PDF, then click Schedule.

Google also notes that schedules use your operating system’s time zone, and scheduled PDFs always use US English number and date formats. If a report fails to download manually, the schedule won’t send either, so test a PDF download first.

Troubleshooting common dashboard problems

• A scorecard shows “No data”: test the filter pattern against a plain table of Session source / medium, and check the page’s date range control.
• Charts load slowly or show quota errors: GA4 limits how much data reporting tools can request, so reduce the number of GA4 charts per page or split the report.
• New Sheet rows don’t appear: in edit mode, use the report’s refresh data option, and confirm the new rows sit inside the connected range.
• Large “(not set)” rows: exclude them with a filter on Session campaign equals (not set) only on campaign tables, not on network totals.

Pre-send QA checklist

• Every network filter matches the sources you see in your own GA4 property.
• Sheet network names and date formats are consistent for the new month.
• Scorecards compare against the previous period, not the previous year by mistake.
• Revenue scorecards show data, or are hidden if ecommerce isn’t tracked.
• A manual PDF download looks correct before the scheduled send.

To decide which numbers belong on the summary page, see our KPI matrix of vanity vs. revenue metrics. For YouTube channel data, pair this dashboard with the YouTube Studio analytics audit. More guides are in our Google Marketing & Discovery Tools category.

Official references: Schedule automatic report delivery, Configure filter conditions and GA4 Traffic acquisition report.