Connect Shopify to Microsoft Copilot

Windsor.ai gives Copilot Agent access to 300+ metrics and dimensions, including:

• Sales and Revenue: gross sales, net sales, order total price, subtotal, total discounts, refund amounts, and net payment.
• Orders: order count, order status, fulfillment status, payment status, discount codes, sales channel, order tags.
• Products and inventory: product title, variant price, inventory quantity, unit cost (requires ‘View product costs’ permission), product status, vendor.
• Customers: total spend, order count per customer, average order value, customer state, email marketing consent, returning vs. new customer.
• Attribution and traffic: UTM source, UTM campaign, UTM medium, UTM content, last visit referrer URL, last visit landing page.
• Fulfillment and shipping: fulfillment created and delivered dates, shipping address by city and country, shipping price, fulfillment service.

Yes. Windsor.ai supports multiple Shopify accounts under a single workspace, each identified by its own store name and account ID. Agencies managing several brands or merchants running regional storefronts can pull them all into a Copilot Agent and query stores individually or compare them side by side.

Absolutely. Once Google Ads or Facebook Ads are added alongside Shopify via Windsor.ai, the Copilot Agent matches Shopify order revenue against ad spend using UTM attribution data. It helps you calculate blended ROAS, compare customer acquisition cost against average order value, or flag campaigns where spend is rising while order volume is flat.

Yes. Ask Copilot to rank products by order count, total revenue, or net sales (after discounts and refunds) over any date range. You can also slice by product type, vendor, or variant, for example:

Show my top 10 products by net sales over the last 30 days. For each, break down which variant (size, color, or option) drove the most orders.

This surfaces not just what sells, but what specifically within a product line is moving.

Here are examples of  more specific prompts you can use to dive deep into your Shopify data:

• Analyze my discount code usage over the last 90 days. For each code, show how many orders used it, total discount value given away, average order value with vs. without a discount code, and net sales generated. Identify which codes are driving incremental revenue and which are just eroding margin.

• Break down my UTM campaign performance by shipping country. For each country, show total orders, net sales, and average order value. Show me markets where I'm generating strong order volume but below-average order value, and suggest pricing or bundling adjustments.

• Segment my customers by order frequency: one-time buyers, 2–3 orders, and 4+ orders. For each segment show total customer count, average total spend per customer, and the top 3 products purchased. Which product appears most in the first order of customers who go on to buy 4 or more times?

• Compare my Shopify revenue against my Facebook Ads spend over the last 30 days using UTM campaign data. For each campaign, show total ad spend, attributed Shopify orders, gross revenue, and blended ROAS. Flag any campaign where spend increased week-over-week but Shopify order volume from that UTM source stayed flat or declined.

Windsor.ai’s pricing for Microsoft Copilot data integration varies depending on the number of connected accounts and data sources. We offer absolutely transparent pricing plans for diversified business needs and budgets, along with a 30-day free trial and Windsor MCP included in every plan.

With Windsor MCP, the integration process takes a few minutes. No technical expertise or coding is required; connecting data to Copilot is simple, straightforward, and accessible to everyone.

Yes, we have helpful resources to help you get started. You can explore our official documentation and tutorials for seamless Shopify to Copilot Agent integration with Windsor.ai:

• Shopify Field Reference
• Copilot Agent Integration Documentation