blog post

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

Florian Cabirol
January 29, 2024
Explore your Facebook Page Competitor KPI with PowerBI: 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

Integrate Your Marketing Data Seamlessly

Through this tutorial, you will discover how to effectively link your Facebook Public Data with PowerBI to create dynamic and insightful marketing dashboards. By the end of this guide, you'll be able to access, analyze, and visualize your marketing metrics in PowerBI with ease.

How to connect your Facebook Public Data account to PowerBI

Add a source on Catchr

To begin, visit the home screen of Catchr and locate the Source option in the left sidebar. Click on "Add a Source" positioned in the upper right corner.

Once there, choose the appropriate platform from the provided list and proceed with the sign-in process to bridge Catchr with the selected service.

Adding a source in Catchr

Create the request to transfer Facebook Public Data to PowerBI

Let's dive into the steps that will allow you to funnel Facebook Public Data into PowerBI:

  • Navigate to API on the Catchr sidebar.
API selection in Catchr
  • Advance by changing the output format to "PowerBI".
Export format selection
  • Select the "Source" tab and choose "Facebook Public Data".
Choosing the platform to export data from
  • Pick the specific accounts you wish to derive data and KPIs.
Account selection for data extraction
  • Opt for the indicators and dimensions for your data request.
Metrics and dimensions selection
Further metrics and dimensions selection
  • Warning: Utilizing a template? Ensure you've checked all required dimensions and metrics as listed on Catchr’s template page for a smooth auto-loading of your template.
  • Time to decide on the period for which you require data.
Time period selection for data extraction
  • If necessary, apply filters to hone in on your data.
Adding filters to data request
  • Add platform-specific options should your query require them.
Additional options for request
  • Once set, a unique URL will be generated. Before proceeding, use "Preview" for a glance at the outcome.
Previewing data
Data preview
  • Upon satisfaction, secure the URL, as it's imperative for the subsequent PowerBI linkage.
Data request URL

Import the Facebook Public Data and KPI to PowerBI

PowerBI Desktop

In PowerBI Desktop, import your Facebook Public Data by navigating to Get Data followed by Web.

  • Remain in the basic mode and input the URL you received from Catchr.
Get Data from web option
  • Following the URL insertion, click on OK.
Pasting the URL for data import

PowerBI may need a moment to assimilate your data. Subsequent to the import, you're free to modify your query and field types using PowerBI Query. Thereon, you can materialize your tailored dashboard, which can then be published and shared as needed.

To deploy a dataset within the PowerBI Web App, simply publish it from the desktop version to access and draft new reports within your browser.

Example of metrics you can use with the PowerBI Integration for Facebook Public Data

Understanding the vast array of metrics accessible with Facebook Public Data can elevate your marketing insights. With PowerBI's capabilities, data such as Page Followers, Posts Engagement, and Audience Sentiment Analysis can be merged into visualizations that clearly convey your brand's social performance.

Certain metrics like Post Reactions can be aggregated to measure overall engagement, while others like Comments Count can drill down into specific audience interactions. By leveraging these in PowerBI, one can create comprehensive dashboards to track campaign performance, audience demographics, and conversion metrics over time.

For an exhaustive list of metrics and their definitions, explore the full field listing for Facebook Public Data at Catchr’s Metric Guide.

With Catchr and PowerBI, your data isn't just numbers—it's a narrative of growth, engagement, and opportunity, waiting to be told.

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