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个维度
• 关键字段示例:
  • FB_PAGE_METRICS_DAILY: 日期、页面ID、页面名称、页面展示次数、唯一页面展示次数、页面参与用户数、粉丝增加数、粉丝减少数、视频观看次数、总操作数
  • FB_POST_METRICS_DAILY: 日期、帖子ID、页面ID、展示次数、覆盖人数、反应数、评论数、分享数、链接点击次数、视频观看次数、保存次数、参与率
  • FB_POSTS_DIM: 帖子ID、页面ID、创建时间、消息内容、永久链接URL、状态类型、媒体类型、是否发布
  • FB_FAN_GEO_DAILY: 日期、页面ID、国家ISO代码、粉丝数、粉丝变化数
  • FB_VIDEO_METRICS_DAILY: 日期、帖子ID、3秒观看次数、30秒观看次数、平均观看时间、95%保留率

数据集特点

• 数据格式: 完全类型化的Snowflake表（无VARIANT类型）
• 运行环境: 100%在用户Snowflake账户内运行
• 自动化处理: 包括OAuth、历史数据回填、增量同步、模式演化和重试机制

主要用途

• 有机性能仪表板: 跟踪覆盖范围、参与度和粉丝增长
• 内容和发布时间优化: 分析哪些格式、主题和时间段驱动最高参与度或点击率
• 跨渠道报告: 将页面洞察与Meta广告、Instagram、GA4或Shopify数据结合
• 机构/多品牌汇总: 将多个页面数据整合到一个模式中
• 数据科学准备: 无需编写提取代码即可进行情感模型或预测LTV分析

业务需求

• 持续有机性能跟踪
• 内容与发布时间优化
• 受众增长与粉丝健康
• 机构与多品牌整合

安全性

• 安全审查: 已完成Snowflake安全审查
• 访问控制: 基于角色的访问控制（RBAC）
• 推荐权限: 安装后根据需要授予特定权限

联系方式

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

类别

• 媒体

关于提供商

Windsor.ai帮助用户连接325+营销、分析、销售和CRM平台，并将数据流式传输到Snowflake。