Zoho Connector

<br/>The Zoho CRM Connector by Windsor.ai streams 164 metrics and 709 dimensions directly into Snowflake—fully typed, pipeline-free and ready for fast, insightful customer and sales analytics.<br/><br/>**1. Scope & Value**

- **Always up-to-date CRM data** Stream leads, deals, contacts, and account data directly from Zoho CRM into your Snowflake instance.
- **Query-ready on arrival** Data lands in fully typed tables (no VARIANT columns) and loads incrementally, run sales performance and customer analyses using plain SQL within seconds.
- **Runs 100% in your Snowflake account** Executes as a Snowflake Native App, inheriting Snowflake’s security, governance, and role-based access controls.
- **Zero maintenance required** Windsor.ai handles schema changes, backfills, retries, and rate limits, so you can focus on insights, not infrastructure.

**2. Sample Tables & Schemas**

- **ZOHO_LEADS** grain: lead – Sample fields include: lead_id, company, first_name, last_name, email, phone, lead_source, status, created_time, _load_timestamp
- **ZOHO_DEALS** grain: deal – Sample fields include: deal_id, deal_name, stage, amount, closing_date, account_id, contact_id, owner_id, created_time, _windsor_src
- **ZOHO_ACCOUNTS** grain: account – Sample fields include: account_id, account_name, industry, phone, website, annual_revenue, number_of_employees, created_time, _load_timestamp

**3. Workflow for Data Consumers**

1. Install the Zoho CRM Connector
2. Authenticate your Zoho CRM account
3. Select your account and choose the destination database/schema (tables are created automatically)
4. Start querying and sharing: join with other business data, power dashboards, or share securely via Snowflake Secure Share

原始信息汇总

Zoho Connector 数据集概述

1. 数据集提供商

• 提供商: Windsor.ai
• 访问权限: 免费
• 访问类型: 无限访问

2. 数据集概述

• 描述: Zoho CRM Connector by Windsor.ai 将 164 个指标和 709 个维度直接流式传输到 Snowflake，数据完全类型化、无需管道，适用于快速、深入的客户和销售分析。
• 关键特性:
  • 实时更新的 CRM 数据
  • 查询即用，数据以完全类型化的表形式存储
  • 100% 在 Snowflake 账户中运行
  • 零维护需求

3. 数据表与模式

• ZOHO_LEADS:
  • 粒度: lead
  • 示例字段: lead_id, company, first_name, last_name, email, phone, lead_source, status, created_time, _load_timestamp
• ZOHO_DEALS:
  • 粒度: deal
  • 示例字段: deal_id, deal_name, stage, amount, closing_date, account_id, contact_id, owner_id, created_time, _windsor_src
• ZOHO_ACCOUNTS:
  • 粒度: account
  • 示例字段: account_id, account_name, industry, phone, website, annual_revenue, number_of_employees, created_time, _load_timestamp

4. 工作流程

1. 安装 Zoho CRM Connector
2. 验证 Zoho CRM 账户
3. 选择账户和目标数据库/模式（表自动创建）
4. 开始查询和共享数据

5. 业务需求

• 销售绩效分析: 跟踪关键指标如潜在客户转化率、交易速度和销售周期长度。
• 360度客户视图: 结合其他系统数据，全面了解客户生命周期。

6. 安全性

• 安全审查: 已完成 Snowflake 安全审查
• 访问控制: 基于角色的访问控制
• 推荐权限: 账户级别权限、对象权限、连接权限、应用事件权限

7. 其他信息

• 数据刷新: 静态数据
• 云区域可用性: 支持 AWS 多个区域（如非洲开普敦、亚太雅加达等）
• 法律条款: 标准条款

8. 提供商信息

• 关于 Windsor.ai: 帮助连接 325+ 营销、分析、销售和 CRM 平台，将数据流式传输到 Snowflake。
• 联系方式:
  • 销售: [e-mail]
  • 支持: https://support.windsor.ai/