How to connect Facebook Ads / Meta Ads to Looker Studio with Supermetrics, Funnel, …?
Need a connector to get your Facebook Ads data to Looker Studio but not sure which one to pick? Here’s a few options that do the trick!
As of today, there is no free in-house Google connector to retrieve Facebook Ads data and send them to a Looker Studio report. But at least there are a few options on the table: write your own API (not recommended…), use BigQuery (complicated, though Google provides a nice tutorial), or subscribe to a third-party connector. In this article, we’ll investigate this third option and will show you how to connect Facebook Ads / Meta Ads to Looker Studio with Supermetrics, Funnel, … (logic is the same whatever the connector you choose).
Looker Studio connectors we use on a daily basis and are happy with (w/ free trials): Supermetrics - Windsor - Catchr - PMA - Funnel
Not sure which one to pick? Reviews here and there. Still unsure?! Contact us with your tech stack and budget, and we’ll guide you in the right direction:
Why is it a good idea to monitor your Facebook ads performances in Looker Studio?
You’ve got a Business Manager right, it should do the trick? Well, if you advertise online, there are high chances that you do so on Facebook Ads, but also on Google Ads, TikTok Ads, … And you don’t want to spend your time juggling between 3 different BMs. it makes it difficult to compare properly. And if you’re running a Shopify, Prestashop, … so it’s a very good idea to get ALL your reportings in a single dashboard.
Plus, having all your Ads data centralized in Looker Studio can help you make proper comparison and invest wisely. We’ve also written an article about that that you can find here, so all data are shown in a single table.
Ok, I’m in, but which connector should I choose?
This will depend on the number of accounts you’re managing and your budget, but also what are your other tools you want to connect. If you’re only connecting one Facebook Ads account, there are even free options! But if you want to chime in a Shopify account, a TikTok account, then you may want to understand plans and their prices.
The offer is wide out there, hence we’ve selected for you a few connectors:
Supermetrics: solid option that does the job with a lot of connectors available, and a reasonable price for up to 3 data sources / 3 accounts each
Funnel: most powerful option as you can pre-blend your data directly in the tool and only use one Looker Studio connector to display all of your data. Might come with a higher price point if you’ve got many data sources / accounts, but to be mentioned, there is free plan!
Catchr: Another good solution that offers a friendly priced single-connector plan
Power My Analytics: A good trade-off also, as price does not go wild when you increase your number of connectors / accounts
Windsor: Again, a cheap option for up to 3 data sources, but it comes with a more complicated set-up (although if you’re tech-saavy, shouldn’t be an issue)
What do I do next?
Well, pretty easy:
Connect your accounts to the connector you’ve choosen (most of them offer free 7 or 14-days trial, you might want to test out a couple to check which one you prefer), it’s very straight-forward, just grant access to your facebook ads, and the tool with get your data ready to be sent to Looker Studio
Create a Looker Studio report
Add the Facebook Ads data source from the connector by searching Facebook Ads in the data source list, and picking up the right one
And voilà, you’ve got a ,ew data source that can get you all your ads data!
What should I put in my report? Again, another article to guide you there.
In this article, we’ve seen how to connect Facebook Ads / Meta Ads to Looker Studio with Supermetrics, Funnel, … .
PROBLEM SOLVED
Tools we use and we like:
Todoist: for tasks management
Monday: for projects management, when tasks fall short
Tropical Server: our friends in charge of the hosting of this very website!
Tools we’d like to use (if we had the budget…):