Connect Facebook Ads to Looker Studio


Maintain your SEO traffic with seamless website migration. Schedule a consultation and start your brand relaunch!

“How do I import Facebook Ads data into Looker Studio?”
“How do I connect our Facebook leads with Looker Studio?”
“Is there a way to integrate Facebook and Looker Studio?

Digital marketer

*Google Looker Studio is formerly known as Google Data Studio.

Facebook Advertising is an integral part of the modern marketing industry. However, reporting on this channel can be a challenging and time consuming. The Facebook Ads API is complex and the interface is often confusing to use but reporting and data visualization are needed.

Facebook and Google Are at War with Each Other

Looker Studio is a powerful data visualization platform. But it doesn’t integrate with Facebook Ads data well. There’s no built-in solution as both companies are separate entities. Thus, it is often recommended to invest in a paid software as a solution to this issue. This can bridge the gap between the two tools for an improved reporting experience.

Who Benefits from this Automation?

I see two groups that might benefit from the automation to import Facebook Ads to Looker Studio. Both teams require time to constantly update email messages.

a) Facebook marketers: Facebook marketers are great at optimizing campaigns. But they don’t have the time to build reports. They need to dedicate hours strategizing which audience to advertise to.

b) Data analysts: Analysts don’t need to spend too much time drudging manual work. They need to have all the data presented without having too many hours wasted.

Why Pay for Automation at All?

Automations solve huge problems in organizations. So, most automation tools are paid products. Yes, you can do everything manually for free to save money. But in perspective, you might want to spend a little to save time. The number of hours that you take back to avoid hellish and repetitive work is worth the price.

busy desktop

I hate a super cluttered desktop. You ever experienced a desktop full of spreadsheet files? I hate them. It increases stress and productivity comes to an all-time low. The amount of time I clicked the Export CSV button is unbearable. Automation avoids all of this and is useful when you’re tracking marketing campaigns.

How to Connect Facebook Ads with Looker Studio

An option to import Facebook Ads data to Looker Studio is to use a paid third-party connector. It’s free and is enough to start building dashboards. You’ll use Two Minute Reports for this example. TMR imports data from the API directly to Looker Studio in minutes. Another connector to use is Supermetrics.

*You can also connect and import Facebook Ads data to Google Sheets.

tmr looker 01

Create Data Source

1 – Go to Looker Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

data source google data studio

1 – Go to Looker Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

data source google data studio

3 – Search for Two Minute Reports and look for the Facebook Ads connector.

facebook ads looker 01

4 – Once inside, click on the blue Authorize button if it appears. Once clicked, a pop-up appears.

facebook ads looker 02

5 – Once inside the pop-up, click on Allow to access your Google account.

6 – Then click on the other blue Authorize button. And a new pop-up appears.

facebook ads looker 04

5 – Inside the pop-up, name your Facebook Ads data source.

6 – Click on Login with Facebook. This authorizes the tool to acquire the Facebook account setup.

Go through the entire login process in Facebook. Select the Facebook Manager account for your use case.

facebook ads looker 05b

7 – If it appears, click on Yes to create a query config for this data source.

ga4 data studio 14 tmr

Next to create a query configuration.

8 – Under Name, give your Facebook Ads query a name.

9 – Under Use (Data Source), select the Facebook Ads data source you added and named earlier.

10 – Under Ad Accounts, select the Facebook Ads property you’d like to get data from.

11 – Under Data Options, add checkmarks to Include missing time values and Replace blank metrics with zeros. This is optional and you may skip this part.

12 – Click on Save.

facebook ads looker 06

Then you’ll go back to the Looker Studio as before.

13 – Under Select Query Config, select the Facebook Ads query configuration you created earlier.

facebook ads looker 03

14 – Click on the blue Connect button on the upper right. You can click on the blue Create a Report button on the upper right of the page. Otherwise, you can also do the option below.

Viola! This data source is now saved to your Looker Studio workspace.

Create Report

1 – Go to Looker Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

ga4 data studio 09

3- Once inside, click on My data sources in the navigation.

ga4 data studio 10

4 – Find and click on the Data source you added earlier.

5 – Click on the Add button on the bottom right.

6 – Click on the Add to Report button if it appears.

ga4 data studio 11

7 – Name your dashboard on the upper left.

8 – Click on Add a control from the top. Click on Date range control and drag it on the canvas.

data range control google data studio

9 – Click on Add a chart from the top. Click on the first Scorecard and drag it onto the canvas.

scorecard seo dashboard

10 – Click on Add a chart from the top. Click on the first Time series and drag it onto the canvas.

line chart google data studio

You would see something like this…

data studio seo

1 – Go to Looker Studio.

data studio dashboard for seo

2 – Click on + Create in the top left. Then click on Data source.

ga4 data studio 09

3- Once inside, click on My data sources in the navigation.

ga4 data studio 10

4 – Find and click on the Data source you added earlier.

5 – Click on the Add button on the bottom right.

6 – Click on the Add to Report button if it appears.

ga4 data studio 11

7 – Name your dashboard on the upper left.

8 – Click on Add a control from the top. Click on Date range control and drag it on the canvas.

data range control google data studio

9 – Click on Add a chart from the top. Click on the first Scorecard and drag it onto the canvas.

scorecard seo dashboard

10 – Click on Add a chart from the top. Click on the first Time series and drag it onto the canvas.

line chart google data studio

You would see something like this…

data studio seo

At this point, you now have a solid foundation for adding data to the dashboard. You can add other dimensions and metrics from the Facebook API. Design your Facebook Ads dashboard further by using the navigation on the right.

Designing a comprehensive dashboard requires dedication and time. It requires a deep understanding of Looker Studio. You may copy dashboard templates from other websites. How do you now copy a Facebook Ads dashboard from another source?

How to Copy a Facebook Ads Dashboard Template

Copy a dashboard template from another source if you don’t have the time to build your own dashboard. Here’s are Facebook templates that you can copy.

1 – Click on the three dots on the upper right. This is the More options button.

2 – Click on Make a copy.

ga4 data studio 02

3 – Under New Data Source, find the data source you created earlier. In this case, you need to select the Facebook Ads data source.

ga4 data studio 03

4 – Click on Copy Report.

Viola! At this point, the template shows your data from your Facebook manager account. After which, you can update and tweak for your specific needs.

Conclusion: Facebook Ads Reports in Looker Studio is Possible

Connecting data from Facebook Ads to Looker Studio is now easier than ever. There are various methods available for API integrations between these two powerful tools. While some connectors may need a fee, the benefits are well worth the investment.

Avoid the hassle of importing and exporting spreadsheets. Maintain everything step-by-step in Looker Studio with the help of any necessary tools. Stop wasting time on mundane tasks and focus on the things that have an impact on the success of your business. Consider hiring a web analyst to help you if needed.


About The Author

photo