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

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

Nowadays, Facebook is one of the most popular social media platforms to share content and create ad campaigns to connect with your audience. Brands worldwide use Facebook as one of their channels for acquisition, branding, and engagement. 

Analyzing your Facebook account through a report is essential to find insights and make decisions to improve your content to give your audience what they are looking for and connect with them.

If you are looking for an easy and effective way to build a Facebook Insights dashboard in Google Data Studio, this step-by-step is for you. We are sure it will be your go-to resource to understand all the Facebook pages metrics and report them on Data Studio.

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). 

What does Facebook Insights show? 

According to Facebook, Facebook Insights can provide you with information about your page’s performance, such as demographic data, and how your audience responds to your posts. Through Facebook insights, you can also see your likes and unlikes on Facebook.

Why is it important to build a Facebook insights dashboard? 

When you have a Facebook Insights dashboard, you can track the user’s behavior and understand your posts’ performance, considering metrics and likes, page views, post reach for paid and organic posts.

Once you have all these insights, you can analyze your data and notice trends about what your audience wants, and you can also develop new content and strategies according to your audience’s needs.

Does Facebook Analytics shutdown affect Data Studio reporting?

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

The answer is no, as 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).

How to create a Facebook Insight report for free 

On Porter Metrics, we are provider connectors such as Facebook Insights connectors for Google Data Studio. As a result, we have an idea why we cannot find anyone offering a freemium model to connect Facebook Ads to Data Studio. The main reason is that it is an ongoing activity and not a one-time task. 

Nevertheless, moving back to the main topic, if you’re still not willing to pay for a connector,  the best way to create a Facebook Insight report on Data Studio for free is to send your Facebook Insights data to Google Sheets and connect your spreadsheet to Google Data Studio. Still, it’s manual or pretty limited and requires ongoing developer effort.

These are the steps to connect Facebook Insights to Data Studio for free:

  • You can go to “Facebook Pages Insights” and click on “Export Data” to download a CSV.
  • Then, you will upload the CSV file on 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.

We also encourage you to read: How do I export data from Facebook

To summarise, you need to consider that pulling data from Facebook to Google Sheets requires ongoing developer effort. So, while there could be freemium options, Google Sheets connections will be limited anyway, and the direct connection is more powerful and flexible than having Sheets in between

Facebook pages Insight dashboard

How to connect Facebook Ads to Data Studio through a connector?

We already learned how to connect Facebook insights for free, now we’ll learn how to import Facebook Pages Insights data to Google Data Studio through a connector

Besides, for this tutorial, you need to know we will use Porter Metrics Facebook Pages Insights connector to make things easier for you. We know this is self-promotion but also mention why we made it the best solution available. You can instantly start a 14-days free trial.

Finally, you have three different ways to access to the Facebook Ads connector:

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

Step 1: Sign in with Google and Facebook

Sign in with your Gmail account once you are on the connector 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. 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. 

Signing in with a Facebook profile for an authorization

When you are linking your Facebook profile, Facebook will ask you to check the Facebook pages you want to connect to Google Data Studio and 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. 

Note: 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 only connects to the API to bring data to Google Data Studio. 

You can see in the following video tutorial how to connect your data to Google Data Studio.

Step 2: Choose 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 Ads accounts in a single data source.

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

Facebook pages dropdown on Google Data Studio

A company could know the likes, followers, reach, and engagement through this feature in a single dashboard.

Step 3: Finish the setup

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

You will see all the fields available on our Facebook connector for Google Data Studio in the next view. Also, you will see about 70 fields available 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 Insights 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

Reminder: If you started using the connector from the link we provided, you’ll get our report template. The report template is meant to save you time.

However, if you did it from the Data Studio connector gallery, you will load a blank report and you’ll need to create charts and customize the report, but no worries, we will show you how in the following steps.

So far, we have already created our first Facebook Ads 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. 

To keep learning, 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

Bonus: 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. 

Metrics are the numerical values such as followers, reach, and engagements. On the other hand, dimensions are how you break down the metrics. For example: by date, by country, by post, etc.

If this is your first time with Data Studio, we recommend you check this resource to create your first Google Data Studio report. But to help you navigate through the Facebook Ads metrics, I would recommend watching this tutorial on creating charts and graphs

Now, let’s go to see Facebook pages dimensions

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 understand better 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 variation over time. 

If your new followers metric is higher than the previous 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 (the page date). And not post date. 
  • Page new unlikes: shows the total number of people removing your page likes. 

This is an example of displaying your total page followers as a scorecard and over time. You can see that Facebook shows the total number of followers the given page has every day.

Facebook page likes report
Facebook page likes reportReach 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 also 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 refer 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 reportStep 4: Create your charts and customize your report
Once you have understood the Facebook metrics, you will create your first charts if you haven’t. However, remember you can always use a Porter Metric template. 
Also, we prepared a video tutorial to show you how to create your first charts and graphs on Google Data Studio:

Step 4: Create your charts and customize your report

Once you have understood the Facebook metrics, you will create your first charts if you haven’t. However, remember you can always use a Porter Metric template. 

Also, we prepared a video tutorial to show you 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, just dividing one 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 Ads connector for Google Data Studio is combining it with other connectors, such as Instagram and Twitter. You may create a cross-channel ads report combining the total followers or audience across all your social channels with them.

You can watch the following video tutorial about blending data on Google Data Studio

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 page reports (and even make them Whitelabel). 

Sharing your Facebook Insights report

Google Data Studio, like other Google products, Google Data Studio has excellent 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 this topic in the following video tutorial: How to Share your Google Data Studio reports.

Facebook Pages Insights report templates for Google Data Studio

It’s ok if you want to design your own Data Studio report. Still, we’ve prepared a set of  Facebook pages Insights report templates for Data Studio covering all the possible use cases so you can avoid creating them from the very beginning. 

You can copy and paste our reports template to save time, and you can also watch our tutorial on how to use Data Studio report templates.We encourage you always to keep learning and visit Porter Metrics to review all the resources you can use to automate your data information reports.

More posts