Data Studio doesn't natively pull data from Facebook Ads. To build a live Facebook Ads dashboard, you need a community connector, a third-party integration that bridges your Meta Ads account and Data Studio's reporting interface.
This guide covers what a Facebook Ads Data Studio connector does, how to set one up in five steps, which metrics you get, and how the leading connectors compare on price in 2026.
What Is a Facebook Ads Data Studio Connector?
A Facebook Ads Data Studio connector (also called a Meta Ads connector) is a data integration that pulls campaign data from the Facebook Marketing API and makes it available as a data source inside Data Studio, formerly known as Google Data Studio.
Without a connector, you're stuck exporting CSVs from Ads Manager and uploading them manually. A connector keeps your Data Studio reports updated automatically, on a schedule you control.
Connectors come in two types:
- Community connectors: built on Google Apps Script and listed in the official Data Studio Connector Gallery. They run inside Data Studio directly. No data warehouse required.
- ETL tools: third-party platforms (Supermetrics, Funnel.io, Windsor.ai) that extract data, store it in an intermediate warehouse, and then surface it in Data Studio. More powerful, but also more expensive and complex.
For most agencies and freelancers, a community connector is all you need.
Why You Need a Connector for Meta Ads Reporting
Agencies managing Facebook Ads campaigns face a recurring problem: clients want live dashboards, not static screenshots. Ads Manager exports are manual, inconsistent, and time-consuming to maintain.
A good Meta Ads Data Studio connector solves this by:
- Keeping dashboards updated automatically (hourly or daily)
- Letting you build fully customizable reports with Data Studio's drag-and-drop interface
- Combining Facebook Ads data with other sources (Google Ads, GA4, etc.) in a single view
- Delivering client-ready reports without recurring manual work
Agencies using a dedicated Facebook Ads connector save an average of 3-5 hours per month per client on reporting. Those hours go back into campaign management or new business.
MetricWiz: A Purpose-Built Facebook Ads Community Connector
Most connectors treat Facebook Ads as one of dozens of integrations. MetricWiz takes a different approach: it focuses on Meta Ads data in Data Studio, with a TikTok Ads connector also in development.
That focus means the setup is simpler, the metric coverage is deeper for Meta Ads specifically, and the price reflects the product's focused scope. MetricWiz is listed in the official Data Studio Connector Gallery, which means it installs directly inside Data Studio. No separate account, no data warehouse, no middleware.
Plans start at $7/month, with discounts for semi-annual ($5/month) and annual ($4/month) plans. The 14-day free trial requires no credit card.
How to Set Up a Facebook Ads Connector in Data Studio (5 Steps)
The setup process below applies to MetricWiz and other community connectors from the Data Studio Gallery.
Step 1: Open Data Studio and create a new data source
Go to lookerstudio.google.com, click Create, then select Data source. If you're already in a report, click Add data in the top menu.
Step 2: Search for the connector in the Gallery
In the connector search bar, type MetricWiz (or the name of your chosen connector). Click the result to open the connector setup screen.
Step 3: Authorize your Facebook account
Click Authorize and log in with the Facebook account that has access to your ad accounts. Grant the requested permissions (these allow the connector to read your Ads Manager data). You'll be redirected back to Data Studio after authorization.
Step 4: Select your ad account
Use the dropdown to select the Facebook Ad Account you want to pull data from. If you manage multiple accounts, repeat this process to create additional data sources.
Step 5: Connect and start building
Click Connect. Data Studio will load the available fields (metrics and dimensions) from your Facebook Ads account. Click Create report or Add to report to start building your dashboard.
Total time from search to live data: under five minutes for most users.
Available Metrics and Dimensions
A Facebook Ads Data Studio connector gives you access to the same data available in Ads Manager, structured as Data Studio fields you can use in any chart or table.
Core Metrics
| Metric | What It Measures |
|---|---|
| Spend | Total amount spent in your selected date range |
| Impressions | Number of times your ads were shown |
| Clicks (All) | Total clicks on your ads |
| Link Clicks | Clicks specifically on the ad's destination link |
| CTR | Click-through rate (clicks / impressions) |
| CPC | Cost per click |
| CPM | Cost per 1,000 impressions |
| Conversions | Total conversion events (purchases, leads, etc.) |
| ROAS | Return on ad spend (conversion value / spend) |
| Cost Per Result | Spend divided by your campaign's primary result |
| Reach | Unique accounts that saw your ads |
| Frequency | Average number of times each person saw your ad |
Breakdowns (Dimensions)
| Breakdown | Use Case |
|---|---|
| Campaign | Performance by campaign |
| Ad Set | Performance by audience/targeting group |
| Ad | Performance by individual creative |
| Age | Demographic breakdown by age group |
| Gender | Demographic breakdown by gender |
| Country | Geographic performance |
| Region | State/province-level geographic data |
| Placement | Facebook Feed vs Instagram vs Audience Network, etc. |
| Device | Mobile vs desktop performance |
| Publisher Platform | Facebook vs Instagram vs Messenger |
Using Data Studio's filter and dimension controls, you can slice any metric by any dimension (for example, ROAS by placement or CPC by age group) without any additional setup.
Facebook Ads Data Studio Connector Pricing: 2026 Comparison
The price difference between connectors is significant. Here is how the main options compare:
| Connector | Price | Type | Facebook Ads Focus | Free Trial |
|---|---|---|---|---|
| MetricWiz | From $7/mo ($48/year) | Community connector | Specialist (Meta Ads; TikTok coming soon) | 14 days, no CC |
| Porter Metrics | $15/mo | Community connector | Multi-platform | Yes |
| Coupler.io | $24/mo (annual) | ETL platform | Multi-platform | 14 days |
| Windsor.ai | $19/mo | ETL platform | Multi-platform | Yes |
| Supermetrics | From €29/mo | ETL platform | Multi-platform (100+ sources) | 14 days |
| Funnel.io | $200/mo minimum | ETL platform | Enterprise, multi-platform | Yes |
MetricWiz is the lowest-priced paid Facebook Ads connector available for Data Studio in 2026, starting at $4/month on the annual plan. If you're not using 40 additional data sources, you're paying for features you'll never use with the larger platforms.
The $48/year annual plan covers unlimited ad accounts and unlimited Data Studio reports. There are no per-seat fees and no data volume limits.
Community Connector vs Enterprise ETL Tool: Which Do You Need?
The choice depends on your reporting needs.
Choose a community connector (like MetricWiz) if:
- Your reporting is primarily Facebook Ads and Meta Ads data
- You want reports inside Data Studio, not a separate platform
- You're an agency or freelancer managing client accounts on a budget
- You don't need a persistent data warehouse or historical data beyond what Facebook stores
- Setup simplicity matters. You want data flowing in under five minutes.
Choose an enterprise ETL tool (like Funnel.io or Supermetrics) if:
- You're combining 20+ data sources from multiple platforms
- You need a data warehouse with long-term historical storage
- Your organization has dedicated data engineering resources
- Budget is not a constraint
For the majority of performance marketers, freelancers, and small-to-mid-sized agencies, a community connector provides everything needed at a fraction of the cost.
Frequently Asked Questions
Q: Is MetricWiz the same as the old Google Data Studio Facebook Ads connector?
Google Data Studio was rebranded as Data Studio in 2022. MetricWiz is a Data Studio Community Connector that works in Data Studio (previously called Google Data Studio). If you've been searching for a "Google Data Studio Facebook Ads connector," MetricWiz is what you're looking for.
Q: Does the connector update my Data Studio data automatically?
Yes. Data Studio fetches fresh data from the connector each time a report loads, or on demand when you click Refresh. You can also set reports to refresh on a schedule. There is no manual export or upload step required.
Q: Can I connect multiple Facebook Ad Accounts to one Data Studio report?
Yes. Each ad account requires its own data source, but Data Studio supports blending multiple data sources in a single report. Create one data source per ad account, then blend them or use separate pages within the same report.
Q: What happens if my Facebook token expires?
Facebook requires periodic re-authorization. If your token expires, the connector stops pulling data. To fix it: open the data source in Data Studio, click Edit connection, and re-authorize with Facebook. This typically takes under two minutes. MetricWiz's help documentation covers the reauthorization steps in detail.
Q: Does MetricWiz support Instagram Ads data?
Yes. Instagram Ads are managed through Meta's advertising platform and the Facebook Marketing API. MetricWiz pulls Instagram Ads data through the same connection. You'll see it in your placements breakdown as Instagram Feed, Instagram Stories, etc.
Get Started with MetricWiz
MetricWiz is listed in the Data Studio Connector Gallery. The 14-day free trial starts the moment you connect your first ad account. No credit card required.
Try MetricWiz free for 14 days
Setup takes under five minutes. Your Facebook Ads data will be live in Data Studio before your next client call.
