Facebook Ads Connector

This Facebook Ads connector brings 512 marketing metrics & 128 dimensions straight into Snowflake, no pipelines required.<br/>

## 1. Scope & value

- All your paid-social data, always up-to-date. Stream campaign, ad-set, ad-level and creative-level data from Facebook & Instagram Ads directly into the Snowflake database of your choice.
- Query-ready on arrival. Fully typed tables (no VARIANT columns) arrive incrementally, so analysts can run ROAS, attribution or cohort LTV analyses with plain SQL seconds after each load.
- Runs 100 % inside your account. The Native App executes in-warehouse, inheriting Snowflake’s security, governance and role-based access controls.
- Zero maintenance. Windsor.ai auto-handles schema evolution, back-fills, retries and rate-limits while you focus on insights.

## 2. Sample tables & schemas

**FB_CAMPAIGN_STATS_DAILY** - grain: date × campaign. Sample fields include date, account_id, campaign_id, campaign_name, objective, buying_type, impressions, clicks, spend, reach, cpm, ctr, conversions, purchases, _load_timestamp.

**FB_ADSET_STATS_DAILY** - grain: date × ad set. Sample fields include date, adset_id, adset_name, optimization_goal, delivery_status, impressions, video_views, cost_per_result, spend, frequency, unique_clicks, add_to_cart, checkouts, _windsor_src.

## 3. Expected workflow for data consumers

1. Install the “Facebook Ads Connector”.
2. Authenticate with Meta Ads.
3. Pick your accounts.
4. Choose destination database / schema; table is created automatically.
5. Query & share: join with first-party tables, feed dashboards or securely share downstream via Snowflake Secure Share.

原始信息汇总

Facebook Ads Connector 数据集概述

1. 数据集提供商

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

2. 数据集范围与价值

• 包含512个营销指标和128个维度
• 数据实时更新，涵盖Facebook和Instagram广告的campaign、ad-set、ad-level和creative-level数据
• 数据以完全类型化的表格形式提供，无需VARIANT列
• 100%在用户账户内运行，继承Snowflake的安全、治理和基于角色的访问控制
• 零维护，自动处理模式演化、回填、重试和速率限制

3. 示例表结构

FB_CAMPAIGN_STATS_DAILY

• 粒度：日期 × campaign
• 示例字段：date, account_id, campaign_id, campaign_name, objective, buying_type, impressions, clicks, spend, reach, cpm, ctr, conversions, purchases, _load_timestamp

FB_ADSET_STATS_DAILY

• 粒度：日期 × ad set
• 示例字段：date, adset_id, adset_name, optimization_goal, delivery_status, impressions, video_views, cost_per_result, spend, frequency, unique_clicks, add_to_cart, checkouts, _windsor_src

4. 预期工作流程

1. 安装“Facebook Ads Connector”
2. 使用Meta Ads进行身份验证
3. 选择账户
4. 选择目标数据库/模式；表格自动创建
5. 查询与共享：与第一方表格连接，馈送仪表板或通过Snowflake Secure Share安全共享

5. 业务需求

数字广告性能

• 提供Facebook和Instagram广告的单一数据源
• 实时流式传输512个细粒度指标和128个维度
• 支持性能分析师跟踪KPI、基准趋势和发现问题

归因分析

• 支持与Google、TikTok、LinkedIn、HubSpot、Shopify等数百个其他数据源连接
• 支持多触点归因或MMM模型，揭示每个渠道的增量收入贡献和真实ROAS

6. 安全性

• 通过Snowflake安全审查
• 受Snowflake基于角色的访问控制保护
• 推荐授予以下权限：
  • 账户级别权限
  • 对象权限
  • 连接权限
  • 应用事件权限

7. 其他相关连接器

• Instagram Connector
• HubSpot Connector
• LinkedIn Ads Connector
• LinkedIn Pages Connector
• Google Search Console Connector
• TikTok Organic Connector

8. 类别

• Attribution Analysis
• Connectors
• Marketing
• Media

9. 联系方式

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

10. 云区域可用性

AWS

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

11. 关于Windsor.ai

• 帮助连接325+营销、分析、销售和CRM平台
• 将数据流式传输到Snowflake
• 支持在Snowflake中修改、连接和可视化数据

搜集汇总

背景与挑战

背景概述

该数据集提供512个营销指标和128个维度数据，可将Facebook和Instagram广告数据直接导入Snowflake数据库，支持实时查询分析且无需维护。用户通过安装连接器、认证账户并选择目标数据库后，即可自动创建表并进行数据查询和共享。