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
• 测量覆盖范围、参与度和粉丝增长
• 无需电子表格或爬取

数据来源

• 使用官方Instagram Graph API（通过连接的Facebook页面）

数据结构

• 结构化、完全类型化的Snowflake表
• 支持多个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中创建有机性能仪表板
• 比较不同帖子类型的性能（照片、卷轴、故事）
• 跟踪个人资料增长和粉丝参与度随时间的变化
• 与付费媒体（Meta Ads）结合，生成混合覆盖范围和效率报告
• 跨市场对创作者或品牌个人资料进行基准测试

安全特性

• 符合Native Apps Framework安全要求
• 基于角色的访问控制

地理覆盖范围

• 全球
• 按地区/大陆

云区域可用性

AWS

• Africa (Cape Town)
• Asia Pacific (Jakarta)
• Asia Pacific (Mumbai)
• Asia Pacific (Osaka)
• 45 More

相关数据集

• Multitouch Attribution Data in Snowflake
• Google Ads Connector
• Facebook Ads Connector
• Google Analytics 4 Connector
• LinkedIn Ads Connector

搜集汇总

背景与挑战

背景概述

Instagram Connector通过官方Instagram Graph API将有机表现数据（如帖子、故事、粉丝统计等）自动同步至Snowflake，提供结构化表格和多种分析用例，支持多账户管理且无需维护。该工具适用于创建仪表板、跟踪表现和跨平台数据整合，具有安全、自动化和零代码设置的特点。