Windsor.ai

ai Bring every click, cost and conversion from Microsoft Advertising straight into Snowflake — fully typed, continuously updated, zero pipeline maintenance . 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. ai” from Snowflake Marketplace.

OAuth to the Microsoft Ads accounts you manage. 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.