Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Tencent SkillHub · Data Analysis
Ironclaw Pipeline Analytics
Generate interactive analytics dashboards from CRM data. Use when asked to "show pipeline stats", "create a report", "analyze leads", "show conversion rates"...
skill openclawclawhub Free
Generate interactive analytics dashboards from CRM data. Use when asked to "show pipeline stats", "create a report", "analyze leads", "show conversion rates"...
⬇ 0 downloads ★ 0 stars Unverified but indexed
Install for OpenClaw
Quick setup
- Download the package from Yavira.
- Extract the archive and review SKILL.md first.
- Import or place the package into your OpenClaw setup.
Package facts
- Download mode
- Yavira redirect
- Package format
- ZIP package
- Source platform
- Tencent SkillHub
- What's included
- SKILL.md
Validation
- Use the Yavira download entry.
- Review SKILL.md after the package is downloaded.
- Confirm the extracted package contains the expected setup assets.
Install with your agent
Agent handoff
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
New install
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
Upgrade existing
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Trust & source
Release facts
- Source
- Tencent SkillHub
- Verification
- Indexed source record
- Version
- 1.0.0
Provenance
- Publisher
- aspenas
- Source page
- View original listing
- Canonical URL
- Open canonical page
Documentation
Pipeline Analytics — NL → SQL → Interactive Charts
Transform natural language questions into DuckDB queries and render results as interactive Recharts dashboards inline in chat.
Workflow
User asks question in plain English → Translate to DuckDB SQL against workspace pivot views (v_*) → Execute query → Format results as report-json → Render as interactive Recharts components
Discovery — What objects exist?
-- List all objects and their entry counts SELECT o.name, o.display_name, COUNT(e.id) as entries FROM objects o LEFT JOIN entries e ON e.object_id = o.id GROUP BY o.name, o.display_name ORDER BY entries DESC; -- List fields for an object SELECT f.name, f.field_type, f.display_name FROM fields f JOIN objects o ON f.object_id = o.id WHERE o.name = 'leads' ORDER BY f.position; -- Available pivot views SELECT table_name FROM information_schema.tables WHERE table_name LIKE 'v_%';
Common Analytics Queries
Pipeline Funnel SELECT "Status", COUNT(*) as count FROM v_leads GROUP BY "Status" ORDER BY CASE "Status" WHEN 'New' THEN 1 WHEN 'Contacted' THEN 2 WHEN 'Qualified' THEN 3 WHEN 'Demo Scheduled' THEN 4 WHEN 'Proposal' THEN 5 WHEN 'Closed Won' THEN 6 WHEN 'Closed Lost' THEN 7 ELSE 99 END; Outreach Activity Over Time SELECT DATE_TRUNC('week', "Last Outreach"::DATE) as week, "Outreach Channel", COUNT(*) as messages_sent FROM v_leads WHERE "Last Outreach" IS NOT NULL GROUP BY week, "Outreach Channel" ORDER BY week; Conversion Rates by Source SELECT "Source", COUNT(*) as total, COUNT(*) FILTER (WHERE "Status" = 'Qualified') as qualified, COUNT(*) FILTER (WHERE "Status" IN ('Closed Won', 'Converted')) as converted, ROUND(100.0 * COUNT(*) FILTER (WHERE "Status" = 'Qualified') / COUNT(*), 1) as qual_rate, ROUND(100.0 * COUNT(*) FILTER (WHERE "Status" IN ('Closed Won', 'Converted')) / COUNT(*), 1) as conv_rate FROM v_leads GROUP BY "Source" ORDER BY total DESC; Reply Rate Analysis SELECT "Outreach Channel", COUNT(*) as sent, COUNT(*) FILTER (WHERE "Reply Received" = true) as replied, ROUND(100.0 * COUNT(*) FILTER (WHERE "Reply Received" = true) / COUNT(*), 1) as reply_rate FROM v_leads WHERE "Outreach Status" IS NOT NULL GROUP BY "Outreach Channel"; Time-to-Convert SELECT "Source", AVG(DATEDIFF('day', created_at, "Converted At"::DATE)) as avg_days_to_convert, MEDIAN(DATEDIFF('day', created_at, "Converted At"::DATE)) as median_days FROM v_leads WHERE "Status" = 'Converted' AND "Converted At" IS NOT NULL GROUP BY "Source";
Report-JSON Format
Generate Recharts-compatible report cards: { "type": "report", "title": "Pipeline Analytics — February 2026", "generated_at": "2026-02-17T14:30:00Z", "panels": [ { "title": "Pipeline Funnel", "type": "funnel", "data": [ {"name": "New Leads", "value": 200}, {"name": "Contacted", "value": 145}, {"name": "Qualified", "value": 67}, {"name": "Demo Scheduled", "value": 31}, {"name": "Closed Won", "value": 13} ] }, { "title": "Outreach Activity", "type": "area", "xKey": "week", "series": [ {"key": "linkedin", "name": "LinkedIn", "color": "#0A66C2"}, {"key": "email", "name": "Email", "color": "#EA4335"} ], "data": [ {"week": "Feb 3", "linkedin": 25, "email": 40}, {"week": "Feb 10", "linkedin": 30, "email": 35} ] }, { "title": "Lead Source Breakdown", "type": "donut", "data": [ {"name": "LinkedIn Scrape", "value": 95, "color": "#0A66C2"}, {"name": "YC Directory", "value": 45, "color": "#FF6600"}, {"name": "Referral", "value": 30, "color": "#10B981"}, {"name": "Inbound", "value": 20, "color": "#8B5CF6"} ] }, { "title": "Reply Rates by Channel", "type": "bar", "xKey": "channel", "series": [{"key": "rate", "name": "Reply Rate %", "color": "#3B82F6"}], "data": [ {"channel": "LinkedIn", "rate": 32}, {"channel": "Email", "rate": 18}, {"channel": "Multi-Channel", "rate": 41} ] } ] }
Chart Types Available
TypeUse CaseRecharts ComponentbarComparisons, categoriesBarChartlineTrends over timeLineChartareaVolume over timeAreaChartpieDistribution (single level)PieChartdonutDistribution (with center metric)PieChart (innerRadius)funnelStage progressionFunnelChartscatterCorrelation (2 variables)ScatterChartradarMulti-dimension comparisonRadarChart
1. Pipeline Overview
Funnel: Lead → Contacted → Qualified → Demo → Closed Donut: Lead source breakdown Number cards: Total leads, conversion rate, avg deal size
2. Outreach Performance
Area: Messages sent over time (by channel) Bar: Reply rates by channel Line: Conversion trend week-over-week Number cards: Total sent, reply rate, meetings booked
3. Rep Performance (if multi-user)
Bar: Leads contacted per rep Bar: Reply rate per rep Bar: Conversions per rep Scatter: Activity volume vs. conversion rate
4. Cohort Analysis
Heatmap-style: Conversion rate by signup week × time elapsed Line: Retention/engagement curves by cohort
Natural Language Mapping
User SaysSQL PatternChart Type"show me pipeline"GROUP BY Statusfunnel"outreach stats"COUNT by channel + statusbar + area"how are we converting"conversion ratesfunnel + line"compare sources"GROUP BY Sourcebar"weekly trend"DATE_TRUNC + GROUP BYline / area"who replied"FILTER Reply Receivedtable"best performing"ORDER BY conversion DESCbar"lead breakdown"GROUP BY any dimensionpie / donut
Saving Reports
Reports can be saved as .report.json files in the workspace: ~/.openclaw/workspace/reports/ pipeline-overview.report.json weekly-outreach.report.json monthly-review.report.json These render as live dashboards in the Ironclaw web UI when opened.
Cron Integration
Auto-generate weekly/monthly reports: { "name": "Weekly Pipeline Report", "schedule": { "kind": "cron", "expr": "0 9 * * MON", "tz": "America/Denver" }, "payload": { "kind": "agentTurn", "message": "Generate weekly pipeline analytics report. Query DuckDB for this week's data. Create report-json with: funnel, outreach activity (area), reply rates (bar), source breakdown (donut). Save to workspace/reports/ and announce summary." } }
Category context
Data access, storage, extraction, analysis, reporting, and insight generation.
Source: Tencent SkillHub
Largest current source with strong distribution and engagement signals.
Package contents
Included in package
1 Docs
- SKILL.md