Instagram Connector

**Sync organic Instagram performance data directly into Snowflake to measure reach, engagement, and follower growth — no spreadsheets, no scraping.**<br/>Windsor.ai’s Snowflake Native App connects to the Instagram Graph API and lands structured, query-ready tables that cover your posts, reels, stories, audience insights, and more — updated automatically and governed by Snowflake’s built-in security.

What it does

- Streams **organic Instagram data** (not ads) into Snowflake: posts, reels, stories, followers, profile stats
- Uses the official **Instagram Graph API** (via connected Facebook Page)
- Structures data into **fully typed Snowflake tables** (no JSON blobs)
- Supports **multiple IG Business or Creator accounts**
- **Executes inside your Snowflake environment**, with zero-code setup

## Sample tables & fields

**IG_MEDIA_STATS** — media_id, media_type, caption, permalink, like_count, comment_count, saved_count, reach, impressions, engagement_rate, timestamp<br/>**IG_STORY_STATS** — story_id, media_type, reach, replies, exits, taps_forward, taps_back, impressions, timestamp, _windsor_src<br/>**IG_REEL_STATS** — reel_id, plays, likes, comments, shares, saves, reach, engagement_rate<br/>**IG_PROFILE_METRICS_DAILY** — account_id, followers, follows, posts_count, profile_views, website_clicks, email_clicks, date<br/>**IG_AUDIENCE_INSIGHTS** — account_id, country, city, gender, age_range, followers_count, date

## Key use cases

- Organic performance dashboards in Looker, Tableau or Power BI
- Compare performance across post types (photo vs reel vs story)
- Track profile growth and follower engagement over time
- Combine with paid media (Meta Ads) for blended reach & efficiency reports
- Benchmark creators or brand profiles across markets

## Why analysts love this connector

- **No scraping or manual exports** — official API, automated syncs
- **Snowflake-native** — secure, scalable, role-based access
- **Works with other Windsor.ai sources** — including Google Ads, Facebook Ads, GA4, Shopify, TikTok, HubSpot, etc.
- **Zero maintenance** — schema evolution, retry handling, and auth refreshes managed for you

原始信息汇总

Instagram Connector 数据集概述

数据集提供商

• 提供商: Windsor.ai
• 费用: 免费
• 访问权限: 无限访问

数据集功能

• 将有机Instagram数据（非广告）直接同步到Snowflake，包括帖子、Reels、故事、粉丝和资料统计。
• 使用官方Instagram Graph API（通过连接的Facebook页面）。
• 将数据构建为完全类型化的Snowflake表（非JSON块）。
• 支持多个IG商业或创作者账户。
• 在Snowflake环境中执行，无需代码设置。

示例表及字段

• IG_MEDIA_STATS: media_id, media_type, caption, permalink, like_count, comment_count, saved_count, reach, impressions, engagement_rate, timestamp
• IG_STORY_STATS: story_id, media_type, reach, replies, exits, taps_forward, taps_back, impressions, timestamp, _windsor_src
• IG_REEL_STATS: reel_id, plays, likes, comments, shares, saves, reach, engagement_rate
• IG_PROFILE_METRICS_DAILY: account_id, followers, follows, posts_count, profile_views, website_clicks, email_clicks, date
• IG_AUDIENCE_INSIGHTS: account_id, country, city, gender, age_range, followers_count, date

主要用例

• 在Looker、Tableau或Power BI中创建有机性能仪表板。
• 比较不同类型帖子（照片、Reel、故事）的性能。
• 跟踪资料增长和粉丝参与度随时间的变化。
• 与付费媒体（Meta广告）结合，生成混合覆盖范围和效率报告。
• 跨市场对创作者或品牌资料进行基准测试。

安全特性

• 通过Snowflake安全审查。
• 数据受Snowflake基于角色的访问控制保护。
• 建议安装后根据需要授予以下权限：
  • 账户级别权限
  • 对象权限
  • 连接权限
  • 应用事件权限

相关数据集

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

类别

• 市场营销
• 媒体

联系方式

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

云区域可用性

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

搜集汇总

背景与挑战

背景概述

Instagram Connector是一个Snowflake原生应用，通过Instagram Graph API自动同步有机Instagram性能数据（如帖子、故事、粉丝统计等）到Snowflake，提供结构化表格且支持多账户管理。该工具无需手动操作，保障数据安全，适用于性能分析和跨平台报告。