TikTok Organic Connector

TikTok Organic Connector — **Snowflake Native App by Windsor.ai**

**Turn every view, like and comment from your organic TikTok feed into query-ready Snowflake tables—no scrapers, no CSVs, just instant SQL.**<br/>The connector taps the official TikTok Organic APIs and streams **19 metrics and 33 dimensions** (views, likes, shares, audience demographics, watch-time and more) directly into your warehouse, fully typed and governed by Snowflake’s own security. [windsor.ai](https://windsor.ai/data-field/tiktok_organic/)

What the connector delivers

- **Comprehensive organic KPIs** – impressions, video-view funnels, engagement actions, profile stats and audience splits.
- **Typed, flat schemas** – never VARIANT; ready for Looker, Tableau, Power BI or Python.
- **100 % in-warehouse execution** – ELT code runs inside your Snowflake account, inheriting RBAC, masking and audit trails.
- **Hands-off maintenance** – Windsor.ai handles OAuth, historical back-fills, incremental syncs, schema evolution and retry logic.

Set-up in under five minutes

1. **Install** “TikTok Organic Connector by Windsor.ai” from Snowflake Marketplace.
2. **OAuth** to the TikTok Business account(s) you manage.
3. **Select** profiles and look-back window (full history supported).
4. **Choose** refresh cadence—hourly, daily or custom cron.
5. Data lands in the database / schema you specify; Windsor.ai keeps it fresh and consistent.

Sample tables & key fields (illustrative)

- **TTORG_MEDIA_STATS_DAILY** — date, video_id, username, media_type, plays, likes, comments, shares, saves, avg_watch_time, engagement_rate
- **TTORG_PROFILE_STATS_DAILY** — date, username, followers, following, videos_count, total_plays, likes_received, profile_views
- **TTORG_AUDIENCE_DEMOGRAPHICS** — date, username, gender, age_range, country, audience_percentage, _load_timestamp
- **TTORG_VIDEO_COMMENTS** — comment_id, video_id, username, text, like_count, sentiment_score, created_time

原始信息汇总

TikTok Organic Connector 数据集概述

数据集基本信息

• 名称: TikTok Organic Connector
• 提供商: Windsor.ai
• 访问权限: Free Unlimited Access
• 类型: Snowflake Native App

数据集内容

• 数据来源: 官方 TikTok Organic APIs
• 指标数量: 19 个
• 维度数量: 33 个
• 关键指标: views, likes, shares, audience demographics, watch-time 等

主要功能

• 全面的有机KPI: impressions, video-view funnels, engagement actions, profile stats, audience splits
• 结构化数据: 扁平化架构，支持 Looker, Tableau, Power BI 或 Python
• 全仓库执行: ELT 代码在 Snowflake 账户内运行，继承 RBAC、掩码和审计跟踪
• 免维护: Windsor.ai 处理 OAuth、历史回填、增量同步、架构演进和重试逻辑

设置步骤

1. 从 Snowflake Marketplace 安装 "TikTok Organic Connector by Windsor.ai"
2. OAuth 到管理的 TikTok Business 账户
3. 选择配置文件和回看窗口（支持完整历史）
4. 选择刷新频率（每小时、每天或自定义 cron）
5. 数据将存储在指定的数据库/架构中，由 Windsor.ai 保持更新

示例表及关键字段

• TTORG_MEDIA_STATS_DAILY: date, video_id, username, media_type, plays, likes, comments, shares, saves, avg_watch_time, engagement_rate
• TTORG_PROFILE_STATS_DAILY: date, username, followers, following, videos_count, total_plays, likes_received, profile_views
• TTORG_AUDIENCE_DEMOGRAPHICS: date, username, gender, age_range, country, audience_percentage, _load_timestamp
• TTORG_VIDEO_COMMENTS: comment_id, video_id, username, text, like_count, sentiment_score, created_time

商业需求

• 实时有机性能跟踪: 每小时监控播放、点赞、分享和观看时间
• 受众和趋势发现: 通过性别、年龄和国家分割识别新兴细分市场
• 跨渠道ROI报告: 将有机 TikTok 指标与 Meta Ads, GA4, Shopify 或其他 Windsor.ai 来源混合

安全性

• 安全审查: 已完成 Snowflake 安全审查
• 基于角色的访问控制: 数据受 Snowflake RBAC 保护
• 推荐权限: 安装后根据需要授予账户级别权限

提供商其他产品

• Multitouch Attribution Data in Snowflake
• HubSpot Connector
• Facebook Page Insights Connector
• Instagram Connector
• Google Ads Connector
• Facebook Ads Connector

类别

• Marketing

联系方式

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

云区域可用性

• AWS: Africa (Cape Town), Asia Pacific (Jakarta), Asia Pacific (Mumbai), Asia Pacific (Osaka) 等 45 个区域

法律条款

• Standard

关于提供商

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