Bing Ads/Microsoft Ads Connector

Microsoft Ads (Bing Ads) Connector — Snowflake Native App by Windsor.ai

**Bring every click, cost and conversion from Microsoft Advertising straight into Snowflake — fully typed, continuously updated, zero pipeline maintenance**. Windsor.ai’s native app streams data from Search, Shopping, Audience, and Performance Max campaigns so analysts can answer ROI questions with pure SQL instead of CSV exports or brittle scripts.What the connector delivers

- **84 metrics and 146 dimensions** surfaced from the Microsoft Ads Reporting API, including spend, impressions, clicks, quality score, device, audience, keyword, and shopping-attribute breakdowns.
- **Query-ready tables** (no VARIANT) that follow Snowflake best practices for data types and primary keys.
- **100 % in-warehouse execution** — inherits Snowflake RBAC, masking policies, and audit trails; no data leaves your account.
- **Automatic handling** of historical back-fill, incremental syncs, schema evolution, OAuth refresh, and retry logic.

Setup in under five minutes

1. **Install** “Microsoft Ads (Bing Ads) Connector by Windsor.ai” from Snowflake Marketplace.
2. **OAuth** to the Microsoft Ads accounts you manage.

Sample tables & key fields

- **MSADS_CAMPAIGN_STATS_DAILY** — date, account_id, campaign_id, campaign_name, channel_type, status, impressions, clicks, spend, conversions, cpc, cpa, revenue
- **MSADS_ADGROUP_STATS_DAILY** — date, adgroup_id, campaign_id, adgroup_name, bid_strategy, impressions, clicks, spend, conversions, conv_value, quality_score, _windsor_src
- **MSADS_KEYWORD_STATS_DAILY** — date, keyword_id, adgroup_id, keyword_text, match_type, impressions, clicks, spend, conversions, ctr, avg_position, quality_score
- **MSADS_SEARCH_TERM_STATS_DAILY** — date, search_term, keyword_id, impressions, clicks, spend, conversions, cpc
- **MSADS_AUDIENCE_STATS_DAILY** — date, audience_id, audience_name, campaign_id, impressions, clicks, spend, conversions, device_type

Key use-cases

- **Cross-channel ROI reporting** — join Microsoft Ads with Google, Meta, LinkedIn and 325 + other sources Windsor.ai supports to calculate blended ROAS and customer-acquisition cost.
- **Keyword & search-term optimisation** — analyse match types, quality scores and negative keywords directly in Snowflake to surface bid and budget improvement opportunities.
- **Shopping & feed performance** — track product-level metrics and revenue to optimise Microsoft Shopping campaigns alongside Shopify or BigCommerce sales data.
- **Agency / multi-brand roll-ups** — consolidate dozens of ad accounts into one schema for portfolio benchmarking and automated client dashboards.
- **Data-science ready** — feed cost and conversion data into MMM, LTV or bid-strategy models without building custom extraction code.

原始信息汇总

Bing Ads/Microsoft Ads Connector 数据集概述

数据集提供商

• Windsor.ai

数据集特点

• 免费：提供无限访问权限
• 数据类型：包含84个指标和146个维度
• 数据表结构：查询就绪的表（非VARIANT类型），遵循Snowflake最佳实践
• 执行方式：100%在仓库内执行，继承Snowflake的RBAC、掩码策略和审计跟踪

主要数据表及关键字段

• MSADS_CAMPAIGN_STATS_DAILY
  关键字段：date, account_id, campaign_id, campaign_name, channel_type, status, impressions, clicks, spend, conversions, cpc, cpa, revenue
• MSADS_ADGROUP_STATS_DAILY
  关键字段：date, adgroup_id, campaign_id, adgroup_name, bid_strategy, impressions, clicks, spend, conversions, conv_value, quality_score, _windsor_src
• MSADS_KEYWORD_STATS_DAILY
  关键字段：date, keyword_id, adgroup_id, keyword_text, match_type, impressions, clicks, spend, conversions, ctr, avg_position, quality_score
• MSADS_SEARCH_TERM_STATS_DAILY
  关键字段：date, search_term, keyword_id, impressions, clicks, spend, conversions, cpc
• MSADS_AUDIENCE_STATS_DAILY
  关键字段：date, audience_id, audience_name, campaign_id, impressions, clicks, spend, conversions, device_type

主要应用场景

• 跨渠道ROI报告：与Google、Meta、LinkedIn等325+其他数据源结合计算混合ROAS和客户获取成本
• 关键词和搜索词优化：分析匹配类型、质量得分和否定关键词
• 购物和Feed性能：跟踪产品级指标和收入
• 机构/多品牌汇总：将多个广告账户数据整合到一个模式中
• 数据科学准备：将成本和转化数据输入MMM、LTV或投标策略模型

安全特性

• 安全审查：通过Snowflake安全审查
• 访问控制：受Snowflake基于角色的访问控制保护
• 推荐权限：安装后根据需要授予账户级别权限

安装步骤

1. 从Snowflake Marketplace安装“Microsoft Ads (Bing Ads) Connector by Windsor.ai”
2. 通过OAuth连接到管理的Microsoft Ads账户

其他信息

• 文档：https://support.windsor.ai/
• 销售联系：[e-mail]

搜集汇总

背景与挑战

背景概述

该数据集通过Snowflake原生应用提供Microsoft Ads的84个指标和146个维度数据，包括点击、花费和转化等，支持自动同步和查询就绪表格式。适用于跨渠道ROI分析、关键词优化、购物广告性能跟踪等多场景，无需维护数据管道即可实现高效分析。