An intelligent ecommerce analysis tool that transforms raw data notes and KPI exports into structured operator-ready briefs and prioritized action plans.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install commerce-bi-copilot
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install commerce-bi-copilot using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Commerce BI Copilot?
The Commerce BI Copilot is a specialized tool within the Openclaw Skills ecosystem designed for founders, operators, and analysts who need immediate insights without the overhead of live SQL connectors. It functions as a heuristic layer that applies a commerce-specific metric dictionary and anomaly checklist to your provided business notes. By synthesizing fragmented data from sources like Shopify, Amazon, and Meta Ads, it helps teams understand the 'why' behind their performance metrics.
This skill is particularly valuable for teams that rely on manual exports or rough KPI snapshots. It bridges the gap between raw numbers and strategic execution, ensuring that metric alignment on critical figures like GMV, ROAS, and refund rates remains consistent across the organization. Using this skill ensures your business reviews are backed by structured analysis rather than just anecdotal observations.
Commerce BI Copilot Use Cases
- Explaining sudden fluctuations in performance, such as a drop in weekly GMV or a spike in ROAS.
- Preparing comprehensive weekly, monthly, or executive business reviews from fragmented data notes.
- Aligning cross-functional teams on complex metric definitions and attribution models.
- Converting rough exports from Shopify, Meta, or Google Ads into a concise executive summary.
- Generating targeted follow-up questions for analysts or external agencies based on current trends.
How Commerce BI Copilot Works
- The user provides a business question, specific time frame, and relevant data notes or channel context.
- The skill normalizes the likely metric set and identifies any potential definition ambiguities.
- It constructs a driver tree focusing on traffic, conversion, pricing, refunds, and channel mix.
- Prioritized drill-downs and next best actions are generated based on identified anomalies.
- A final markdown-formatted brief is returned, ready for immediate use by founders or operators.
Commerce BI Copilot Setup
To utilize this capability, ensure you have an agent environment configured to run Openclaw Skills. There is no requirement for live database credentials or API keys. Simply include the skill in your agent context and provide raw KPI data through prompts.
# Example of initiating an analysis session
openclaw run commerce-bi-copilot --input "weekly_notes.txt"
Commerce BI Copilot Data Schema & Taxonomy
The skill organizes input and output data based on a commerce-first taxonomy to ensure consistency across the Openclaw Skills framework.
| Data Component | Description | Example Metrics |
|---|---|---|
| Core KPIs | High-level performance indicators | GMV, Net Revenue, Orders |
| Efficiency Metrics | Return on investment and spend health | ROAS, MER, CAC |
| Operations | Logistics and post-purchase health | Refund Rate, Inventory Health |
| Mix Analysis | Channel and product distribution | Brand vs Generic, Product Mix |
Commerce BI Copilot Advanced Features
- Multi-channel synthesis that harmonizes data from Shopify, Meta, Amazon, and GA4.
- Automated driver tree generation to map the relationship between traffic, CVR, and AOV.
- Executive-ready summary formatting specifically designed for founder and stakeholder updates.
- Built-in anomaly detection framework to flag unusual shifts in refund rates or channel contribution.
- Heuristic diagnostic engine that suggests next steps without requiring live ERP or ad API access.
SKILL.md
Loading
Related Openclaw Skills
Algorithm Mentor
A Socratic teaching agent that guides developers through algorithm challenges without giving away answers immediately.
Chain Reason
Chain Reason is an explicit reasoning trace skill that provides auditable, multi-step logical workflows for complex decision-making and problem-solving.
Support Flow Builder
A documentation-first tool to convert support policies and ticket patterns into structured service workflows and agent playbooks.
Repository Architecture Visualizer
Automatically transform any local code repository into an interactive, hierarchical architecture visualization rendered as a portable HTML page.
Museum Pass & Exhibition Booking Skill
A specialized agent skill for discovering and booking museum entries, art gallery tours, and exhibition tickets worldwide through the flyai CLI.
Pack-List: Intelligent Travel Packing & Gear Planner
A travel-focused execution skill that generates dynamic packing lists and manages trip essentials through real-time CLI integration.
Featured*
