blog post

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

Florian Cabirol
January 31, 2024
Import your Facebook Competitor metrics in Google Sheets : How-to, metrics and more

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

In this comprehensive tutorial, you'll learn how to effortlessly translate the wealth of data available on Facebook Public Data into actionable insights within Google Sheets. By the end of this tutorial, not only will you be able to automatically fetch and organize key metrics and dimensions from Facebook Public Data but also tailor your analysis and reporting for enhanced marketing strategies.

How to connect your Facebook Public Data account to Google Sheets

Add a source on Catchr

To kickstart the process, navigate to the Catchr homepage. Here, select the Source option from the left-hand menu before clicking on Add a Source located at the top right corner. Choose Facebook Public Data as your platform, and follow the prompts to authorize Catchr, thus linking it to your selected platform.

Adding Facebook Public Data as a source in Catchr

Create a New Query

Next, open up Google Sheets and from the menu, select the Catchr addon. Choose the option New Query to start compiling your Facebook data effectively.

Select Your Data Source

In the query builder, select Facebook Public Data from your list of data sources. If it doesn't appear, simply click on the "+" button to add it anew.

Selecting Facebook Public Data as your data source

Select Your Account(s)

Move to the Select account(s) tab and pick the Facebook account(s) you wish to utilize for data extraction.

Selecting specific Facebook accounts for data extraction

Choose Metrics and Dimensions

Once your accounts are selected, navigate to the Metrics and Dimensions tabs to decide on the data points you want in your query. Consider including the following:

Metrics:

  • Page Views: Tracks the number of times a page was viewed.
  • Fan Count: Reveals the total number of users who have liked the Page.
  • Talking About Count: Shows the number of people discussing the Page.
Selecting metrics for your query

Dimensions:

  • Page ID: Identifies the Facebook Page.
  • Page Name: Displays the name of the Page.
  • Page Category: The category associated with the Page, e.g., Product/Service.

Ensure the metrics and dimensions match your analysis and reporting requirements.

Selecting dimensions for your query

Set Date Range

Proceed to the Date Range tab to choose a preset or custom period for your data. This ensures you gather insights from the specific timespan you're interested in.

Setting the date range for your data query

Apply Filters

To refine your data further, utilize the Filters tab. Here's an example filter setup:

  • Field: Country
  • Operator: Equals
  • Value: United States
Applying filters to refine your data

Schedule & Customize Data Refreshness

Finally, in the Options tab, set up automatic data refreshes to keep your insights current. You can select beneficial features such as "Appends rows" to continuously add new data or "Combine rows" for comprehensive updates.

Scheduling data refresh and customizing options

This completes the integration process. You've now unlocked a powerful synergy between Facebook Public Data and Google Sheets through Catchr, allowing for dynamic data analysis and reporting.

Example of Google sheets you can create to use with the Facebook Public Data source.

With the data from Facebook Public Data at your disposal in Google Sheets, countless opportunities for analysis and insights are available. Here are a few examples of how you can utilize this data:

  • Performance Dashboard: Create a live dashboard that tracks the key performance indicators (KPIs) for your Facebook pages. Monitor fan count growth, engagement levels through reactions and shares, and the overall reach of your posts. Use charts and graphs to visualize trends over time and make data-driven decisions to improve your social media strategy.
  • Content Analysis Sheet: Compile a comprehensive analysis of your posts' performance. Evaluate which types of content (videos, images, text) yield the most engagement, the best time to post, and which topics resonate with your audience. This insight can guide your content creation process, leading to higher engagement rates.
  • Competitor Comparison: Leverage public data to compare your page's performance with competitors. Analyze fan growth, engagement, and content strategy to identify what they're doing well and where you can differentiate. This comparative analysis can highlight opportunities for gaining a competitive edge on the platform.

These are just a few ways to leverage Facebook Public Data through Google Sheets. The versatility of Catchr allows you to tailor your analysis to meet specific objectives, empowering you to make informed decisions based on robust social media data.

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