# 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

{% hint style="success" %}
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.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**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).
{% endstep %}

{% step %}
**Sign in with Facebook.** You'll be redirected to Facebook to authorize Coupler.io to access your public page data. Click "Allow" to proceed.
{% endstep %}

{% step %}
**Select your report type.** Choose either "Public pages statistics" (overall page performance) or "Public posts statistics" (individual post metrics).
{% endstep %}

{% step %}
**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.
{% endstep %}

{% step %}
**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.
{% endstep %}

{% step %}
**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.
{% endstep %}
{% endstepper %}

## 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   |