Facebook Page Insights Connector

Facebook Page Insights Connector — Snowflake Native App by Windsor.ai

**Stream every organic impression, reaction and share from your Facebook Pages straight into Snowflake — fully typed, continuously updated, zero pipelines.** The connector covers *page-, post- and media-level* analytics, giving analysts one governed source of truth for community growth, engagement and content ROI.

What the app delivers

- **197 metrics & 113 dimensions** out of the Facebook Graph “Page Insights” API — including reach, impressions, engaged users, reactions, comments, shares, fan adds/losses, audience geo & age splits.
- **Fully-typed Snowflake tables** (no VARIANT) ready for SQL, Looker, Tableau or Power BI.
- **Runs 100 % inside your Snowflake account**: inherits RBAC, masking policies and audit trails.
- **Auto-handles** OAuth, historical back-fill, incremental syncs, schema evolution and retries.

How it works (≤ 5 minutes)

1. **Install** “Facebook Page Insights by Windsor.ai” from Snowflake Marketplace.
2. **OAuth** to the Facebook Pages you manage.
3. **Choose objects & look-back window** (full history supported).
4. **Set refresh cadence** — up to hourly for near-real-time dashboards.
5. Data lands in your chosen DB/schema; Windsor.ai maintains sync jobs end-to-end. [windsor.ai](https://windsor.ai/connect/facebook-page-insights-snowflake-integration/?utm_source=chatgpt.com)

Sample tables & key fields (illustrative)

**FB_PAGE_METRICS_DAILY** — date, page_id, page_name, page_impressions, page_impressions_unique, page_engaged_users, page_fan_adds, page_fan_removes, page_video_views, page_total_actions

**FB_POST_METRICS_DAILY** — date, post_id, page_id, impressions, reach, reactions, comments, shares, link_clicks, video_views, saves, engagement_rate

**FB_POSTS_DIM** — post_id, page_id, created_time, message, permalink_url, status_type, media_type, is_published, _windsor_src

**FB_FAN_GEO_DAILY** — date, page_id, country_iso, fans, fans_change

**FB_VIDEO_METRICS_DAILY** — date, post_id, views_3s, views_30s, avg_watch_time, retention_95pct

<p><br/></p>

Top use-cases

- **Organic performance dashboards** — track reach, engagement and follower growth by content type.
- **Content & posting-time optimisation** — analyse which formats, topics and time slots drive highest engagement or click-through.
- **Cross-channel reporting** — blend Page Insights with Meta Ads, Instagram, GA4 or Shopify data (325 + sources supported) for holistic ROI analysis.
- **Agency / multi-brand roll-ups** — consolidate dozens of Pages into one schema for portfolio benchmarking.
- **Data-science ready** — feed sentiment models or predictive LTV analyses without writing extraction code.

原始信息汇总

Facebook Page Insights Connector 数据集概述

数据集提供商

• Windsor.ai

数据集特点

• 免费：提供无限访问权限
• 数据内容：涵盖Facebook页面、帖子和媒体级别的分析数据
• 数据规模：包含197个指标和113个维度
• 数据类型：完全类型化的Snowflake表（非VARIANT类型）
• 运行环境：100%在用户Snowflake账户内运行，继承RBAC、掩码策略和审计跟踪

数据集内容

主要表结构及关键字段

• FB_PAGE_METRICS_DAILY
  包含字段：date, page_id, page_name, page_impressions, page_impressions_unique, page_engaged_users, page_fan_adds, page_fan_removes, page_video_views, page_total_actions
• FB_POST_METRICS_DAILY
  包含字段：date, post_id, page_id, impressions, reach, reactions, comments, shares, link_clicks, video_views, saves, engagement_rate
• FB_POSTS_DIM
  包含字段：post_id, page_id, created_time, message, permalink_url, status_type, media_type, is_published, _windsor_src
• FB_FAN_GEO_DAILY
  包含字段：date, page_id, country_iso, fans, fans_change
• FB_VIDEO_METRICS_DAILY
  包含字段：date, post_id, views_3s, views_30s, avg_watch_time, retention_95pct

主要应用场景

• 有机性能仪表板：跟踪内容类型的覆盖范围、参与度和粉丝增长
• 内容和发布时间优化：分析哪些格式、主题和时间段驱动最高的参与度或点击率
• 跨渠道报告：将Page Insights与Meta Ads、Instagram、GA4或Shopify数据混合
• 机构/多品牌汇总：将数十个页面合并到一个模式中进行组合基准测试
• 数据科学准备：为情感模型或预测性LTV分析提供数据

安全特性

• 安全审查：已完成Snowflake安全审查
• 访问控制：受Snowflake基于角色的访问控制保护

提供商其他产品

• Multitouch Attribution Data in Snowflake
• HubSpot Connector
• Instagram Connector
• Google Ads Connector
• Facebook Ads Connector
• Bing Ads/Microsoft Ads Connector

技术支持与联系

• 销售支持：[e-mail]
• 技术支持：https://support.windsor.ai

搜集汇总

背景与挑战

背景概述

该数据集通过Facebook Page Insights Connector将Facebook页面的有机表现数据（包括展示、互动和分享）直接流式传输到Snowflake平台，提供页面、帖子和媒体级别的分析。它包含197个指标和113个维度，支持自动同步和历史回填，适用于社区增长跟踪、内容优化及跨渠道ROI分析等场景。