How to Connect Facebook Ads to Looker Studio

Building a clear picture of your advertising performance requires bringing all your data into one place. If you're running Facebook Ads, getting that data into a flexible reporting tool like Looker Studio (formerly Google Data Studio) is a great way to build custom-tailored dashboards. This article will walk you through exactly how to connect Facebook Ads to Looker Studio so you can start visualizing your campaign results.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Connect Facebook Ads to Looker Studio?

While Facebook Ads Manager has its own reporting, it lives in a silo. Moving your data to Looker Studio lets you see the bigger picture and build dashboards that are far more powerful and customized to your specific needs. Here’s why it’s worth the effort:

• Centralized Reporting: Instead of jumping between tabs, you can place your Facebook Ads data alongside metrics from Google Analytics, Google Ads, your CRM, and other sources. This gives you a single source of truth for all your marketing performance.
• Fully Customizable Dashboards: Looker Studio breaks you free from the limitations of the Ads Manager interface. You can create reports with any layout, branding, charts, and tables you want. You can focus on the key performance indicators (KPIs) that matter most to your business, not just the ones Facebook shows you by default.
• Data Blending: This is a game-changer. You can blend data from Facebook with other sources. For example, you could combine Facebook ad spend data with sales data from Shopify or lead data from Salesforce to calculate your true return on ad spend (ROAS) and cost per lead across the entire funnel.
• Automated & Shareable Reports: Once set up, your dashboard can be scheduled to refresh automatically, meaning you always have current data without manually pulling reports. You can easily share a link to your interactive dashboard with team members or clients, streamlining your reporting process entirely.

The Core Challenge: No Native Facebook Connector

Before we get into the "how," it's important to understand one key detail: Looker Studio does not have a free, built-in connector for Facebook Ads.

Unlike Google products like Google Analytics or Google Ads, which connect seamlessly, Facebook is a third-party platform. This means you can't just select "Facebook Ads" from the default list of data connectors. To pull the data in, you need to use an intermediary solution. Broadly speaking, you have two primary options: using a third-party partner connector or a more manual method using spreadsheets.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: Use a Partner Connector (The Easy, Automated Way)

The most straightforward and reliable way to connect Facebook Ads to Looker Studio is by using a third-party "partner connector." These are services specifically designed to act as a bridge, securely pulling data from platforms like Facebook via their API and feeding it directly into Looker Studio.

These connectors handle all the technical heavy lifting - authentication, data requests, and formatting - so you don't have to. While most are paid services, the time and headaches they save are often well worth the cost for anyone who regularly reports on ad performance.

A few popular and reputable connectors include:

• Supermetrics
• Power My Analytics
• Funnel.io
• Windsor.ai

Step-by-Step Guide Using a Partner Connector

The exact interface will vary slightly between services, but the general workflow is almost identical for all of them. Here’s what the process looks like:

Step 1: Choose and Sign Up for a Connector

First, pick a connector. Supermetrics and Power My Analytics are very popular choices with free trials, making them a great place to start. Go to their website, sign up for an account, and start a trial or subscribe to a plan.

Step 2: Authenticate Your Facebook Ads Account

Inside the connector’s platform, you’ll be prompted to connect your data sources. Find and select Facebook Ads. This will redirect you to Facebook to log in and grant the application permission to access your Ads Manager data. It’s a standard, secure OAuth process.

Step 3: Go to Looker Studio and Add a Data Source

Now, head over to your Looker Studio report. If you’re starting from scratch, create a new blank report. You will be immediately prompted to add data. If you have an existing report, go to Resource > Manage added data sources > Add a Data Source.

Step 4: Find Your Partner Connector

In the data source search bar, type the name of the connector you signed up for (e.g., "Supermetrics"). You will see a list of available integrations offered by that partner. Find the one for Facebook Ads and select it.

Step 5: Authorize Looker Studio to Use the Connector

