# Send Ironclaw Pipeline Analytics to your agent Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually. ## Fast path - 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. ## Suggested prompts ### New install ```text 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 ```text 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. ``` ## Machine-readable fields ```json { "schemaVersion": "1.0", "item": { "slug": "ironclaw-pipeline-analytics", "name": "Ironclaw Pipeline Analytics", "source": "tencent", "type": "skill", "category": "数据分析", "sourceUrl": "https://clawhub.ai/aspenas/ironclaw-pipeline-analytics", "canonicalUrl": "https://clawhub.ai/aspenas/ironclaw-pipeline-analytics", "targetPlatform": "OpenClaw" }, "install": { "downloadUrl": "/downloads/ironclaw-pipeline-analytics", "sourceDownloadUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=ironclaw-pipeline-analytics", "sourcePlatform": "tencent", "targetPlatform": "OpenClaw", "packageFormat": "ZIP package", "primaryDoc": "SKILL.md", "includedAssets": [ "SKILL.md" ], "downloadMode": "redirect", "sourceHealth": { "source": "tencent", "status": "healthy", "reason": "direct_download_ok", "recommendedAction": "download", "checkedAt": "2026-04-23T16:43:11.935Z", "expiresAt": "2026-04-30T16:43:11.935Z", "httpStatus": 200, "finalUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=4claw-imageboard", "contentType": "application/zip", "probeMethod": "head", "details": { "probeUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=4claw-imageboard", "contentDisposition": "attachment; filename=\"4claw-imageboard-1.0.1.zip\"", "redirectLocation": null, "bodySnippet": null }, "scope": "source", "summary": "Source download looks usable.", "detail": "Yavira can redirect you to the upstream package for this source.", "primaryActionLabel": "Download for OpenClaw", "primaryActionHref": "/downloads/ironclaw-pipeline-analytics" }, "validation": { "installChecklist": [ "Use the Yavira download entry.", "Review SKILL.md after the package is downloaded.", "Confirm the extracted package contains the expected setup assets." ], "postInstallChecks": [ "Confirm the extracted package includes the expected docs or setup files.", "Validate the skill or prompts are available in your target agent workspace.", "Capture any manual follow-up steps the agent could not complete." ] } }, "links": { "detailUrl": "https://openagent3.xyz/skills/ironclaw-pipeline-analytics", "downloadUrl": "https://openagent3.xyz/downloads/ironclaw-pipeline-analytics", "agentUrl": "https://openagent3.xyz/skills/ironclaw-pipeline-analytics/agent", "manifestUrl": "https://openagent3.xyz/skills/ironclaw-pipeline-analytics/agent.json", "briefUrl": "https://openagent3.xyz/skills/ironclaw-pipeline-analytics/agent.md" } } ``` ## 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." } } ## Trust - Source: tencent - Verification: Indexed source record - Publisher: aspenas - Version: 1.0.0 ## Source health - Status: healthy - Source download looks usable. - Yavira can redirect you to the upstream package for this source. - Health scope: source - Reason: direct_download_ok - Checked at: 2026-04-23T16:43:11.935Z - Expires at: 2026-04-30T16:43:11.935Z - Recommended action: Download for OpenClaw ## Links - [Detail page](https://openagent3.xyz/skills/ironclaw-pipeline-analytics) - [Send to Agent page](https://openagent3.xyz/skills/ironclaw-pipeline-analytics/agent) - [JSON manifest](https://openagent3.xyz/skills/ironclaw-pipeline-analytics/agent.json) - [Markdown brief](https://openagent3.xyz/skills/ironclaw-pipeline-analytics/agent.md) - [Download page](https://openagent3.xyz/downloads/ironclaw-pipeline-analytics)