Build a report
Sign in with Google

Facebook Ads integration for Google Sheets

Start a 14-day free trial

Or book a free setup call

Trusted by +1,400 marketers

Import all your Facebook Ads data

All the fields from Facebook Ads Manager hourly, daily, weekly.

Visibility

Impressions, reach, CPM

Conversion

Custom, CPA, ROAS

Creatives

Ad image, name, and copy

Engagement

CTR, Clicks, CPC

Campaigns

Campaign Name, Objective, Type

Audience

Placement, Device, Region

Visualize +500 fields

+ 200 metrics

+ 200 dimensions

Includes custom fields

See fields list

How to connect Facebook Ads data to Google Sheets

Set up once, and let your data be refreshed everyday

To integrate Facebook Ads data to Google Sheets, follow these steps: 

  • Step 1: Install the Google Sheets add-on.
  • Step 2: Connect your Facebook profiles with access to your Ad accounts. 
  • Step 3: Set up a query defining ad accounts, date range, metrics, and dimensions. 
  • Step 4: save your queries and schedule data refreshes hourly, weekly, or daily.
    Complete tutorial: Import Facebook Ads data on Google Sheets.

Blend your cross-channel data

to get accurate marketing KPIs and a single source of truth.

Blend Facebook Ads with GA4

Combine traffic data from GA4 with Facebook Ads to fully map your funnel from ads to actual conversions

Blend with other ad platforms

Know your total ad spend, clicks, and impressions across Facebook Ads, Google Ads, Linkedin Ads, TikTok Ads, and Twitter Ads

Match marketing with revenue

Blend UTMs from Facebook Ads and your CRM or E-commerce to know the actual conversions and revenue generated from ads

Know your actual CPA and ROAS

Combine the actual purchases and conversions from your CRM or E-commerce with your ad spend to get accurate CPA and ROAS

Monitor your Facebook Ads performance

To reach your goals, align your team, and tell when things are working or not.

Set alerts and notifications

connect with Zapier or Make.com to send email or Slack alerts

Visualize your funnel

Blend PPC, CRM, OR GA4 data togehter

Filter and segment

by ad account, client, campaign, audience

Set and visualize goals

By adding columns to track progress towards objectives

Share and present reports and unlock AI

to influence your team or clients

Connect to Google Slides, Canva, or Graphy

For beautiful presentations with real-time data

Sync with Google Looker Studio or Power BI

and present your data on interactive dashboards, without the stability/speed limitations of connectors

Let AI give insights from your data

Use Open AI or Bard to give you analysis summaries

How Porter is different

Unlimited, free support via chat, email, and calls

We hire marketers to do customer support or book calls with our founders to personally:

  • Set up or fix reports
  • Train you (and your team) on Looker Studio
  • Give you recommendations
Book Juan (CEO)

+100 free templates and tutorials

Learn everything about marketing reporting and how to win with your marketing data—or nothing, with templates.

See templates

Simple, fair pricing

  • Only pay for accounts connected to your reports 
  • 14-day 100% refund + keep the service free*  
  • Free custom reporting service, training, and premium templates for annual plans
See pricing

Unsolicited, actual customers’ words

Porter makes your marketing team faster

Speed is doing the right things fast. Make it your competitive advantage with no-code data.

Start a 14-day free trial

Connectors

Tutorials

Looker Studio templates

Google Sheets templates

Report templates