Facebook Public Data

Facebook Public Data lets you automatically export statistics from your public Facebook Pages and posts to Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like Claude and ChatGPT. Pull page engagement metrics and post performance data on a schedule without writing any code.

Why connect to Coupler.io?

• Automate reporting — Pull page and post statistics on a schedule instead of manually checking Meta Business Suite

• Centralize your data — Combine Facebook data with other sources using Join or Append transformations

• Send to your tools — Export directly to Google Sheets, Excel, BigQuery, Looker Studio, or AI platforms like Claude and Gemini

• No code required — Set up your data flow in minutes with an intuitive interface

Prerequisites

• A Facebook account with access to a public page you want to report on

• The page must have its "Followers and Public Content" settings visible to the public

• A destination to send the data (Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination)

Quick start

Connecting Facebook Public Data is fast — you'll authorize with Facebook via OAuth and select your report type and pages. Most users complete setup in under 5 minutes.

How to connect

1

Click "Create data flow" and search for "Facebook Public Data". Select it from the list and choose your destination (Google Sheets, Excel, BigQuery, Looker Studio, Claude, ChatGPT, or another AI platform).

2

Sign in with Facebook. You'll be redirected to Facebook to authorize Coupler.io to access your public page data. Click "Allow" to proceed.

3

Select your report type. Choose either "Public pages statistics" (overall page performance) or "Public posts statistics" (individual post metrics).

4

Enter your page ID or public alias. You can find your page ID in your page URL (e.g., facebook.com/yourpagename — use yourpagename or the numeric ID like 123456789). If you have multiple pages, enter one ID per line.

5

Set date range (posts only). If you selected "Public posts statistics", use the date pickers to set the "Published after" and "Published before" dates. For page statistics, Facebook returns all available data automatically.

6

Configure your destination and run the data flow. Review your settings, map any required columns in your destination, then click "Run" to complete your first import. After a successful run, you can schedule future refreshes.

Available report types

Report Type	Description	Available Metrics
Public pages statistics	Overall engagement and reach for your page	Page views, post views, followers, new followers, likes, reactions
Public posts statistics	Performance data for individual posts	Post reach, impressions, engagement, shares, comments, reactions