Looker Studio will ask for your permission to allow the selected connector to work with your account. Click "Authorize" and follow the prompts to sign into your connector account (e.g., your Supermetrics account) to link it with Looker Studio.

Step 6: Configure Your Data Source Settings

This is where you tell the connector exactly what Facebook Ads data you want to pull. The configuration options will appear, allowing you to select:

• The specific ad account(s).
• The date range for the initial pull.
• The specific metrics (like Amount Spent, Impressions, Link Clicks) and dimensions (like Campaign Name, Ad Set Name, Date, Device) you need for your report.

Pro Tip: Start by selecting only the fields you know you need. You can always come back and add more metrics or dimensions later by editing the data source.

Step 7: Connect and Add to Report

Once you’ve configured your settings, click the "Connect" button in the top right corner. Looker Studio will show you a list of all the fields (metrics and dimensions) from your selection. Review them one last time, then click "Add to Report."

That's it! Your Facebook Ads data is now connected as a live data source in your report, and you can start building charts and tables.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: Use Google Sheets (The Manual "Free" Way)

If a paid connector isn't an option, you can use a manual workaround that leverages Google Sheets. This method is "free" in terms of software costs, but it requires significant manual labor and your data will not update in real-time. This can work for one-off reports but becomes difficult to manage for regular, recurring reporting.

The process involves exporting your data from Facebook Ads Manager, importing it into a Google Sheet, and then connecting that Google Sheet to Looker Studio.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Guide for the Manual Method

Step 1: Export Data from Facebook Ads Manager

Log in to Facebook Ads Manager. Navigate to the campaign, ad set, or ad level you want to report on.

1. Click the Columns dropdown and select Customize Columns to choose the exact metrics and dimensions you need. Be thorough here, because adding a forgotten metric later means re-exporting and re-uploading everything.
2. Set the date range for your report using the date picker in the top right.
3. Click the Reports icon (looks like a chart) and select Export Table Data.
4. Choose to export as a .CSV file and click Export.

Step 2: Import and Clean the Data in Google Sheets

Open a new Google Sheet. Go to File > Import. Select the "Upload" tab and drag in the CSV file you just downloaded. After you import it, you may need to do some light cleanup, like deleting summary rows at the bottom that Facebook sometimes includes.

Step 3: Connect Google Sheets to Looker Studio

Now, go back to Looker Studio and add a new data source. In the connector search bar, search for and select the official Google Sheets connector.

From here, you will be prompted to:

• Select the spreadsheet you just created.
• Select the specific worksheet containing your data.
• Configure options like "Use first row as headers" (make sure this is checked).
• Click Connect to finalize the connection. Looker Studio will analyze your spreadsheet columns and assign data types (Number, Text, Date, Currency). Double-check that it has correctly identified your metrics, especially date fields and spend/cost fields.

Your manually exported Facebook Ads data is now available in your report.

The Big Drawbacks of the Manual Method

While this process works, it's not ideal for ongoing reporting.

• It's not automated. Your data is static. To see next week's performance, you have to repeat the entire export/import process. This takes a lot of time.
• It's prone to error. It's easy to make mistakes during a manual copy-paste or export process, leading to inaccurate reports.
• It doesn’t scale. This workflow becomes nearly impossible to manage if you're reporting on multiple ad campaigns or creating several different dashboards.

Final Thoughts

Connecting your Facebook Ads data to Looker Studio opens up a huge opportunity for creating custom, insightful dashboards. While paid third-party connectors are the most efficient and scalable solution, the manual Google Sheets method can work in a pinch for simple, one-time reports.

Wrestling with connectors and CSV files is often the most frustrating part of reporting. That's why we built Graphed to remove this friction entirely. Instead of multistep configurations, you connect your accounts like Facebook Ads once, and then simply ask for what you want in plain English. For instance, you can type "create a dashboard showing Facebook Ads spend, clicks, and ROAS by campaign for this month," and our tool instantly builds a real-time, shareable dashboard for you, completely bypassing the manual setup.