HubSpot Connector

**Sync contacts, deals, emails, web sessions, and marketing activity from HubSpot directly into Snowflake — fully automated, no scripts or exports.**<br/>Windsor.ai’s native integration helps data, RevOps, and marketing teams unlock granular CRM and marketing data in near real-time, using only SQL — not spreadsheets or APIs.

What it does

- Connects to **HubSpot CRM, Marketing Hub, Sales Hub, and CMS**
- Streams **structured tables** into your Snowflake account (no VARIANT or JSON blobs)
- Handles **historical backfills**, **incremental loads**, and **schema evolution** automatically
- **Runs 100% inside Snowflake**, inheriting native security and access controls
- **No ETL pipeline or API script maintenance required**

Sample tables & fields

**HS_CONTACTS** — contact_id, email, lifecycle_stage, lead_status, country, created_at, updated_at, owner_id<br/>**HS_COMPANIES** — company_id, domain, industry, company_size, country, created_at, last_modified_at<br/>**HS_DEALS** — deal_id, deal_name, pipeline, deal_stage, deal_amount, closed_won_date, owner_id, created_at, _load_timestamp<br/>**HS_ACTIVITIES** — activity_id, type (email/call/meeting), timestamp, associated_contact_id, subject, owner_id, outcome<br/>**HS_MARKETING_EMAILS** — email_id, campaign_name, send_time, recipients, opens, clicks, bounces, unsubscribes

原始信息汇总

HubSpot Connector 数据集概述

数据集提供商

• Windsor.ai

数据集访问

• 免费
• 无限访问

数据集功能

• 自动同步HubSpot数据到Snowflake
• 支持HubSpot CRM、Marketing Hub、Sales Hub和CMS
• 提供结构化表格，无VARIANT或JSON blob
• 自动处理历史回填、增量加载和模式演变
• 100%在Snowflake内运行，继承原生安全和访问控制
• 无需维护ETL管道或API脚本

示例表及字段

• HS_CONTACTS: contact_id, email, lifecycle_stage, lead_status, country, created_at, updated_at, owner_id
• HS_COMPANIES: company_id, domain, industry, company_size, country, created_at, last_modified_at
• HS_DEALS: deal_id, deal_name, pipeline, deal_stage, deal_amount, closed_won_date, owner_id, created_at, _load_timestamp
• HS_ACTIVITIES: activity_id, type (email/call/meeting), timestamp, associated_contact_id, subject, owner_id, outcome
• HS_MARKETING_EMAILS: email_id, campaign_name, send_time, recipients, opens, clicks, bounces, unsubscribes

业务需求

• 统一的CRM和收入分析: 提供销售漏斗的全面视图，支持基于SQL的报告
• 归因分析: 将营销接触点与成交交易关联，支持多种归因模型
• 电子邮件和活动表现: 监控营销活动效果，与管道创建或收入关联
• 销售生产力和活动跟踪: 分析销售团队活动，识别表现和风险

安全性

• 通过Snowflake安全审查
• 基于角色的访问控制
• 推荐授予账户级别权限

其他相关数据集

• Multitouch Attribution Data in Snowflake
• Instagram Connector
• Google Ads Connector
• Facebook Ads Connector
• Bing Ads/Microsoft Ads Connector
• Google Analytics 4 Connector

类别

• 归因分析
• 连接器

联系方式

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

地理覆盖

• 全球
• 按地区/大陆

云区域可用性

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

法律条款

• 标准

关于Windsor.ai

• 提供连接营销、分析、销售和CRM平台的服务，将数据流式传输到Snowflake