Reddit Ads Connector

Reddit Ads Connector — Snowflake Native App by Windsor.ai

**Stream every impression, click and conversion from Reddit Ads directly into Snowflake—fully typed, auto-refreshing, and secured by your warehouse’s RBAC.**<br/>The connector ingests **all metrics and dimensions published in Windsor.ai’s Reddit field reference** (campaign, ad-group, creative, placement, device, geography and conversion data) and lands them in clean Snowflake tables ready for SQL or dbt.

What the connector delivers

- **Complete performance coverage** – clicks, impressions, spend, CTR, CPM, CPC, conversions, cost-per-conversion, and view-through events for every campaign, ad group and creative.
- **Audience & placement breakdowns** – device type, OS, country, subreddit placement, objective and bid strategy.
- **Typed, flat Snowflake schemas** – no VARIANT; every column has a native data type for Looker, Tableau or Power BI.
- **Zero maintenance** – authentication, historical back-fills, incremental syncs, schema evolution and retry logic are all handled automatically inside Snowflake.

Setup — live in < 5 minutes

1. Install **“Reddit Ads Connector by Windsor.ai”** from Snowflake Marketplace.
2. Authorise with your Reddit Ads account credentials.
3. Select look-back window and refresh cadence (hourly, daily or custom).
4. Data lands in the database / schema you specify; Windsor.ai keeps it continuously fresh.

Sample tables

**REDDITADS_CAMPAIGN_STATS_DAILY** — grain: *date × campaign*<br/>date, campaign_name, campaign_id, objective, impressions, clicks, spend, ctr, cpc, conversions, cp_conversion

**REDDITADS_ADGROUP_STATS_DAILY** — grain: *date × ad group*<br/>date, ad_group_name, ad_group_id, campaign_id, bid_strategy, device, country, impressions, clicks, spend, conversions

*(Additional tables expose creative-level and placement-level metrics with the same typed-column approach.)*

原始信息汇总

Reddit Ads Connector 数据集概述

数据集基本信息

• 提供商: Windsor.ai
• 访问权限: 免费
• 访问类型: 无限访问
• 数据集类型: Snowflake原生应用

数据集功能

• 数据连接: 将Reddit广告数据直接导入Snowflake
• 数据覆盖范围: 包含所有Windsor.ai Reddit字段参考中发布的指标和维度
• 数据类型: 完全类型化、扁平化的Snowflake模式，无VARIANT类型

数据内容

• 性能指标: 点击量、展示量、花费、CTR、CPM、CPC、转化次数、每次转化成本、浏览型转化事件
• 受众与投放细分: 设备类型、操作系统、国家、子reddit投放位置、目标和投标策略
• 表结构示例:
  • REDDITADS_CAMPAIGN_STATS_DAILY: 日期×广告系列粒度
    • 字段: date, campaign_name, campaign_id, objective, impressions, clicks, spend, ctr, cpc, conversions, cp_conversion
  • REDDITADS_ADGROUP_STATS_DAILY: 日期×广告组粒度
    • 字段: date, ad_group_name, ad_group_id, campaign_id, bid_strategy, device, country, impressions, clicks, spend, conversions

设置流程

1. 从Snowflake Marketplace安装“Reddit Ads Connector by Windsor.ai”
2. 使用Reddit Ads账户凭证授权
3. 选择回溯窗口和刷新频率（每小时、每天或自定义）
4. 数据将落地到指定的数据库/模式中，Windsor.ai保持数据持续更新

商业需求

• 创意与子reddit优化: 通过创意级指标和子reddit投放位置字段优化预算分配
• 受众与设备效率: 通过设备、操作系统和国家细分提高ROI
• 跨渠道预算分配: 与其他Windsor.ai连接器结合，比较不同渠道的CAC和增量转化

安全性

• 安全审查: 已完成Snowflake安全审查
• 访问控制: 由Snowflake基于角色的访问控制保护
• 推荐权限: 根据需要授予账户级别权限、对象权限、连接和应用事件权限

提供商其他产品

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

技术支持

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