Google My Business Connector

Google My Business Connector — Snowflake Native App by Windsor.ai

**Sync local-search visibility, customer actions, and reviews from Google My Business (Google Business Profile) straight into Snowflake — fully typed, refresh-ready, zero pipelines.** Windsor.ai’s connector streams all **19 metrics and 83 dimensions** exposed by Google’s Business Profile APIs into in-warehouse tables, so analysts can track search/Maps exposure, calls, website visits and ratings with pure SQL.

What the app delivers

- **Search & Maps performance** – clicks and impressions for every location.
- **Engagement actions** – phone-calls, website visits, direction requests, etc.
- **Ratings & review text** – full comment stream plus response status.
- **Typed Snowflake tables** – never VARIANT; ready for Looker, Tableau or Power BI.
- **100 % in-warehouse ELT** – inherits Snowflake RBAC, masking and audit trails.
- **Hands-off maintenance** – OAuth refresh, back-fills, incremental syncs, schema-drift & retries handled for you.

Set-up in ≤ 5 minutes

1. **Install** “Google My Business by Windsor.ai” from Snowflake Marketplace.
2. **OAuth** to the Google account that owns your Business Profiles.
3. **Pick** locations, look-back window, and refresh cadence (hourly, daily, custom).
4. Data lands in the database/schema you specify; Windsor.ai keeps it fresh and consistent.

Sample table & fields (only fields from Windsor.ai’s reference)

**GMB_LOCATION_STATS_DAILY** — date, account_id, account_name, clicks, impressions, _load_timestamp

These core columns mirror the example query in Windsor.ai’s field reference and form the basis for joins with the 80 + additional dimensions and 14 + other metrics available via the connector.

原始信息汇总

Google My Business Connector 数据集概述

数据集提供商

• Windsor.ai

数据集特点

• 免费：提供无限访问权限
• 数据同步：将Google My Business（Google Business Profile）的本地搜索可见性、客户操作和评论数据同步到Snowflake
• 数据类型：包含19个指标和83个维度
• 数据表结构：完全类型化，无需VARIANT类型，可直接用于Looker、Tableau或Power BI

数据集内容

• 搜索和地图性能：每个位置的点击和展示数据
• 互动行为：电话、网站访问、方向请求等
• 评分和评论：完整的评论流及回复状态
• 数据表示例：GMB_LOCATION_STATS_DAILY（包含日期、账户ID、账户名称、点击量、展示量、加载时间戳等字段）

业务需求

• 位置性能可见性：跟踪每个店铺或分支在Google搜索和地图中的出现频率及用户行为
• 声誉和评论管理：分析评分、评论文本和响应时间
• 多位置基准测试：比较不同区域的流量意图
• 归因分析：将本地搜索数据与广告支出和销售数据结合，量化店铺访问提升和全渠道ROAS

安全性

• 安全审查：通过Snowflake安全审查
• 基于角色的访问控制：数据受Snowflake基于角色的访问控制保护

设置步骤

1. 从Snowflake Marketplace安装“Google My Business by Windsor.ai”
2. 通过OAuth授权Google账户
3. 选择位置、回溯窗口和刷新频率（每小时、每天或自定义）
4. 数据将存储在指定的数据库/模式中，并由Windsor.ai保持更新

其他相关数据集

• Instagram Connector
• HubSpot Connector
• LinkedIn Ads Connector
• LinkedIn Pages Connector
• Shopify Connector
• Google Search Console Connector

支持与联系

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

云区域可用性

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

关于提供商

Windsor.ai帮助用户连接325+个营销、分析、销售和CRM平台，并将数据流式传输到Snowflake。数据可在Snowflake中修改、连接和可视化。