Have you ever wanted to get Facebook Insights into Google Data Studio? Well, there is no real direct way of doing it. You can always subscribe to Supermetrics and harvest the data through their service, but if you don’t want to pay their fees, there is actually a way to do it manually.
This video takes you through the steps you need to go through and if you use this template, you’ll avoid all errors when importing the data from Google Sheets.
Five Steps to visualize Facebook Insights in Google Data Studio covered in the video:
Step 1: Download the data from your Facebook Insights on your Page
Step 2: Make your own copy of the template I have provided you with
Step 3: Copy and paste the page and the post data to the correct tabs
Step 4: Go to Google Data Studio and connect the spreadsheet with your Data Studio dashboard
Step 5: Select the data you want to visualize and smile
If you haven’t seen the first video about how to create a Growth Dashboard you can see it here.
If you like the videos you can always subscribe to my YouTube channel about digital marketing tactics and growth marketing.
Why is it important to have all data in one place?
When you can look at growth data in different channels in one place, you make it easier to analyze what activities should be attributed with what value. It doesn’t necessarily tell you exactly what value you should attribute to each channel, however, it helps you estimate a better hypothesis.
Having all the data in one place also saves you time. You can view the changes from day to day or hour to hour (with the manual template above, you can view it as soon as you add it or upload it), rather than having to spend time looking in many different places.
Facebook is really good at making it difficult to harvest their data. This hasn’t always been the case. We used to be able to get loads of data from Facebook and basically pull it to any platform in a very structured format, nowadays they – i guess intentionally – make duplicate headlines, add extra spaces that forces you to clean the data before you use it in any other place.
This brings me to the third reason it is really good to have all data in one place. That is, for educational purposes. Quite soon you will discover that a click on Facebook, doesn’t necessarily mean a visit to your website and a view on YouTube is far different from a view on Facebook. You can compare the different metrics with the same name and understand that despite the common labels, many data points are measured in different ways.
For me, this has been one of the strongest drivers to dive deeper into the analysis of what is actually happening as different data points are being registered.
And I believe that’s one of the greatest things that can happen. Because the more you get curious about your data, the less you will start to trust it. As your trust dissipates, your analytical skills will grow stronger, and with them your ability to draw the correct conclusions from the data you own (or borrow).