How to create a Facebook Page Insights Dashboard on Google Data Studio

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

By the way, you can request our support team to set up your first Facebook Insights report for free with you by scheduling a call here (no sales pitch). 

This is a step-by-step guide to connect your Facebook Insights data to Google Data Studio to automate your Facebook pages reporting

We don’t expect you will read this whole long article, but it will be your go-to resource to understand all the Facebook pages metrics and report them on Data Studio. 

Does Facebook Analytics shutdown affect Data Studio reporting?

Some users have asked if the Facebook Analytics shutting down will affect your Google Data Studio reporting. 

The answer is no. Facebook Analytics and Facebook Insights are different products; Facebook Analytics is for website behavior tracking (like Google Analytics) and Facebook Insights is for page metrics (for organic efforts). 

Free options to connect Facebook Insights to Google Data Studio

We’ve seen many people looking for free Facebook Insights connectors for Google Data Studio

The current only free way to connect Facebook Insights to Data Studio is first sending your data to Google Sheets first and then connecting it to Google Data Studio. 

Porter is a provider of these connectors; we have an idea of why nobody currently offers a freemium model (aka an always free, limited product) instead of just a free trial. 

It turns out that sustaining any connector is super challenging for everyone. It is an ongoing and not a one-time task. If someone decided to build a free connector, chances are they will be outdated or be affected within a few months. 

As providers, we need to constantly update and fix these connections; we’re dependent on Facebook API updates. 

The latest iOS 14 updates, for instance, represented a major change for the product. Often, Facebook updates and deprecates fields and their API versions. To maintain the product, there should always be a developer behind it. 

To set expectations, all the Facebook Pages Insights connectors in the market are paid (they should be). 

If you’re still not willing to pay for a connector, you can still send your Facebook Insights data for free to Google Sheets and connect your spreadsheet to Google Data Studio, but it’s manual or pretty limited. 

Just as with Data Studio, automatically pulling data from Facebook to Google Sheets requires ongoing developer effort. So, Google Sheets connections—while there could be freemium options—will be limited anyway, and the direct connection is more powerful and flexible than having Sheets in between. 

As the current only option, the best way to report Facebook Pages Insights on Data Studio for free is to manually export by going to the Facebook pages insights and click on Export data. 

Facebook pages Insight dashboard

Then you will upload the CSV file on a Google Sheets and connect it to Data Studio

We’ve got a tutorial on reporting Google Sheets on Data Studio

Create your first report in Google Data Studio

 Facebook Pages Insights connector for Google Data Studio

We’ll learn how to import Facebook Pages insights data to Google Data Studio automatically through a connector. 

For this tutorial, of course, we will use our Porter Metrics Facebook Pages Insights connector. It is self-promotion, but will also mention why we made it the best solution available. You can instantly start a 14-days free trial. 

You can access the Facebook Insights connector in three ways: 

If you access through our website or link, you will download our default report template to speed up your reporting; if you access through the connector gallery, you will start with a blank report. 

Signing in with Google and Facebook

Once on the connector, signup with your Gmail account to create your Porter account. We only take your email and not any other personal information. 

Authorizing your Facebook profile on Google Data Studio

Then, you should sign in with your personal Facebook account so Porter can retrieve all the Facebook pages associated with that profile. 

Signing in with a Facebook profile for an authorization

When linking your Facebook profile, Facebook will ask you to check the Facebook pages you want to connect to Google Data Studio. 

We suggest you check them all at once so they can display in the Google Data Studio list. 

Some users only check the pages they want to report at that moment, and when they want to connect a new Facebook page, it won’t show up in the Data Studio list. 

If your Facebook pages are not showing up on Google Data Studio, read this guide to learn to connect them from your Facebook profile by granting access to Porter.

About privacy: we only get your emails to create users. We don’t bring any other information or share it (on purpose) with third parties. 

While Facebook says we can manage and access your accounts, Porter does only connect to the API to bring data to Google Data Studio. 

Here’s our video tutorial on connecting your data to Google Data Studio

You don’t need to be a Facebook page administrator to connect your pages data to Data Studio. Other page roles like analyst work, too. 

Choosing your Facebook pages

Once signed in, you will be allowed to bring one or more Facebook pages to your Google Data Studio report. 

We made it possible to bring multiple (or all) Facebook pages in a single data source

Facebook pages dropdown on Google Data Studio

With this feature, a company could know the likes, follower, reach and engagement of all their pages in a single dashboard. Quite useful for companies reporting on multiple brands or franchises. 

Finish the setup

Just click on Connect in the top right corner of the page. 

In the next view, you will see all the fields available on our Facebook Pages Insights connector for Google Data Studio. 

You will see a list of more than 70 fields available (so far) with your post, messenger, audience, and page data. 

Now click on Connect on the top right corner to generate our default report template. 

If you successfully bring Facebook pages data to your Google Data Studio report, you’re officially starting a 14-days free trial. You may want to check out our friendly pricing here

