How to Use Windsor.ai for E-commerce

Every client I work with at Wilgot runs a store, and the question that comes up most is what a sale cost to get. Shopify has the orders and revenue, Meta Ads and Google Ads have the spend, GA4 has what shoppers did before checkout, and someone has to pull all three and match them by week. The week after, the same pull needs doing again.

My job there is SEO, but I’m in Shopify, the ad accounts and GA4 most days to understand what is happening around the search work. So I connected them to Windsor.ai and added Windsor to Claude, and I ask for the blended numbers there instead of building them. ChatGPT, Gemini and Perplexity work the same way.

🚀 Ready to see it live? Try Windsor.ai free, free forever plan, no credit card.

Already using Claude? Add the Windsor.ai for E-commerce connector directly from the Claude directory. On ChatGPT, Gemini or Perplexity, add Windsor the same way from that assistant’s own connector or app directory. This guide covers analyzing your store’s performance from an AI assistant. Shopify’s own ChatGPT shopping feature, which lets customers buy inside ChatGPT, is a separate product.

Connecting your e-commerce data to your AI assistant with Windsor: 2 steps

Windsor.ai is a single connector that reads from 350+ data sources, including Shopify, Amazon Seller Central, WooCommerce, BigCommerce, Google Merchant Center, GA4 and every major ad platform, and sends it wherever you work. Setup is two steps: connect your sources in Windsor, then add Windsor to your assistant.

Before you start

• A Shopify or Amazon Seller Central account (WooCommerce and BigCommerce also supported)
• A Windsor.ai account (free for the first 30 days to test; paid plans start at $19/month for 3 sources, $99/month for 7)
• A Claude, ChatGPT, Gemini or Perplexity account

Step 1: Connect your store and ad accounts to Windsor

Go to onboard.windsor.ai/app/shopify and sign in to authorize your store. Then add the accounts that give you the full picture:

• Meta Ads and Google Ads, for what you spent to get each sale
• Google Merchant Center, if you run Shopping campaigns
• GA4, for on-site behavior before checkout
• Amazon Seller Central, if you sell there too

The free plan lets you test multiple sources for the first 30 days, then drops to a single source with no credit card required. Keeping every account connected long-term takes a paid plan: $19/month for 3 sources, $99/month for 7, so you’re not stuck re-connecting or losing history as the store grows.

Step 2: Add Windsor to your AI assistant

• Claude: Customize → Connectors → search Windsor → Add
• ChatGPT: install Windsor’s native app from the ChatGPT apps directory
• Gemini and Perplexity: add Windsor from that assistant’s own connector or app directory

Sign in to your Windsor.ai account when prompted, then confirm it works with a simple question: “how many orders did we get last week.”

The numbers I track once it’s connected

Metric	What it tells you
Orders and revenue (Shopify, Amazon Seller Central, WooCommerce, BigCommerce)	What sold
Ad spend by platform	What it cost to sell it
ROAS / blended ROAS	Revenue divided by total ad spend, per channel or across every connected platform combined
Gross margin	Revenue minus cost of goods, before marketing cost
Sessions and add-to-cart rate (GA4)	Where shoppers drop off before buying
Marketplace sales (Amazon Seller Central)	Revenue outside your own store
Refunds and cancellations	How much of that revenue holds

The reports e-commerce teams run most

These are the questions e-commerce teams ask Windsor most often.

Orders and revenue

• How many orders did we get this week, and what was our total revenue?
• Which products had the highest net sales and units sold this week?
• Flag any week where revenue or ad spend moved outside its normal range.

Customers and channels

• How many of this week’s orders came from new customers versus returning customers?
• Which traffic source drove the most orders and revenue last week?
• Compare our Shopify order revenue to what we spent on Meta Ads and Google Ads this month.

Bonus: analyze e-commerce alongside your full stack

The same Windsor install covers every source I have connected, so one question can cross the store, the ad accounts and GA4. Three I use most:

• “Did the Google Merchant Center campaign we launched last month increase Shopify orders?”
• “Compare GA4 sessions to Shopify conversion rate by traffic source.”
• “Which ad campaign has the best cost per order?”

Conclusion

The cost-per-sale question now gets answered where I already work, with Shopify orders and ad spend matched by week, and the same pull does not need redoing the week after. The Shopify connector is the one to set up first. The ad accounts and GA4 add the cost and on-site sides to it.

Connectors mentioned in this guide

• Shopify
• Meta Ads
• Google Ads
• Google Merchant Center
• GA4
• Amazon Seller Central
• WooCommerce

🚀 Ready to get started? Try Windsor.ai free. Free forever plan, no credit card. Paid plans from $19/month.