Meta / Facebook Ads Report Template for Google Sheets

Facebook Ads Dashboard

This Meta / 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 Meta / Facebook Ads metric you can find here.


Step 1:

Login or Register on

Step 2:

Grant access to your Meta / Facebook Ads Account


Step 3:

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

Google Sheets API

Step 4:

Add’s Extension to Google Sheets.


Google sheet extension
Step 5:

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


Copy template


Step 6:

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




Step 7:

Now under “Add Data & Analytics by” extension press on Get Data into Sheets, then click on the Edit icon under the Facebook query.


Add Query google sheet addon


Choose the accounts you want to include and the date range. Now click on Load Data and your template should be ready.

Fields used in this Meta / Facebook Ads Google Sheets Report Template

  • Campaign Name
  • Country
  • Clicks
  • CPC
  • CPM
  • CTR
  • Date
  • Impressions
  • Amount Spent


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


You might also be interested in…