Again: If you started using the connector from the link we provided, you’ll get our report template; if you did it from the Data Studio connector gallery, you will load a blank report. 

The report template is meant to save you time, but you’re free to start reporting from scratch. 

So far, we have already created our first Facebook pages report on Google Data Studio, but we can play around a bit more with the connector to see what it offers. 

Here, you can choose three ways for reporting:

Before playing around with the charts, we’ll explain all the Facebook Pages Insights metrics and dimensions. 

BTW, we encourage you to install the Google Data Studio Helper, a Google Chrome extension to let you have our support chat directly on Data Studio

Understanding Facebook Pages metrics and dimensions 

We can set up our Facebook pages report on Google Data Studio by navigating all its fields, metrics, and dimensions available. 

The way we see Google Data Studio is that it’s a canvas where you drop any type of chart, combining any sort of metrics and dimensions. 

The metrics are the numerical values, like page likes, post engagements and reach; dimensions are how you break down the metrics, like by country, by date, by post image, etc. 

If it’s your very first time with Data Studio, I would recommend you to check this resource to create your first Google Data Studio report

To help you navigate through the Facebook pages metrics, I would recommend watching this tutorial on creating charts and graphs

Followers metrics and dimensions

The community size metrics are the basis of our audience in social media. Facebook Page Insights allow social media strategists to get a better understanding of the users that like our brand or company and its message. 

The metric “followers”, provides information about our community’s behavior. Followers are those users who have chosen to get the updates that you post in their news feed. 

Followers are a way to measure your Facebook audience size, along with page likes (which are different metrics). 

These are the follower-related metrics your can track with our connector: 

  • Page new followers: shows the number of new followers your page is getting over time
  • Page new unfollows: shows 
  • Page total followers: unlike new followers where you can visualize data over time, this metric will only display a fixed value of the current total followers your Facebook page has. 

Just try displaying these three metrics in the same graph, you will see a variation overtime. 

If your new followers metric is higher compared to the previous time period, it is an indicator that gives you an idea of the relevance of your content.

On the other hand, if you have a variation that impacts the “unfollow” metric and shows an upward trend on the graph, you might think about what you’ve done (or didn’t). This metric is telling you that you have to take action now!

Likes metrics and dimensions

Like followers, page likes are an indicator of audience growth and engagement. You can use the following metrics to track it:

  • Page total likes: displays the total number of likes a page has, regardless of the time chosen. Generally used as a scorecard. If you create a time series with this metric, it will display the total likes your page had every day. 
  • Page new likes: show the number of likes your page has received on a timespan. It should be combined with the dimension Date (which is the page date). And not a post date. 
  • Page new unlikes: shows the total number of people removing your page likes. 

This is an example on how to display your total page followers as a scorecard and over time. You can see that Facebook displays total followers the given page has every day. 

Facebook page likes report
Facebook page likes report

Reach metrics

Reach represents the total number of unique users your Facebook page is reaching. It composes these metrics: 

  • Page total reach: displays the total number of users your page reached in a defined period. Your total reach is composed of three types of reach; paid, organic, and viral. 
  • Paid reach: shows the total reach your page has due to your Facebook Ads campaigns. 
  • Organic reach: organic refers to the reach you’ve got with no ads. It’s affected by the quality of your content so Facebook’s algo shows it less or more to an audience. 
  • Viral reach: refers to the reach you get from the shares of your content. 
Facebook pages reach report
Facebook pages reach report

Impressions metrics

Similar to reach, impressions offer the same metrics break down and express the audience you’re able to reach. Metrics include: 

  • Page total impressions
  • Paid impressions
  • Organic impressions
  • Viral impressions

While reach refers to the number of users your post reaches, impressions refers to the number of times your posts are shown; one expresses the number of users and the other the number of actions. 

You may reach 5 people, but get 10 impressions. The average number of times a single user is reached is 2, and that’s called the frequency. 

Positive and negative actions metrics

Facebook algorithm will determine your chances to get more or less reach by, among other factors, the actions people make on your page, such as: 

  • Positive actions: behaviors that express a positive interaction with your page, such a like, comment, reaction, share, etc. 
  • Negative actions: behaviors that express a negative response, like hiding content or reporting a page. 

Facebook Page reactions report

With our Data Studio connector, you can have a proxy of sentiment monitoring by tracking page reactions like:

  • Likes
  • Love
  • Wow
  • Anger
  • Sad
  • Haha
Facebook pages reactions report
Facebook pages reactions report

Facebook page engagement report

Engagement refers to any type of interaction with your Facebook page, including metrics like: 

  • Page engagements
  • Page engaged users
  • Page engagement rate: compares page engaged users/page reach, to know what percentage of your audience is interacting with your content. 
Facebook page engagement report
Facebook page engagement report

Facebook page posts report

You can also report your posts performance with dimensions like: 

  • Post message: the text or caption of your Facebook post
  • Post image: the image of the creative used in your post
  • Post comments: displays the comments separated by commas made in your post
  • Post date: Shows the date when posted
  • Post link: displays a clickable link to access the post directly on Facebook
  • Post type: breaks down posts by image, video, carousel, etc. 

