[ Updated Feb 21, 2023 ]
If you’re running paid ads, in-app ads, or organic campaigns on Facebook, you probably need to export your data to Google Sheets for a more in-depth analysis.
You can, of course, go with the old-fashioned CSV copy and pasting data to a spreadsheet. However, the process is time-consuming and error-prone. The worst part is you have to go through the whole thing all over again if you want to update your data.
Nobody wants that.
In this article, we’ll show you how to import Facebook data to Google Sheets automatically with Supermetrics. You’ll end up with a new and self-updating report at your disposal.
- Install the Supermetrics add-on
- How to import Facebook data to Google Sheets
- Set up automatic refreshes and triggers
- Facebook Ads reporting templates for Google Sheets
Step 1: Install the Supermetrics add-on
First things first. You need to install the Supermetrics add-on for Google Sheets.
You can find it on the add-ons menu in Google Sheets. So click on ‘Add-ons’ → ‘Get add-ons’ → ‘Supermetrics’ → ‘Install’.
Or, you can install Supermetrics from the Google Workspace Marketplace.
Next, sign in with your Google account and give Supermetrics all the necessary permissions.
After that, you can find Supermetrics under ‘Add-ons’ in your Google Sheets.
Here’s a video tutorial on how to install the add-on. ?
Done? Moving on.
Step 2: Import Facebook data to Google Sheets
There are four Facebook connectors you’ll find inside the Supermetrics sidebar:
Now, we’ll take a look at what kind of data you can pull with each connector and how you can run your first query — to get data to Google Sheets.
Import Facebook Ads data to Google Sheets
With the Facebook Ads connector, you can easily pull the key metrics you need to analyze your paid campaigns’ performance. For example, you can get clicks, impressions, CTR, and conversions to your spreadsheet. You can also split the data by date, campaigns, or different audience segments.
Let’s say you want to monitor your monthly campaign’s performance. You can create a report using this query:
- Data source: Facebook Ads.
- Select accounts: choose the account(s) you want to pull data from.
- Select dates: set the date range for your data. Here, we chose the last 90 days.
- Select metrics: clicks (all), impressions, CTR (all), amount spent (EUR), cost per any action, website conversions, return on ad spend (ROAS).
- Split by dimensions: year & month, campaign name.
- Filter: you can use different filters to segment your data even further. We’ll leave it blank for now.
- Options: conversion window — for example, 28-day click.
Once you’re happy with your query, click on ‘Get data to table’.
Your spreadsheet will look something like this. ?
Import Facebook Pages data to Google Sheets
The Facebook Insights connector helps you pull the organic metrics you need to analyze your Page’s performance. You’ll find:
- Page metrics. For example, impressions, reach, likes, etc. Page metrics tell you how people engage with your Facebook Page.
- Post metrics. For example, impressions, likes, shares, etc. Post metrics report on your best-performing posts.
- Audience metrics. For example, gender, country, device, etc. With the audience metrics, you’ll understand who your audience is.
For example, you can easily create a post-performance report in Google Sheets with this query. ?
- Data source: Facebook Insights.
- Select pages: choose the Facebook Page(s) you want to pull data from.
- Select dates: set the date range for your data.
- Select metrics: likes on post, comments on post, shares on post.
- Split by dimensions: post caption, post description, post type.
Psst, you may notice we added some settings to sort our posts in descending order by likes. It’s totally up to you to choose whatever settings suit your needs.
- Filters and options: Again, we didn’t set any filters or advanced options here, but you can play around with them if you want.
Happy with your query? Great. Let’s click on ‘Get data to table’.
And boom! ? Your report will look something like this. Amazing, isn’t it?
Import Facebook public data to Google Sheets
The Facebook Public Data connector helps you pull data from Facebook Business accounts. It’s a secret weapon for your competitor analysis. For example, you can easily pull page engagement metrics and post engagement metrics of your competitors’ Facebook Page.
Let’s say you’re managing a pet supply business, and you want to benchmark your follower growth against competitors. You can easily do so using this query. ?
- Data source: Facebook Public Data.
- Report configuration: choose the report you want to pull data from. Here, you’ll find three query type:
- Facebook page data: reports on page engagements.
- Facebook post by a page: reports on post engagements of chosen pages.
- Facebook shares for URL: reports on post engagements of chosen URLs.
Since we’re interested in follower growth in this example, we’ll go with Facebook page data.
- Facebook page aliases/IDs: enter the Facebook Business pages you want to monitor. Separate each page with a comma.
Pro tip ? Since we want to accumulate the follower data, we’ll tick on the ‘Append new results to old’ box.
- Select metrics: page followers.
- Split by dimensions: name (profile).
- Filter and Options: choose any settings to segment your data.
Once you’re done, let’s click on ‘Get data to table’ and wait for the magic. ?
Your spreadsheet will look something like this. ?
Watch how to run your first query.
Step 3: Set up automatic refreshes and triggers
If you’d like to analyze the same daily, weekly, or monthly data, you can use Supermetrics to set up new data transfers to Google Sheets.
To do so, click on the ‘Schedule’ tab on the sidebar.
Next, click on ‘Add trigger’. From here, you can choose how often you want to update your report and whether you want an email notification when it happens.
Learn how to set up the triggers.
Facebook reporting templates for Google Sheets
Now that you’ve got your Facebook data in Google Sheets, it’s a good idea to create a report. Don’t worry if you’re not sure how to get started. We’ve prepared some Facebook reporting templates to help you set up your report in a minute.
Let’s take a look at each report and see what’s in it for you.
Facebook Ads high-level monthly reporting template
Whether you want to see a high-level overview of your Facebook Ads campaigns or dive deeper into your performance, this template can help. With it, you’ll see:
- An overview of your performance. This is useful if you want to quickly see what’s happening with your campaigns or report the results to your teammates or clients.
- Campaign and monthly performance. If your campaigns don’t perform as well as expected, you can easily investigate the monthly or campaign performance to see what went wrong.
- An audience report. You’ll also find the ‘Device stats’ tab and ‘Age and gender’ tab in this template. From here, you can easily see who your audience is and what devices they’re using.
Data source used: Facebook Ads.
Facebook Page template
If you’re growing your brand on Facebook organically, this template is for you. You’ll find all the metrics you need to analyze your Facebook Page performance.
The template shows you:
- Page engagement metrics. The first part of the template gives you a quick look into your Facebook Page performance. First, there’s a 7-day summary that tells you how many posts were published on your Page and their performance. Next, you’ll see the typical engagements on your Page — including clicks, reach, and likes — for the past 1 day, 7 days, and 30 days.
- Post engagement metrics. Here, you’ll see a table showing the best posts by likes.
- Follower growth. You’ll see how many people liked your Pages for the past 1 day, 7 days, and 30 days. Additionally, you can forecast how many followers you’ll have at the end of the month with your current growth rate and if you’ll reach your target.
- Reach metrics. Here, you’ll understand which channels drive more reach. Is it organic, paid, or viral?
Data source used: Facebook Insights.
Ecommerce performance template by Gauge
Let’s say you’re growing your ecommerce store with Google Ads and Facebook Ads. You can use this ecommerce performance dashboard template to understand your online store’s performance better.
The template shows you:
- Performance analysis. You’ll see how your current performance looks — including transaction rate, average order value, and cost per visit.
- Channel analysis. You’ll understand which channels drive the highest ROI.
- ROI optimal projection. Here, you’ll see your current ROI and optimal ROI based on the analysis.
Detailed paid channel mix reporting template
Your paid effort probably doesn’t stop with Facebook Ads. Perhaps, you’re running paid campaigns on Google, Microsoft, and Twitter as well. The detailed paid channel mix template can help you keep track of your performance across all these channels.
If you want to share your campaign’s results with your clients, you can navigate to the main tab — Detailed paid channel mix — to show them:
- The revenue you’re driving with paid advertising.
- An overview of each channel’s performance.
- The top 10 campaigns by conversions.
Let’s say you notice your Facebook ad campaigns don’t perform as well as expected. You can easily go to the ‘Facebook Ads report’ tab to check what went wrong. You’ll see your:
- 3-month performance, including impressions, clicks, CTR, and website conversions.
- Campaigns’ performance by date.
- Top campaigns and ad sets.
- Audience breakdown by age, gender, and device.
Detailed paid channel mix reporting template (with Yandex)
This template is suitable for businesses or agencies that run campaigns on multiple channels, including Yandex.Direct. With it, you’ll see:
- A high-level overview of your campaign across all channels. You can use this report to monitor your daily performance or share it with your clients or teammates.
- Channel-specific reports. If you need to dive deeper into your performance, you’ll also find a detailed report of Google Ads, Facebook Ads, Twitter Ads, and Yandex.Direct.
Paid social performance dashboard template by Gauge
Thanks to our friends at Gauge, you can use this template to monitor your paid social media performance. The template helps you calculate your current CPM by channel and compare it with your optimal CPM. With this information, you’ll easily figure out where you should improve your performance.
Getting started with the templates
Now, we’ll show you how you can get the templates up and running. Let’s take the Facebook Ads high-level monthly reporting template as an example.
First, you need to make a copy of the template you want to use. In this case, it’s the Facebook Ads template.
Once your copied spreadsheet opens, launch the Supermetrics sidebar under ‘Add-ons’.
Then click on the hamburger menu and choose ‘Duplicate file for another account’.
Next, select the Facebook Ads account you want to pull data from and click on ‘Duplicate the file’.
Now, wait a sec for us to refresh your queries. After that, click on ‘here’ to open your report.
Buh-bye copy/paste ?
High five! ✋ We finally got rid of the most boring and tedious part of marketing reporting — copy/pasting data into Google Sheets.
Now it’s your turn to decide how you’ll analyze your data and what kind of reports you want to build.
Happy automating! ?
Turn your marketing data into opportunity
We streamline your marketing data so you can focus on the insights.