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
• 价格: 免费
• 访问权限: 无限访问
• 数据集类型: Snowflake Native App

数据集内容

• 数据来源: Google My Business (Google Business Profile)
• 数据内容:
  • 本地搜索可见性
  • 客户行为数据
  • 评论数据
• 数据维度: 83个维度
• 数据指标: 19个指标

主要功能

• 搜索和地图性能: 每个位置的点击和展示数据
• 互动行为: 电话、网站访问、路线请求等
• 评分和评论: 完整评论流及回复状态
• 数据表结构: 类型化Snowflake表，支持Looker、Tableau或Power BI
• 数据处理: 100%仓库内ELT，继承Snowflake RBAC、掩码和审计跟踪
• 维护: 自动处理OAuth刷新、回填、增量同步、模式漂移和重试

设置步骤

1. 从Snowflake Marketplace安装"Google My Business by Windsor.ai"
2. 通过OAuth连接到拥有业务资料的Google账户
3. 选择位置、回溯窗口和刷新频率(每小时、每天或自定义)
4. 数据将存储在指定的数据库/模式中，由Windsor.ai保持更新

示例表结构

• 表名: GMB_LOCATION_STATS_DAILY
• 字段示例: date, account_id, account_name, clicks, impressions, _load_timestamp

商业需求支持

• 位置性能可视化: 跟踪店铺在Google搜索和地图中的出现频率及用户行为
• 声誉和评论管理: 分析评分、评论文本和响应时间
• 多位置基准测试: 跨区域比较客流意图
• 归因分析: 将本地搜索与广告支出和销售数据结合分析

安全性

• 通过Snowflake安全审查
• 基于角色的访问控制(RBAC)
• 推荐授予的权限:
  • 账户级别权限
  • 对象权限
  • 连接权限
  • 应用事件权限

提供商其他产品

• Multitouch Attribution Data in Snowflake
• HubSpot Connector
• Instagram Connector
• Google Ads Connector
• Facebook Ads Connector
• Bing Ads/Microsoft Ads Connector

技术支持

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

云区域可用性

• AWS:
  • Africa (Cape Town)
  • Asia Pacific (Jakarta)
  • Asia Pacific (Mumbai)
  • Asia Pacific (Osaka)
  • 45个其他区域