And metrics like:

  • Post engagements
  • Post shares
  • Post reactions
  • Post comments count
  • Post clicks
  • Post reach
  • Post impressions
  • Post actions: like
  • Post actions: wow
  • Post actions: anger
  • Post actions: sad
  • Post actions: love
  • Post actions: sad
Facebook pages post report
Facebook pages post report

An important consideration is that you cannot combine page metrics and dimensions with post metrics and dimensions.

You can combine post date and post shares, but cannot combine “Date” with post shares. Date corresponds to the page, not the posts. 

Make sure to combine page metrics with page dimensions and post metrics with post dimensions. Otherwise, you’ll see the following error message: 

Google Data Studio error message: these fields cannot be combined

Demographics and geographic reports

The audience dimensions let you break down your followers and page to understand who’s following you, including:

  • Gender
  • Age
  • City
  • Country

Unlike any other connectors, you can break down your followers and page likes by gender or age (others only allow followers). And you can see these breakdowns over time (other connectors offer fixed values).

Messenger metrics

  • New messaging connections
  • New blocked connections
  • New reported connections
Facebook pages Messenger report

Creating a Facebook Insights on Google Data Studio

Creating charts 

Once you understand the Facebook pages Insights metrics, it’s fine to create your first charts if you haven’t. 

We prepared a video tutorial on how to create your first charts and graphs on Google Data Studio:

Follow these steps to create your first charts: 

  • Open the Google Data Studio report on the edit mode.
  • Go to the menu and select Insert or Add a Chart. 
  • Choose a chart type (scorecard, time series, tables, pie charts, and bar charts are the most common).
  • Make sure the chart is linked to the Facebook pages insights connector.
  • Depending on the chart, you should choose a combination of metrics and dimensions. A good one could be visualizing Total page likes or Total page followers as a scorecard and over time by choosing Date as the time dimension.

Filters and controls

Filters and controls on Google Data Studio make your reports interactive and clean your data. 

A good use case for filters and controls with Facebook pages  data may be filtering your Post messages so you can analyze your post performance by topic, like excluding the posts that contain the word “marketing” vs those with the word “sales”. 

We prepared this tutorial on how to create filters and controls on Google Data Studio

Custom formulas

When it comes to formulas, think of Google Data Studio like Google Sheets: you can calculate any sort of metrics with countless math functions. 

However, the most common formula you may want could be engagement rates, which is just dividing a metric with another. 

With Facebook Insights, you may calculate engagement rate by dividing post engagements vs post impressions, or page engagement rate by dividing page engagements and page reach. 

Case statements

As you set formulas to create metrics, you can use case statements to create new dimensions. 

With Facebook pages data, you may want to group your posts by topic by grouping the posts that contain the name of a brand vs the other. 

Here are our tutorials on case statements and regular expressions

Google Data Studio: Case Statements / Case When

Blending Facebook pages and Instagram pages data

A great use case of the Facebook pages connector for Google Data Studio is combining it with other social media connectors like Instagram and Twitter.

With them, you may create a report to combine the total followers or audience across all your social channels. 

You may want to follow this video tutorial on blending data on Google Data Studio

Google Data Studio: Blending Data / Examples and Step by Step

Follow these steps to combine your data

  • Open the Google Data Studio report on the edit mode.
  • Click on Manage added data sources and make sure to connect your Facebook Ads, Google Ads data (or any other connector you might use). 
  • Create a table for each connector whose dimension is equivalent to the date and the metrics are conversions and ad spend (or any metric you may want to compare). 
  • Make sure the tables are beside each other on the same page. 
  • Select the three tables and do a right-click. 
  • Select Blend data.
  • Google Data Studio will automatically create a table combining the metrics of the three connectors. 
  • To verify the data was correctly blended, go to edit the blended data source and make sure that the dimensions equivalent to the date work as the join keys. 

Customizing your report

We prepared a video tutorial showing you ways to customize your Facebook pages reports (and even making them Whitelabel). 

Sharing your Facebook Insights report

Google Data Studio, such as other Google products, has great collaboration and sharing features. 

You can: 

  • Choose the Gmail/G Suite users who can access your reports as editors or viewers 
  • Schedule email deliveries
  • Share a link to access the report
  • Download a PDF version
  • Embedding the report on another website

We covered all of these in our tutorial on how to share your Google Data Studio reports.

Google Data Studio: Share Your Reports [Automate it]

Facebook Insights report templates for Data Studio

It’s ok if you don’t want to set up your Data Studio reports. We prepared a set of Facebook pages Insights report templates for Data Studio covering all the possible use cases so you don’t have to. 

We have a tutorial on how to use Data Studio report templates, too. 

A common question is how you can add these templates to your current reports. You just need to select all the elements of your Data Studio report, copy, and paste them into your other reports. 

More posts