Free Facebook Ads Looker Studio Connector

Prerequisites

Before connecting your data, ensure you have:

• A Data Bloo account (sign up is free)
• A Google account with access to Looker Studio
• Admin or Advertiser access to the Facebook Ads account(s) you want to connect
• Pop-up blockers disabled (to allow Facebook OAuth authentication)
  

How to Connect

Step 1: Sign in to Data Bloo

1. Visit hub.databloo.com
2. Click Sign in and log in using Google or your email/password

Step 2: Navigate to Facebook Ads Data Source

1. After logging in, go to Data Sources from the left menu
2. Click on the Facebook Ads tile under “Add new data source”

Step 3: Connect to Facebook Ads

1. Click Connect with Facebook Ads to start the authorization
2. Approve the requested permissions to allow Data Bloo to access your ad data

Step 4: Select Facebook Ad Accounts

1. Choose one or more ad accounts to connect (You can even select all your accounts)
2. Click Connect Selected Accounts

Step 5: Review Connection

1. Your connected account(s) will appear under the Facebook Ads data source
2. You can add more accounts or disconnect at any time
3. Click Looker Studio to proceed to reporting

Step 6: Authorize in Looker Studio

1. Looker Studio will ask you to authorize the connector
2. Authorize both the connector and Facebook Ads data
3. Click at Edit and share” at the top right. In the new modal window, click “Acknowledge and save”.
4. Wait for a few seconds for the report to be fully generated. Do not perform any actions until you are redirected to the edit mode of the report.

Step 7: View the Facebook Ads Report

Your Looker Studio dashboard will now load with key campaign performance metrics such as:

• Impressions, CTR, and Clicks
• Conversions, Spend, and Cost per Result
• Campaign and Country Breakdown

Step 8 (Optional): Add Custom Conversions, Attribution Settings, or Switch Accounts

If you need to adjust your Facebook Ads report beyond the default setup — for example, to analyze custom conversions, test different attribution windows, or switch between ad accounts — you can do that directly in Looker Studio.

This is especially useful when:

• You want to focus the dashboard on specific conversion types (e.g. purchases, leads)
• You’re comparing 1-day click vs. 7-day view attribution models
• You manage multiple Facebook Ad accounts

How to Edit the Data Source Configuration

1. Open your Looker Studio report
2. Go to the top menu and click Resource > Manage added data sources
3. In the list, click Edit next to the Facebook Ads source
4. Click the blue Edit connection button at the top of the data schema page

Modify Conversion, Account, and Attribution Parameters

Once inside the connection editor:

• Use the Account dropdown to switch to another ad account
• Use the Conversions menu to choose from:
  • All conversions
  • Leads, Purchases, Website Engagement, etc.
• Select from multiple Action attribution windows, including:
  • 1-day click, 7-day view, 28-day click, and more

Finalize the Changes

1. After making your selections, click Reconnect
2. When prompted, confirm by clicking Apply

Your dashboard will now reflect your new configuration.

This optional step allows full control over what you analyze in Looker Studio, making the Data Bloo + Facebook Ads integration even more powerful for client reporting or performance testing.

Troubleshooting

Notes

• Data security: Data Bloo does not store your Facebook Ads data. All access is read-only and securely pulled via Facebook’s API.
• Multiple Accounts Reporting: This connector allows you to aggregate data from multiple accounts (or all accounts) for your reporting.