Facebook insights in Google Data Studio Create a new data source

by Benji Azaria

2017-10-25

Google Data Studio has launched in their recent release the ability to add custom connectors, this means you can present Facebook insights in Google Data Studio. Supermetrics and Power My Analytics are the first ones that connected some of their API’s. So that now you can present in your Data Studio data from:
Facebook, Bing, Instagram, Twitter, MailChimp, Pinterest, Yahoo, Yandex, eBay Amazon and more.

In this article, I will show you step by step how you can present beautiful Facebook insights in Google Data Studio, using the Supermetrics connector.

Creating Facebook insights in Google Data Studio

There are 5 steps we need to do in order to create our dashboard of Facebook insights in Google Data Studio:
1. Create a new data source
2. Add the Facebook Insights connector
3. 2 step auth for connecting your Facebook account and your Google Account with Supermetrics
4. Selecting the Facebook page for insights and completing connection
5. Creating a beautiful Dashboard in Google Data Studio

1. Create a new data source

In order to add a new data source, we need to first click on the DATA SOURCES (on the left-hand side). Then click on the + button (on the lower right-hand side)

2. Add the Facebook Insights connector

Now scroll down on the left-hand side navigation to the bottom until you reach the EXPLORE CONNECTORS button.
Locate the Facebook Insights connector and click on the ADD CONNECTOR – in case you see there ADDED in gray this means you have added this connector and you will see it under the community connectors.

3. 2 step auth for connecting your Facebook account and your Google Account with Supermetrics

You will now need to go through a simple 2 authentications:
a. Authorization that Data Studio requires using this community connector.

b. Authorization Facebook Insights requires to connect to data:

4. Selecting the Facebook page for insights and completing connection

Select the Facebook page for insights, in case you have more than, you will see here a list.
Click on connect (on the upper right-hand side)
Click on Create report (on the upper right-hand side)

We’re done with all of the configuration, let’s start creating the dashboard

Creating a beautiful Dashboard in Google Data Studio

1 – The first widget that I will use is the Scorecard. Notice that I added a comparison to the previous date. You can do this by selecting the Previous period under the DATA tab that’s on the Scorecard Property.

2 – The second widget is the Time series. Here I selected Year & month as the Dimension (and New likes as metric)

3 – The third widget is the Pie chart. Under the STYLE tab, I enlarged the hole with the slide control.

4 – The fourth widget is the Bar chart. Here I transposed the chart to be horizontal and removed the legend.

5 – The fifth widget is the Table. Notice that the table is ordered by the first metric (Likes on posts) and all other metrics have a heatmap. You can do this by going to the STYLE tab, and under Columns, change then Number into Heatmap.

6 – The sixth widget is simply an Image. I like using this widget because it makes the report more friendly. In this report, I used it in the Facebook logo, Like, Emoji…

7 – The Seventh widget is the Date range. This is a must, you want to give your users the ability to view the report on different dates.

I normally add some filters, but I didn’t want to make this report too complex.

I would really like to hear your thoughts, please share them with me.

You can grab this template from here

Learn Google Analytics, at your own pace, from wherever you are, with the best platform!

Start the course now (free)