Integration of Facebook Catalog with BigQuery
Connect Facebook (Meta) product catalogs to Google BigQuery with WitCloud and collect a daily snapshot of their products and product sets.
Updated
Introduction
This module integrates with the Facebook Catalog API (Meta Graph API), enabling you to collect the products and product sets of your Facebook (Meta) product catalogs and store them in Google Cloud BigQuery. Each run saves the current state of the catalog, so you can track your product feed over time and join it with your Facebook Ads data.
Configuration guide
Follow the steps below to connect Facebook Catalog with BigQuery. Once the setup is complete, your data will be automatically transferred to your BigQuery project.
WitCloud lists the catalogs of the Meta business portfolios your Facebook account belongs to — both catalogs the business owns and catalogs shared with it. Make sure the account you authorize has access to the business and catalogs you want to collect.
Module setup
Go to the Integrations section in the menu > Click Add integration.

Select Facebook Catalog from the list of available integrations.

Enter the Collect name, e.g. Facebook Catalog PL.

Authorization
If you have already authorized Facebook Catalog in this project, simply pick the token from the Select Facebook authorization drop-down and skip this step.
Click Authorize.

In the Facebook window:
- Log in to Facebook and choose the account you want to use.
- On the "Review WitCloud's access request" screen, confirm the permissions "Manage your product catalogues" and "Manage your business". WitCloud also reads your basic public profile.
- Click Save.

Catalog selection
Back in WitCloud, open Select catalogs and choose the catalogs you want to collect.

You can select multiple catalogs at once — WitCloud creates a separate data collect for each one, named after the collect name and the catalog (e.g. Facebook Catalog PL - Demo Catalog DE).

Optionally, click Show advanced settings to set:
- Data freshness (hours) — the minimum time between two collections of the catalog: a run that starts sooner after the last collection (for example, a manual re-run) is skipped. From 4 to 12 hours; default 4.
- Tables to collect — both tables are selected by default; remove the one you don't need (at least one is required).

Click Create to complete the configuration.

Done! Your Facebook Catalog data will now be synchronized with BigQuery.
Data synchronization
Facebook Catalog data is a current‑state snapshot of your product catalog, so there is no historical date‑range step: each run saves the catalog as it is at that moment and replaces that day's partition.
A data synchronization schedule is created automatically and collects the catalog once a day. More information on this topic can be found here.
Data schema
Expand the tables below to view the full data schema collected from Facebook Catalog.
Data schema for fb_catalog_products
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| catalog_id | NULLABLE | STRING |
| catalog_name | NULLABLE | STRING |
| product_id | NULLABLE | STRING |
| retailer_id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| description | NULLABLE | STRING |
| url | NULLABLE | STRING |
| image_url | NULLABLE | STRING |
| brand | NULLABLE | STRING |
| category | NULLABLE | STRING |
| product_type | NULLABLE | STRING |
| availability | NULLABLE | STRING |
| condition | NULLABLE | STRING |
| price | NULLABLE | STRING |
| sale_price | NULLABLE | STRING |
| currency | NULLABLE | STRING |
| gtin | NULLABLE | STRING |
| mpn | NULLABLE | STRING |
| color | NULLABLE | STRING |
| size | NULLABLE | STRING |
| custom_label_0 | NULLABLE | STRING |
| custom_label_1 | NULLABLE | STRING |
| custom_label_2 | NULLABLE | STRING |
| custom_label_3 | NULLABLE | STRING |
| custom_label_4 | NULLABLE | STRING |
Data schema for fb_catalog_product_sets
| Field Name | Mode | Type |
|---|---|---|
| date | NULLABLE | DATE |
| catalog_id | NULLABLE | STRING |
| catalog_name | NULLABLE | STRING |
| product_set_id | NULLABLE | STRING |
| product_set_name | NULLABLE | STRING |
| product_count | NULLABLE | INTEGER |
