Services used

  Google Sheets
  Google Analytics
   Facebook 

Department

  Marketing

Time to setup

 17 minutes

Weekly hours saved

± 2-4 hours 

What is the Facebook Analytics Template?

Facebook became an inevitable marketing tool in today’s digital marketing and that’s exactly the reason why you should analyze its data better than ever. At Sheetgo, we decided to help you on starting to do this without the use of expensive or complex software.

The template allows you to better track Facebook results using Facebook Analytics, Google Analytics, Google Sheets and the add-on Sheetgo. Essentially, we are going to automate the data flow of all your Facebook activities and the engagement that comes with it. In the end, all you need to do is use the Facebook Analytics Dashboards to monitor it all.

This Facebook Analytics System allows you to customize it according to your needs. You might think “interesting, but this seems a bit too techy” – well, we can assure you that there’s no coding or complex formulas needed for this Facebook Analytics template. The best part of it all is that we are only going to use tools that you already know! These are the kind of instructions that anyone can conduct, however, if you need help just shoot us a message by clicking on the bottom right.

 

Instructions

 

This template consists of 3 steps:

  1. Creating a Facebook Developers API Key 
    Spreadsheet used: Facebook Template (Analytics Database)
  2. Setting up Google Analytics
    Spreadsheet used: Facebook Template – Google Analytics Report
  3. Completing the Dashboard by Connecting all Spreadsheets
    Spreadsheet used: Template Dashboard

 

The template explained in a diagram.

 

Step 1) Creating a Facebook Developers API Key

 

1. Register a Facebook Developer Account.

Skip this step if you already have a Facebook Developer Account and continue to step 2.

  • Open https://developers.facebook.com/apps/  and log in with a Facebook account that has ownership or manager rights of the fan page.
  • Click on the button “Register Now” and click on “next” to verify your account and proceed with Facebook’s steps.
    To finalize, click on the button “Add Your First Product”.

2. Creating a Facebook App

  • Click on the button “+ Add a New App”.
  • Insert an app name, for instance: “My Template Analytics Database App”.
  • Click on “Create App ID”.

3. Setting up the App

  • Click on the + next to “Products” to find the “Facebook Login” App and click on “Set Up”.
  • Now on the left sidebar, under “Facebook Login” click on “Settings”.
  • Turn on the “Embedded Browser OAuth Login” option.
  • Click on “Save Changes”.

4. Getting the APP ID and APP Secret.

  • On the left sidebar, click on “Settings” and then “Basic“.
  • Copy the App ID and save it into a Notepad.
  • On the right, click on the button “Show” and confirm your Facebook password.
  • Copy the App Secret and save it into Notepad.

5. Getting the Fan Page’ ID

  • Open the Facebook page that has the data that you want to analyze.
  • In the menu on the left, click on “About” and scroll to the end of the page.
  • Copy the Page ID and save it into notepad.
  • You can now close all the Facebook pages and go back to the spreadsheet template.

6. Save the Page ID and the Keys into the template.

  • Copy the first spreadsheet by clicking here and go to the tab “settings“.
  • Paste the Page ID, APP ID and the APP Secret from your Notepad.

7. Configure your Facebook Analytics account.

  • Click on “Facebook Analytics” and then “Configure Account“.
  • Click on “continue“, select your account and allow Facebook Analytics Database to run. The last two fields should now be filled out automatically, meaning that you have completed the setup! 🙂

8. Create a connection with Sheetgo.

  • Open the Sheetgo add-on (see screenshot below). If you haven’t installed the Add-on yet, click here. Once installed you will be able to connect any spreadsheets in your Google Drive that is required to set up this template.

    • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Facebook Template (Analytics Database)“, then select as a source tab “Data entry – Page Information“.
    • Below in settings, change the to connection name to “Historic_Page_Information“.
    • In “automatic updates” choose “daily” and “4 AM TO 5AM“.
    • Enable “Append Data“.
    • Click on the green check mark to save the connection.

 

Part 2) Setting up Google Analytics

 

  1. Open your Google Analytics and copy your “view ID“.
  2. Copy this template by clicking here and paste your View ID in the cell.
  3. In the “Facebook Template (GA Reports)” spreadsheet, open the Google Analytics Add-on. If you haven’t installed the Google Analytics Add-on yet, click here.
  4. In the Google Analytics Add-on, click on “schedule reports“, check the box and select “monthly report“.
  5. Connect your spreadsheets using the Sheetgo Add-on.
  • Inside the spreadsheet “Facebook Template (GA Reports)“, open the Sheetgo add-on.
  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Facebook Template (GA Reports)“, then select as a source tab “sources“.
    • Below in settings, change the connection name to “Historic_Sources“.
    • In “automatic updates” choose “monthly” and “day 1“.
    • Enable “Append Data“.
    • Enable “Transfer Formatting“.
    • Click on the green check mark to save the connection.

 

Part 3) Completing the Dashboard by Connecting all Spreadsheets

 

Configure and connect Template Dashboard.

  • Open “Template Dashboard” by clicking here and open the Sheetgo add-on.
  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Facebook Template (GA Reports)“, then select as a source tab “Historic_Sources“.
    • Below in settings, change the connection name to “GA_FB_Sources“.
    • In “automatic updates” choose “daily” and “4AM to 5AM“.
    • Enable “Transfer Formatting“.
    • Click on the green check mark to save the connection.

 

  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Facebook Template Analytics Database“, then select as a source tab “Post_Dashboard“.
    • Below in settings, change the connection name to “FB_DB_Posts“.
    • In “automatic updates” choose “daily” and “4AM to 5AM“.
    • Enable “Transfer Formatting“.
    • Click on the green check mark to save the connection.

 

  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Facebook Template Analytics Database“, then select as a source tab “Historic_Page_Information“.
    • Below in settings, change the connection name to “FB_DB_Page“.
    • In “automatic updates” choose “daily” and “4AM to 5AM“.
    • Click on the green check mark to save the connection.

 

All done, congrats!

Let us know if you have any remarks or questions by commenting down below.