Shopify Connector

**Sync every order, customer, and product signal from Shopify straight into Snowflake—fully typed, auto-refreshing, and governed by your warehouse’s security.** The connector exposes the **78 metrics and 253 dimensions** listed in Windsor.ai’s public field reference, so you can analyse sales, lifetime value, discounts, fulfilment and more with nothing but SQL.

What the app delivers

- **Order-level commerce facts** – revenue, discounts, taxes, fulfilment status, cancellations and line items.
- **Customer-360 attributes** – spend to-date, orders-count, tags, state and verified-email flags.
- **Typed Snowflake tables** – no VARIANT blobs; ready for Looker, Tableau, Power BI or dbt.
- **100 % in-warehouse ELT** – all code runs inside Snowflake, inheriting existing RBAC and masking policies.
- **Hands-off maintenance** – OAuth refresh, historical back-fills, incremental syncs, schema evolution and retry logic handled automatically.

Set-up (≈ 5 minutes)

1. **Install** “Shopify Connector by Windsor.ai” from Snowflake Marketplace.
2. **OAuth** to the Shopify store(s) you manage.
3. **Select** the look-back window and refresh cadence (hourly, daily or custom).
4. Data lands in the database / schema you specify; Windsor.ai keeps it fresh and consistent.

**Sample tables**

**SHOPIFY_ORDERS_DAILY** — grain: *date × order*.<br/>Columns: order_id, order_created_at, order_sales_channel, order_current_total_price, order_total_price, order_currency, order_email, order_financial_status, order_updated_at.

**SHOPIFY_CUSTOMERS_DAILY** — grain: *date × customer*.<br/>Columns: customer_id, customer_email, customer_first_name, customer_last_name, customer_created_at, customer_total_spent, customer_orders_count, customer_state.

原始信息汇总

Shopify Connector 数据集概述

数据集基本信息

• 提供商: Windsor.ai
• 访问权限: 免费
• 访问类型: 无限访问
• 主要功能: 将Shopify数据同步至Snowflake，包含订单、客户和产品信号

数据集内容

• 指标数量: 78个
• 维度数量: 253个
• 数据类型: 完全类型化，非VARIANT blobs
• 同步方式: 自动刷新，历史回填，增量同步

主要表结构

SHOPIFY_ORDERS_DAILY

• 粒度: 日期 × 订单
• 列: order_id, order_created_at, order_sales_channel, order_current_total_price, order_total_price, order_currency, order_email, order_financial_status, order_updated_at

SHOPIFY_CUSTOMERS_DAILY

• 粒度: 日期 × 客户
• 列: customer_id, customer_email, customer_first_name, customer_last_name, customer_created_at, customer_total_spent, customer_orders_count, customer_state

业务需求

• 实时收入与平均订单价值跟踪
• 客户生命周期价值分析
• 归因分析

安全特性

• 安全审查: 已完成Snowflake安全审查
• 访问控制: 基于角色的访问控制(RBAC)
• 数据保护: 继承现有RBAC和掩码策略

设置步骤

1. 从Snowflake Marketplace安装“Shopify Connector by Windsor.ai”
2. 对管理的Shopify商店进行OAuth授权
3. 选择回看窗口和刷新频率（每小时、每天或自定义）
4. 数据将落地到指定的数据库/模式中，由Windsor.ai保持数据新鲜和一致

提供商其他产品

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

支持与联系

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

搜集汇总

背景与挑战

背景概述

该数据集将Shopify的订单、客户和产品数据同步至Snowflake，包含78个指标和253个维度，支持完整的商业分析。它提供自动刷新、类型化表和仓库内ELT处理，安装配置仅需5分钟即可完成。