ActiveCampaign Connector

Stream 23 metrics and 235 dimensions from ActiveCampaign into Snowflake with the ActiveCampaign Connector powered by Windsor.ai, no pipelines, no delays, just clean, query-ready marketing and CRM data.<br/><br/>**1. Scope & Value**

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

**2. Sample Tables & Schemas**

- **AC_CAMPAIGNS** grain: campaign – Sample fields include campaign_id, campaign_name, type, status, sent_date, opens, clicks, unsubscribes, _load_timestamp
- **AC_CONTACTS** grain: contact – Sample fields include contact_id, email, first_name, last_name, phone, organisation, created_date, last_updated_date,
- **AC_AUTOMATIONS** grain: automation – Sample fields include automation_id, name, status, total_contacts, contacts_in_automation, created_date, last_updated_date, _load_timestamp

**3. Workflow for Data Consumers**

1. Install the ActiveCampaign Connector.
2. Authenticate your ActiveCampaign 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.

原始信息汇总

ActiveCampaign Connector 数据集概述

数据集基本信息

• 提供商: Windsor.ai
• 价格: 免费
• 访问权限: 无限访问
• 数据刷新频率: 静态数据

数据集内容

• 数据流: 23个指标和235个维度
• 数据来源: ActiveCampaign
• 目标平台: Snowflake
• 数据特点: 无需管道、无延迟、清洁且可直接查询的营销和CRM数据

主要表格与结构

1. AC_CAMPAIGNS

   • 粒度: 活动
   • 示例字段: campaign_id, campaign_name, type, status, sent_date, opens, clicks, unsubscribes, _load_timestamp

2. AC_CONTACTS

   • 粒度: 联系人
   • 示例字段: contact_id, email, first_name, last_name, phone, organisation, created_date, last_updated_date

3. AC_AUTOMATIONS

   • 粒度: 自动化
   • 示例字段: automation_id, name, status, total_contacts, contacts_in_automation, created_date, last_updated_date, _load_timestamp

数据消费者工作流程

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

商业需求

• 分析营销自动化性能: 详细分析营销自动化的性能。
• 理解客户旅程: 结合其他触点数据，全面了解客户旅程。
• 衡量电子邮件营销的影响: 构建归因模型，衡量电子邮件营销对收入的影响。

安全性

• 安全审查: 已完成Snowflake安全审查。
• 访问控制: 基于角色的访问控制。
• 推荐权限: 安装后根据需要授予权限。

其他相关连接器

• Stripe Connector
• Instagram Connector
• Xero Connector
• HubSpot Connector
• LinkedIn Ads Connector
• LinkedIn Pages Connector

技术支持与联系

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