windsor-ai

What This Skill Does

The Windsor.ai skill serves as a high-performance bridge between OpenClaw and the Windsor.ai MCP (Model Context Protocol) server. It acts as a unified analytical engine, providing natural language access to over 325 integrated data platforms including Facebook Ads, Google Analytics 4, HubSpot, Shopify, and Salesforce. By leveraging this skill, you can bypass complex dashboarding tools and directly query your marketing, CRM, and e-commerce data using conversational English. The skill performs real-time data aggregation, transforming raw metrics into actionable insights without requiring you to manually export or clean datasets from disparate sources.

Installation

Installation is a multi-step process ensuring secure API handling. First, install the skill via the OpenClaw command line using clawhub install openclaw/skills/skills/carlosarturoleon/windsor-ai. Once installed, you must acquire an API key from the Windsor.ai dashboard. Secure this key by adding WINDSOR_API_KEY=your_key to your ~/.clawdbot/.env file. Finally, register the connection by updating your config/mcporter.json file to include the windsor-ai server configuration, ensuring the Authorization header is correctly mapped to your exported environment variable. Verify the setup by running npx mcporter list to confirm the tools are active.

Use Cases

This skill is ideal for marketing managers, data analysts, and business owners who need immediate answers regarding ROAS, CPM, or lead conversion rates. You can utilize it for cross-channel attribution to determine which platforms drive the highest revenue or to track e-commerce performance metrics like AOV (Average Order Value) and customer acquisition costs. It is especially useful for trend analysis, such as comparing Q3 versus Q4 ad spend performance, or for merging disparate CRM data with advertising metrics to gain a holistic view of the customer journey.

Example Prompts

• "What was our total ROAS across all Facebook and TikTok campaigns last month?"
• "Compare the conversion rates between our Shopify store and HubSpot leads for the last 30 days."
• "Show me a breakdown of ad spend by channel for this quarter and highlight the highest performing campaign."

Tips & Limitations

To maximize the utility of this skill, ensure your data sources are properly connected within your Windsor.ai dashboard before querying. Because this skill relies on the underlying MCP server, performance may be affected by the volume of historical data requested. For complex analysis, define specific date ranges to prevent timeouts. Remember that this tool is designed for analytical querying and data retrieval; it does not support automated changes or modifications to your underlying advertising accounts or CRM configurations, ensuring your data remains secure.