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
• 结构化表直接流式传输到Snowflake账户
• 自动处理历史回填、增量加载和模式演变
• 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安全审查
• 受Snowflake基于角色的访问控制保护
• 建议安装后根据需要授予以下权限:
  • 账户级别权限
  • 对象权限
  • 连接权限
  • 应用事件权限

其他相关连接器

• Instagram Connector
• LinkedIn Ads Connector
• LinkedIn Pages Connector
• Google Search Console Connector
• TikTok Organic Connector
• Bing Ads/Microsoft Ads Connector

类别

• 归因分析
• 连接器

联系方式

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

云区域可用性

• AWS多个区域可用

关于Windsor.ai

• 帮助连接325+个营销、分析、销售和CRM平台，并将数据流式传输到Snowflake

搜集汇总

背景与挑战

背景概述

该数据集通过自动化集成将HubSpot的CRM、营销和销售数据实时同步到Snowflake，支持结构化表存储和自动更新，无需额外ETL维护。包含联系人、公司、交易、活动和营销邮件等多类业务数据表及其详细字段。