A Looker Studio report is only as good as its data connections. Before you can build a single chart, you need to tell Looker Studio where your data lives and give it permission to read it. That setup is called a data source.
Understanding how data sources work — and how they can go wrong — saves you a significant amount of troubleshooting time later.
What a Data Source Is
A data source in Looker Studio is a configured connection to a specific dataset. It defines which account, property, or file to read from, and it surfaces the dimensions and metrics available for use in charts.
When you connect GA4, the data source exposes all the standard GA4 dimensions and metrics: sessions, users, conversions, event names, page paths, and so on. When you connect Google Ads, you get campaign names, impressions, clicks, cost, and conversion data. The data source is what makes those fields available to drag into charts.
Types of Data Sources
Looker Studio has two kinds:
Reusable data sources exist independently of any report. You create them once, and multiple reports can reference the same data source. If connection credentials expire, you update the data source once and all reports that use it are fixed.
Embedded data sources are created inside a specific report and only exist within that report. They are faster to set up but harder to maintain at scale — if you have 20 client reports each with their own embedded data source, you have 20 separate connections to manage.
For agency work, reusable data sources are the better long-term choice. For a one-off personal dashboard, embedded is fine.
Connecting Google Analytics 4
In a new or existing report, click Add Data in the toolbar. Select Google Analytics from the connector list.
Looker Studio will ask you to authorize access to your Google account if you have not already. Once authorized, you will see a list of GA4 properties you have access to. Select the correct account, property, and then the data stream if prompted.
Click Add to Report. Looker Studio will create a data source connected to that GA4 property and add it to your report.
One thing to note: the GA4 connector in Looker Studio samples data for large date ranges and high-cardinality reports. If your charts are showing slightly different numbers than the GA4 interface, sampling is usually the cause. Using a shorter date range or fewer dimensions per chart reduces sampling.
Connecting Google Ads
Click Add Data and select Google Ads from the connector list.
Select the Google Ads account you want to connect. If you manage multiple accounts under an MCC (manager account), you will need to select the individual account, not the MCC level — Looker Studio connects at the account level, not the manager level.
Once connected, you will have access to campaign, ad group, keyword, and conversion data from that account.
One limitation worth knowing: Looker Studio’s native Google Ads connector does not expose all fields available in the Google Ads API. Attribution model data, some audience segments, and certain custom conversion categories may not appear. For full field access, you would need to export data to BigQuery via the Google Ads Data Transfer and connect from there.
Connecting Google Sheets
The Google Sheets connector is useful when you have data that does not live in a Google platform — CRM data, manual cost inputs, offline conversion data, or anything you track manually.
Click Add Data and select Google Sheets. Choose the spreadsheet and the specific sheet (tab) you want to use. Looker Studio reads the first row as column headers and treats subsequent rows as data.
A few requirements for the Sheet to work cleanly:
- The first row must be headers with no merged cells
- Date columns should use consistent formatting (YYYY-MM-DD is most reliable)
- No empty rows in the middle of the data
- No formatting in the data cells (no colored cells, no bold — Looker Studio reads values, not formatting)
The Sheets connection does not update in real time. Looker Studio caches the data and refreshes it periodically (typically every 15 minutes for free accounts). For daily reporting this is fine.
Third-Party Connectors
For data sources outside Google’s ecosystem — Meta Ads, LinkedIn, Shopify, HubSpot, Bing Ads — you need partner connectors. These appear in the connector list alongside Google’s native connectors.
Some partner connectors are free. Many require a paid subscription to the connector service (Supermetrics, Porter Metrics, and Funnel.io are common choices). The connector service pulls data from the platform’s API and makes it available to Looker Studio.
The quality and reliability of partner connectors varies. Before committing to one for client reporting, test it with a real account and verify that the metrics it surfaces match the native platform’s numbers.
When a Data Source Breaks
Data source connections break most often for two reasons: credentials expire, or the underlying data structure changes.
If you see a grey chart with a credential error, click Edit on the data source and re-authorize the connection. This usually happens when the Google account that originally authorized the connection has its access revoked or its password changed.
If you see a chart with a field error — a broken metric or dimension — the underlying data source changed its field schema. This happens when GA4 property configurations change, when a custom dimension is deleted, or when a Google Ads conversion action is renamed. Open the data source editor, find the broken field (marked in red), and either remap it to the correct field or remove it.
Structuring Data Sources for Multiple Clients
If you manage reporting for multiple clients, set up one reusable data source per client per platform. Name them clearly: [Client Name] - GA4, [Client Name] - Google Ads.
When you duplicate a report template for a new client, swap the data sources at the report level without rebuilding anything. That is the workflow that makes Looker Studio efficient at scale.
Related Posts
Data Blending in Looker Studio: Combine GA4 and Google Ads in One Chart
Building an Ecommerce Dashboard in Looker Studio With GA4
Google Ads and Looker Studio: Building a Live Campaign Performance Dashboard
Need Help With Your Google Ads?
I help e-commerce brands scale profitably with data-driven PPC strategies.
Get In Touch