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公司页面的有机展示、粉丝、反应和点击数据同步到Snowflake，无需管道。
• 数据范围:
  • 110个指标和52个维度
  • 覆盖页面、帖子和视频级别的KPI（如观看次数、点击次数、反应、评论、分享、视频观看指标、粉丝增减、受众人口统计、设备和地理分割）

数据集结构

• 主要表结构:
  • 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安全审查。
• 访问控制: 通过Snowflake基于角色的访问控制保护数据。

提供商其他产品

• Instagram Connector
• HubSpot Connector
• LinkedIn Ads Connector
• Google Search Console Connector
• TikTok Organic Connector
• Bing Ads/Microsoft Ads Connector

支持与联系

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