LinkedIn Pages Connector

LinkedIn Pages Connector — Snowflake Native App by Windsor.ai

**Sync every organic impression, follower, reaction and click from your LinkedIn Company Page directly into Snowflake — fully typed, continuously updated, zero pipelines.** Windsor.ai’s native app streams *110 metrics and 52 dimensions* exposed by LinkedIn’s Organic Page API, so analysts can track reach, engagement and audience growth with pure SQL instead of CSV exports or the native analytics UI.

What the connector delivers

- **Comprehensive coverage** – pulls page-, post- and video-level KPIs (views, clicks, reactions, comments, shares, video-watch metrics, follower adds/losses, audience demographics, device & geo splits).
- **Query-ready tables** – landed as Snowflake columns (no VARIANT blobs) that follow warehouse best-practice naming and typing.
- **100 % in-warehouse execution** – ELT code runs inside your Snowflake account, inheriting RBAC, data masking and audit trails.
- **Hands-off maintenance** – Windsor.ai auto-handles OAuth refresh, pagination, historical back-fill, incremental syncs, schema evolution and retry logic.

Set-up in under five minutes

1. **Install** “LinkedIn Pages Connector by Windsor.ai” from Snowflake Marketplace.
2. **OAuth** to the LinkedIn organisation(s) you manage.

Sample tables & key fields (illustrative)

- **LI_PAGE_METRICS_DAILY** — date, organization_id, page_views, unique_page_views, impressions, clicks, reactions, comments, shares, followers_total, followers_new
- **LI_POST_METRICS_DAILY** — date, post_id, organization_id, post_type, impressions, clicks, video_views, reactions, comments, shares, engagement_rate
- **LI_FOLLOWERS_DEMOGRAPHIC_DAILY** — date, organization_id, country, industry, seniority, followers_count, followers_change
- **LI_VIDEO_WATCH_TIME** — date, post_id, organization_id, views_2s, views_25pct, views_50pct, views_75pct, views_100pct, average_watch_time

Top use-cases

- **Organic performance dashboards** – monitor reach, engagement and follower growth in Looker, Tableau or Power BI with data that’s always fresh.
- **Content & posting-time optimisation** – correlate engagement rates with post format, topic and publish time to refine your content calendar.
- **Competitive & influencer benchmarking** – pull metrics from multiple company pages to benchmark engagement and growth across business units, regions or competitors.
- **Cross-channel ROI analysis** – blend LinkedIn organic data with paid media, CRM and revenue data (325 + sources supported by Windsor.ai) to understand full-funnel impact.
- **Agency / multi-brand roll-ups** – consolidate dozens of pages into a single schema for portfolio benchmarking and automated client reporting.

原始信息汇总

LinkedIn Pages Connector 数据集概述

数据集基本信息

• 提供商: Windsor.ai
• 访问权限: 免费
• 访问类型: 无限访问
• 数据集类型: Snowflake原生应用

数据集内容

• 数据来源: LinkedIn公司页面的有机数据
• 数据指标: 110个指标和52个维度
• 数据更新: 持续更新，零管道
• 数据表结构: 查询就绪表，遵循仓库最佳实践命名和类型

主要数据表及字段

• LI_PAGE_METRICS_DAILY:
  • 日期、组织ID、页面浏览量、唯一页面浏览量、展示次数、点击次数、反应次数、评论次数、分享次数、总关注者数、新增关注者数
• LI_POST_METRICS_DAILY:
  • 日期、帖子ID、组织ID、帖子类型、展示次数、点击次数、视频观看次数、反应次数、评论次数、分享次数、参与率
• LI_FOLLOWERS_DEMOGRAPHIC_DAILY:
  • 日期、组织ID、国家、行业、资历、关注者数量、关注者变化
• LI_VIDEO_WATCH_TIME:
  • 日期、帖子ID、组织ID、2秒观看次数、25%观看次数、50%观看次数、75%观看次数、100%观看次数、平均观看时间

主要用途

• 有机性能仪表板: 监控覆盖范围、参与度和关注者增长
• 内容和发布时间优化: 关联参与率与帖子格式、主题和发布时间
• 竞争和影响者基准测试: 比较多个公司页面的参与度和增长
• 跨渠道ROI分析: 结合LinkedIn有机数据与付费媒体、CRM和收入数据
• 机构/多品牌汇总: 将多个页面合并到一个模式中

安全特性

• 安全审查: 已完成Snowflake安全审查
• 访问控制: 基于角色的访问控制（RBAC）
• 数据保护: 数据掩码和审计跟踪

设置步骤

1. 从Snowflake Marketplace安装“LinkedIn Pages Connector by Windsor.ai”
2. 对您管理的LinkedIn组织进行OAuth授权

提供商其他产品

• 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

云区域可用性

• AWS: 非洲（开普敦）、亚太（雅加达）、亚太（孟买）、亚太（大阪）等45个区域

法律条款

• 标准条款