Analyze Facebook Ads data with Google Sheets
Connect Facebook Ads to Google Sheets
Connecting Facebook Ads to Google Sheets allows you to create reports, transform and blend data or pass them on to other platforms. This page covers getting automatically refreshed Facebook Ads data into Google Sheets. This includes but is not limited to conversion metrics (including custom conversion events and values). In total there are more than 200 different Facebook Ads dimensions and metrics available for retrieval.
It is very simple to connect Facebook Ads to Google Sheets, it can be done in a fast and easy manner with Windsor.ai. Setting this up should not take you more than 5 minutes.
Facebook is no doubt one of the most popular and widely used social media platforms. People of all age connects through Facebook and hence it serves as the right place where a marketer can find his potential customer.
Due to this reason, many businesses are using Facebook as a platform to market their brands. The data generated by Facebook Ads can help marketers adapt and make improvements to their marketing techniques. The data collected through Facebook gives you a clear idea of how the business ads convert to actual sales. But at the same time, analyzing the data from Facebook is not an easy job.
Hence moving the data from Facebook to Google Sheets can help in analysis. Google Sheets with its spreadsheet capabilities can be used to get an insight into the data.
Why Google Sheets?
Google Sheets is a spreadsheet application. But it offers its users more functionalities than other similar spreadsheet applications.
- It is a web-based online spreadsheet application that can be accessed anywhere at any time.
- It is free of cost. Besides, it is also connected with Google Drive, Docs, and Slides that helps in the easy sharing of files online.
- You can use the app on multiple devices.
- Users of the application can add their custom code and add-ons
- The functions of the Google Sheets are similar to those provided in Microsoft Excel. As most of us are familiar with Excel, using Google Sheets is relatively easy. However, some formulae and functionalities may vary
- Facebook account
- Google account
- Google Sheets API connectors
Steps to connect Facebook Ads to Google Sheets data by Windsor.ai
It is very simple to connect Facebook Ads to Google Sheets, it can be done in a fast and easy manner with Windsor.ai.
You need to select Facebook Ads as a Data Source and Grant Access to Windsor.ai.
Select Google Sheets as a data destination.
You can choose between two options:
Option 1: Advanced and for large data volumes
- Click this link to install the Google Sheets add-on
- Go to Extension – Ad Data and Analytics by Windsor.ai – Login
- Enter your API key: [your API Key] and click Login
- Start using the add-on in Google Sheets from the Add-ons menu in Extension – Ad Data and Analytics by Windsor.ai – Get Data into Sheet in Google Sheets document and select your fields
Option 2: Quickstart
- Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.
- The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.
- You can add any field that is available in the data sources you have added.
=IMPORTDATA("https://connectors.windsor.ai/facebook?api_key=[your API key]&date_from=2022-12-09&fields=campaign,clicks,adset_name,spend,impressions,date,source&_renderer=csv")
[your API Key]with your API key. The fields which are listed after
&fields=are simply a set of standard fields which you can customise. A full list of metrics and dimensions can be found in our Facebook Ads connector documentation. Customise the URL to your liking.
If you want to query a specific date range you can do so by changing
&date_from=to the start date. Additionally, you can also add in
&date_to=(at the end of the URL) and specify the end date.
- Insert your URL into Google Sheets and the data will start appearing
- If you use the date columns it’ll likely be displayed wrongly. You’ll need to change that by using the format
YYYY-MM-DDin Google Sheets
- Once done your date column should appear like this
- Now you are all set and your Google Sheets document will have fresh data.
Other ways to export Facebook Ads data on Google Sheets
Manually Downloading CSV files from the Facebook Ads manager
This manual process can be a viable option for those who prefer a free solution, though it does require some manual effort. To summarize:
- Go to the Ads Manager and navigate to the “Export data” table.
- Export the data as a CSV file to avoid potential formatting errors.
- In Google Sheets, choose to import the CSV file.
- Optionally, you can select “Replace” on the current sheet if you want to overwrite existing data.
- Your Google Sheet will now contain the Facebook Ads data.
- This process is manual and needs to be repeated every time you require a new query or want to update the data.
Alternative method to retrieve FB Ads data using web scraping and sending it to Google Sheets
This approach can be particularly useful when API access is limited or restricted. The logic of web scraping involves the following steps:
- Download a Google Chrome Extension:
- Install a Chrome extension that enables web scraping. This extension allows the scraper to access and extract data from web pages opened in the browser.
- Define URLs and Specific Content:
- Specify the URLs of the web pages containing the data you want to scrape.
- Define the specific content or information you want to extract from these pages.
- Schedule Scraping:
- Set up a schedule for the web scraping tool to run at specified intervals (e.g., daily, weekly).
- Store Data in Google Sheets:
- Once the scraping tool retrieves the data, it should automatically store it in Google Sheets.
Advantages of Web Scraping:
- Enables extraction of data not accessible through APIs.
- Allows for tracking of competitors’ data, provided there is a public webpage to access.
How to analyze FB ad data in Google Sheets
Define, Aggregate, and Filter Data
- Utilize pivot tables, charts, formulas, and filters in Google Sheets.
- Pivot tables allow for advanced querying, aggregation, and sorting.
- Charts help visualize data for effective dashboards.
- Formulas enable data blending across multiple channels and custom metric calculations.
- Filters assist in cleaning and excluding data based on specific conditions.
Facebook Ads Goals
- Compare data against specific goals and use conditional formatting for added context.
- Common goal tracking use cases include ad pacing monitoring, agency client overviews, CPA monitoring with markups or commissions, campaign performance assessment, and cross-channel paid media analysis.
Alerts & Notifications
- Send notifications to your team via email or Slack for timely updates.
- Utilize refresh scheduling to automatically update Google Sheets with the latest Facebook Ads data.
Google Sheets Data in any of the following tools
- Connect Google Sheets to tools like Google Looker Studio and Microsoft Power BI for data visualization and business intelligence.
- Integrate with platforms like Canva and Google Slides for creating client reports and presentations.
- For development teams, connect Google Sheets to BigQuery to centralize company data.
Try Windsor.ai today
Access all your data from your favorite sources in one place.
Get started for free with a 30 - day trial.
Templates for Facebook Ads and Google Sheets
Facebook Ads metrics & dimensions available for streaming into Google Sheets
Extract Facebook Ads data to Google Sheets with Windsor.ai
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.