Facebook Ads Report Template for Google Sheets

Google Sheet Facebook ads

This Facebook Ads Overview Report template helps you to visualise your Facebook Ads into Google sheets in a few clicks. Dimensions and metrics visualised in this report are

  •  Website Purchases
  • Campaign Name
  • Clicks
  • Countries people are located
  • CPC
  • CPM
  • CTR
  • Date
  • Impressions
  • Amount SpentSource

There is a list of close to 300 metrics and dimensions available once you start customising the report. To find the full list head to Available metrics and dimensions. Even more details about the Facebook Ads metric you can find here.

Follow this link for more details on Connecting Facebook Ads to Google sheets .

Step 1 :

Login or Register in Windsor.ai’ website.

Step 2 :

Grant access to your Facebook Ads Account

 

 

Step 3 :

 

click on Google sheet as show below and copy your API KEY

 

Google Sheets API

Step 4 :

 

Add Windsor.ai’s Extension to Google sheets.

 

Google sheet extension windsor.ai

Step 5:

 

Copy The template with clicking on File -> Make a copy
Template Link : Google Sheet Facebook Ads Overview Report

 

Copy template

Step 6 :

Clear all data from the Raw Data Sheet

 

Clear Raw data

 

 

Step 7 :

 

Under Extensions in the top ribbon of Google Sheets, select “Add Data & Analytics by Windsor.ai“, then “Login” and Paste your API KEY there:

Paste your API KEY GOOGLE SHEETS

 

Paste your API KEY GOOGLE SHEETS

 

 

 

Step 8 :

 

Now under “Add Data & Analytics by Windsor.ai” extension press on Get Data into Sheets, then Add new query.

 

Add Query google sheet addon

 

Select Data Source, Facebook Ads account, Field and Data range. Now click on Load Data and your template should be ready.

Fields used in this Template

  •  Website Purchases
  • Campaign Name
  • Clicks
  • Countries people are located
  • CPC
  • CPM
  • CTR
  • Date
  • Impressions
  • Amount SpentSource

PS : Make Sure in the Target sheet Name to Write ” Raw Data”