blog post

Connect Facebook Public Data to Looker Studio: How-to, templates and metrics..

Florian Cabirol
November 21, 2023
Connect Facebook Public Data to Looker Studio: How-to, templates and metrics..

Quick steps to create a Facebook Public Data report with Google Sheets:

You can easiliy create a Facebook Public Data report following this step :

  1. Get informations from the data integration from our Facebook Public Data connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Facebook Public Data data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Facebook Public Data report with Looker Studio:

You can easiliy create a Facebook Public Data report following this step :

  1. Get informations from the data integration from our Facebook Public Data connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Facebook Public Data at the end of the page.

The tutorial

Quick steps to create a Facebook Public Data report with PowerBI:

You can easiliy create a Facebook Public Data report following this step :

  1. Get informations from the data integration from our Facebook Public Data connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Facebook Public Data at the end of the page.

The tutorial

Unleashing Your Data's Potential: Integrating Facebook Public Data with Looker Studio

Welcome to our comprehensive tutorial on how to seamlessly connect your Facebook Public Data to Looker Studio (formerly Google Data Studio). By the end of this guide, you'll be empowered to transform your Facebook marketing metrics into visually compelling and insightful reports, enabling data-driven decisions to propel your marketing efforts to new heights.

How to Connect Your Facebook Public Data Account to Looker Studio

Create an Account on Looker Studio

If you're new to Looker Studio, your first step will be to set up an account. Existing users can simply link their Google account to Looker Studio for a fluid experience.

Looker Studio Account Creation

Connect Facebook Public Data to Looker Studio

To bring your Facebook Public Data into Looker Studio, we've crafted a detailed, step-by-step process for your convenience. Please adjust any steps as necessary to ensure ease of implementation.

  • Navigate to your Looker Studio dashboard and click on "Create".
Create button on Looker Studio dashboard
  • Select "Report" from the options presented.
Select Report in Looker Studio
  • Within the data sources gallery, locate the Catchr Facebook Public Data connector.
Catchr Facebook Public Data connector

Step-by-step Guide on the Authorization Step

When connecting for the first time, you will need to authorize both Looker Studio and Catchr to communicate. The process for gaining the necessary permissions is outlined below:

  • Authorize access to Looker Studio by clicking the community connector authorization prompt.
Looker Studio Authorization
  • Choose the appropriate Google Account to link with Looker Studio.
Select Google Account
  • Carefully review the authorization details, then scroll to the bottom to proceed.
Review Authorization Details
  • Click "Allow" to grant access permissions.
Allow Access

Having authorized your Google Account for use with Looker Studio, it's time to set up the Looker Studio connector for Facebook Public Data, provided by Catchr.

  • Press the second 'Authorize' button, noted as 'Facebook Public Data requires authorization,' to link your data.
Connector Authorization Button
  • Follow the straightforward instructions in the popup to give Catchr the green light to connect with your Facebook Public Data account.
Catchr Authorization Instructions
  • After a brief load time, select the account that Catchr will access and hit "Add".
Select Account
Add Account Button

You've now successfully integrated your Facebook Public Data with Looker Studio through Catchr, setting the stage for enhanced analytics and reporting.

Example of Metrics You Can Use with the Looker Studio Integration for Facebook Public Data

The integration of Facebook Public Data with Looker Studio opens a treasure trove of metrics that can elevate your marketing insights. With data at your fingertips, you can analyze performance, track audience engagement, and refine your strategies accordingly. To provide a comprehensive understanding of the available metrics, please visit our detailed fields listing.

Page Insights: Utilize Page Id, Page Name, or Page Category to gain a macro-view of your audience's demographic or to drill down into the minutiae, such as specific reactions to individual posts. Cohort analysis through Year, Month, or Week metrics can reveal temporal trends in Page engagement.

Post Analytics: Investigate Post Id, Post Created At, or Post Type to dissect your content strategy. Are certain types of posts—like videos or updates—resonating more with your fans? By analyzing Reactions per post or Shares Count, you can quantify which posts fuel virality, promoting brand reach.

User Engagement: Metrics like Fan Count and Comments Count help quantify your Page's audience growth and interaction level. Benchmark Engagement rates using likes, comments, and shares to refine content and ensure it aligns with user interests.

Looker Studio enhances these metrics by offering various visual representations, from simple bar graphs and pie charts to complex scatter plots and geographic maps. Customizable dashboards empower marketing professionals with the ability to present data in an accessible, easily interpretable format, ultimately informing strategic decision-making and optimizing your Facebook presence.

No items found.

In this Facebook Public Data template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Facebook Public Data template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Facebook Public Data

Import your Facebook Competitor metrics in Google Sheets : How-to, metrics and more

Unlock the power of social media analytics with our step-by-step tutorial on integrating Facebook Public Data into Google Sheets via Catchr. This guide is perfect for marketers looking to convert vast amounts of Facebook data into actionable insights for enhanced strategy formulation. Learn how to fetch, organize, and analyze key metrics and dimensions to boost your marketing efforts, all within the convenience of Google Sheets. Ideal for those aiming to leverage data for competitive analysis, content optimization, and performance tracking.

Florian Cabirol

Explore your Facebook Page Competitor KPI with PowerBI: How-to, templates and metrics

Unlock the power of your Facebook Public Data by integrating it with PowerBI through Catchr. This step-by-step guide shows you how to create dynamic marketing dashboards, offering insights into page followers, post engagement, and more. Transform your data into actionable intelligence to enhance your marketing strategy.

Florian Cabirol

Connect Facebook Public Data to Looker Studio: How-to, templates and metrics..

Connect your Facebook Public Data to Looker Studio to spy on your competitors and know when things happen.

Florian Cabirol