How to Connect Meta Ads to Looker Studio

Looker Studio supports partner-built community connectors for platforms without a Google-built connector. Meta Ads connectors are available through the Connector Gallery.

Step 1: Choose a Meta Ads Connector

1. Sign in to Looker Studio.
2. Open an existing report or select Create → Data source.
3. Search the Connector Gallery for:

• Meta Ads
• Facebook Ads
• Facebook Marketing API

1. Choose a connector that includes the fields and reporting levels your dashboard needs.

Partner connectors can differ in price, available fields, refresh limits and support. Google notes that community connectors may charge for access and that support comes from the connector developer.

For basic reporting, choose a connector that supports campaign, ad set and ad-level data. For agency reporting, check whether it supports multiple Meta ad accounts and automatic refreshes.

Step 2: Authorize Meta Ads

After selecting a connector:

1. Click Authorize or Connect.
2. Sign in with the Facebook or Meta account that can access the ad account.
3. Approve the requested permissions.
4. Select the relevant Meta Business Portfolio, business account or ad account.
5. Confirm the connection.

If the ad account does not appear, check the user's access in Meta Business Settings. You may also need to disconnect and reconnect the connector so it can request the current permissions again.

Step 3: Select the Reporting Level

Meta Ads data can be reported at several levels:

• Campaign level: useful for budget and overall campaign performance.
• Ad set level: useful for audiences, placements and targeting.
• Ad level: useful for creative performance.
• Daily level: useful for trends and pacing.

Choose the lowest level needed for the report. A campaign summary only needs campaign-level data. A creative-performance dashboard needs ad-level data.

Unnecessary dimensions can slow reports and increase the amount of data requested from the connector.

Step 4: Select Meta Ads Fields

A Meta Ads dashboard will often use the following fields.

Dimensions

• Date
• Campaign name
• Campaign ID
• Ad set name
• Ad set ID
• Ad name
• Ad ID
• Objective
• Placement
• Device
• Country or region

Metrics

• Amount spent
• Impressions
• Reach
• Frequency
• Link clicks
• Click-through rate
• Cost per link click
• CPM
• Conversions
• Cost per conversion
• Conversion value
• Return on ad spend

Field names vary by connector. Looker Studio data sources define the dimensions, metrics, data types and aggregation options available in a report.

Step 5: Set the Date Range and Currency

Configure the connector's date range before adding it to the report.

For a reusable dashboard, choose a dynamic range such as:

• This month
• Last 7 days
• Last 30 days
• Previous month
• Custom date range

Check that the Meta ad account currency matches the currency shown in Looker Studio. If the report combines Meta Ads with Google Ads or revenue data, standardize the currency before calculating total spend or ROAS.

Step 6: Add the Data Source to Your Report

After configuring the connection:

1. Click Connect.
2. Review the available fields.
3. Select Add to report.
4. Confirm that the data source has been added.
5. Create charts using the Meta Ads fields.

Start with a table containing:

• Campaign name
• Amount spent
• Impressions
• Link clicks
• CTR
• Conversions
• Cost per conversion
• ROAS

Then add scorecards for total spend, impressions, clicks, conversions and revenue.

Step 7: Configure Data Credentials

Looker Studio data sources use data credentials to determine how viewers access the underlying data. For client-facing reports, the data source owner can generally use Owner's credentials, allowing viewers to see the report without direct access to the connected Meta ad account.

Use viewer credentials when every report viewer should authenticate separately with Meta Ads.

Check the credential setting before sharing the report, especially if it contains client advertising data.

Step 8: Check Data Freshness

Open the data source settings and review Data freshness.

Refresh intervals depend on the connector. Google states that community connector refresh rates vary, so one Meta Ads connector may update more frequently than another. Looker Studio may also serve previously requested data from memory until the configured freshness threshold is reached.

Daily refreshes are sufficient for most weekly or monthly marketing reports. Campaign pacing dashboards need a connector with more frequent updates.

Recommended Meta Ads Dashboard Structure

Overview Page

Use scorecards for:

• Spend
• Impressions
• Reach
• Link clicks
• Conversions
• Cost per conversion
• ROAS

Add a time-series chart showing spend and conversions by date.

Campaign Page

Use a table with:

• Campaign name
• Objective
• Spend
• Impressions
• CTR
• Conversions
• Cost per conversion
• ROAS

Add filters for date range, campaign, objective and status.

Ad Creative Page

Use ad-level data to compare:

• Ad name
• Creative
• Placement
• Impressions
• Reach
• Frequency
• Link clicks
• CTR
• Conversions
• Cost per conversion

Avoid mixing campaign-level and ad-level data in the same chart unless the connector clearly explains how it aggregates the metrics.

What to Do if the Meta Ads Connector Does Not Work

The Ad Account Is Missing

Check that:

1. The correct Meta user is signed in.
2. The user has access to the ad account.
3. The ad account belongs to the selected Meta Business Portfolio.
4. The connector has the required permissions.
5. The connector has been reauthorized.

The Report Shows No Data

Check the selected:

• Ad account
• Date range
• Campaign status
• Reporting level
• Dimensions
• Filters

Remove restrictive filters temporarily to confirm that the connection is returning data.

Numbers Do Not Match Meta Ads Manager

Compare these settings:

• Date range
• Time zone
• Currency
• Attribution settings
• Reporting level
• Conversion event
• Click definition
• Connector refresh time

Looker Studio may also show cached results. Refresh the report after changing the data source or date range.

The Connector Is Too Expensive

Use a manual Google Sheets workflow:

1. Export a Meta Ads report as a CSV file.
2. Upload or paste the data into Google Sheets.
3. Connect Google Sheets to Looker Studio.
4. Refresh the sheet when new Meta Ads data is available.

Google provides a Google Sheets connector and supports CSV uploads for data sources that are not otherwise supported. CSV uploads are free, but they do not update automatically from Meta Ads.

For large accounts or multi-client reporting, an automated connector or warehouse workflow is more reliable than repeated CSV imports.

Best Connection Method by Use Case

Final Recommendation

Use a Meta Ads partner connector when you need a Looker Studio dashboard that refreshes automatically. Choose campaign, ad set or ad-level data based on the decisions the report needs to support. Before sharing the report, check the currency, attribution settings, time zone, credentials and data freshness.

Use Google Sheets for occasional or low-volume reporting. For ongoing agency or enterprise reporting, use a connector or warehouse workflow that preserves historical data and supports multiple advertising platforms.