How to Get Facebook Ads Data in Looker Studio

By integrating Facebook Ads with Looker Studio, you can create live campaign dashboards and visually engaging reports to optimize ROI. Follow the below steps to move your Facebook Ads data in Looker Studio with Two Minute Reports.

Step 1: Streamline your Facebook Ads account in Looker Studio

  • Select Facebook Ads from the list of connectors.

  • Next, connect your Facebook Ads data. Click New Connection to start creating your Connection in Looker Studio.
A Connection is a link between the data source and the Connector. For example, you must use the Facebook Ads Connector to create a Connection with your Facebook Ads account to get your ads data.

  • The Adding new connection dialog box appears. Here you can connect the required Facebook Ads account in two easy steps:

  • Creating a Connection: Name your Connection and authorize the Gmail account associated with your Facebook Ads account.

  • Select accounts to use: Enable the accounts for which you want to run queries. Once done, Speedboost is automatically activated, allowing you to retrieve Facebook Ads data within seconds. Please note that you cannot run queries from disabled accounts.

Once an account is enabled, Speedboost performs two key functions:

  1. Warm-up – Prepares your account for faster data retrieval by caching your historical data. 
  2. Periodic sync – Ensures your data stays updated automatically at regular intervals.

Note: You can only fetch Facebook Ads data up to one year.

Step 2: Configure your Facebook Ads account with TMR

  • In the Query Configs section, click + Add New.
Query Config lets you group multiple accounts, making it easier to view centralized insights in your Looker Studio dashboard.
  • The Adding New Query Configuration dialog box appears. Name the query config and select (from the list of enabled) accounts from the dropdown and configure your Facebook Ads report. Once done, click Save.

  • You’ve successfully created a new configuration. Now you can use this Query Config to extract data from your Looker Studio reports.

Step 3: Create a Facebook Ads report with TMR in Looker Studio

  • After creating the Query Config, click Create Report at the top-right corner as shown below:

  • Select the Query Config that you’ve created (in our case, it’s ‘FB AD TEST’) from the list of options. Click Next and choose ‘Create report from scratch’ to open the Looker Studio dashboard.

Note: You can also quickly get started by choosing relevant Facebook Ads Looker Studio templates to generate client-specific reports.

  • Once the Looker Studio dashboard opens, select your team and the required Query Config from the dropdown. Next, click Connect at the top-right corner.

  • Once you click Create Report, you’ll be directed to the Looker Studio dashboard. Here you can drag and drop the associated Facebook Ads metrics and dimensions to analyze campaign insights faster.

  • To make your Looker Studio report compelling, use charts and visualizations. Click Add a chart and choose relevant chart types to configure your dashboard.

For example, you can use bar charts to showcase your Facebook campaign trends and scorecards for highlighting crucial KPIs. You can also add date range control to visualize campaign performance for a specific period.

Note: When using excessive charts and other visualizations, your Looker Studio dashboard might slow down in execution. Try our five tips to increase the speed of your Looker Studio reports to optimize the performance of your Looker Studio dashboard.

We hope you found this article helpful. If you have any questions, please contact our support team via support@twominutereports.com.

Was this helpful?