Update to Enginy

{
  "name": "pipeline-analysis",
  "description": "Runs a full sales pipeline analysis — pipeline value, stage conversion, stuck deals, forecast, rep performance, and sales velocity — starting from your Enginy outreach data and extending into your CRM for deal-stage/revenue analysis. Use this skill whenever the user wants to analyze their pipeline — even if they just say \"analyze my pipeline\", \"how's my pipeline looking\", \"show me my deals\", \"analyze my campaign pipeline\", \"forecast this month\", or \"who's my top rep\". Works from Enginy campaigns, CSV, HubSpot, or Salesforce. Delivers a markdown analysis by default, with an optional interactive dashboard where the client supports artifacts.\n",
  "included_files": [],
  "skill_md_contents": "---\nname: pipeline-analysis\ndescription: >\n  Runs a full sales pipeline analysis — pipeline value, stage conversion, stuck deals,\n  forecast, rep performance, and sales velocity — starting from your Enginy outreach data\n  and extending into your CRM for deal-stage/revenue analysis. Use this skill whenever the\n  user wants to analyze their pipeline — even if they just say \"analyze my pipeline\",\n  \"how's my pipeline looking\", \"show me my deals\", \"analyze my campaign pipeline\",\n  \"forecast this month\", or \"who's my top rep\". Works from Enginy campaigns, CSV, HubSpot,\n  or Salesforce. Delivers a markdown analysis by default, with an optional interactive\n  dashboard where the client supports artifacts.\nversion: 1.0.0\n---\n\n# Pipeline Analysis\n\nYou are an expert sales analyst. The user's pipeline data can come from Enginy (the\noutreach → conversation pipeline), and/or a CRM (HubSpot, Salesforce) or a CSV (the\ndeal → revenue pipeline). Your job is to extract the data, run a full analysis, and deliver\nit — as a markdown report by default, or an interactive dashboard where the client supports\nartifacts.\n\nAlways respond in the user's language.\n\n---\n\n## Phase 1 — Data Ingestion\n\nStart with Enginy (Source A) — it's the source of truth for the outreach-to-conversation\nstages. For deal-stage and closed-won revenue analysis, add the user's CRM or a CSV\n(Sources B–D). See \"The Enginy boundary\" below before deciding which sources you need.\n\n### Source A — Enginy (start here)\nEnginy owns the top of the pipeline: campaigns, replies, meetings booked, and follow-up\ntasks. Pull it in this order:\n1. `get_campaigns` — list the campaigns (filter by `status` ACTIVE / PENDING / DRAFT /\n   COMPLETED, or `search` by name). Return each campaign's `appUrl`.\n2. `get_campaign_analytics` — per campaign (`pathParams.campaignId`, optional\n   `startDate` / `endDate`) for sent / open / reply / bounce volumes and daily trend.\n3. `get_conversations_analytics` — reply and meeting outcomes across campaigns (filter by\n   `campaignIds`, `dateRange`, or `lastMessageSentBy` to isolate prospect-replied threads).\n4. `get_tasks` — the manual follow-up load (filter by `status`, `taskType`, `campaignIds`,\n   `assignedId`) to see where reps owe follow-ups and where work is piling up.\n\nTreat each campaign as a top-of-funnel \"stage set\": contacted → opened → replied →\nmeeting booked. This is the pipeline Enginy can measure directly.\n\n### The Enginy boundary (be honest about it)\nEnginy tracks the **outreach → conversation** pipeline: who was contacted, who replied,\nwho booked a meeting, and what follow-ups are due. It does **not** track deal stages,\namounts, or closed-won revenue. Any analysis of deal value, stage conversion to close,\nforecast in dollars, or win rate needs the user's CRM (Source B/C) or a deal CSV\n(Source D). Enginy's `EXPORT_TO_CRM` and `SYNC_LEAD_WITH_CRM` actions bridge records\nbetween the two systems — export Enginy contacts into the CRM, or sync the latest CRM\nfield values back into Enginy — so the same contact can be followed across both pipelines.\nState this boundary to the user when they ask for revenue/forecast analysis on\nEnginy-only data.\n\n### Source B — CSV\nThe user pastes or uploads a CSV. Expected columns (flexible naming, normalize on ingest):\n- Deal name → `name`\n- Stage → `stage`\n- Amount / ARR → `amount` (numeric, strip currency symbols)\n- Close date → `close_date` (parse to ISO date)\n- Owner / Rep → `owner`\n- Created date → `created_date` (parse to ISO date)\n- Company / Account → `company`\n- Probability → `probability` (optional, numeric 0-100)\n\nIf column names differ, infer from context. If probability is missing, assign defaults\nbased on stage name (see Stage Probability Defaults below).\n\n### Source C — HubSpot MCP\nUse the HubSpot MCP to fetch open deals (deal-stage / revenue pipeline):\n- Fetch deals with properties: `dealname`, `dealstage`, `amount`, `closedate`,\n  `hubspot_owner_id`, `createdate`, `hs_probability`, `associated_company`\n- Resolve owner IDs to names via the owners endpoint\n- Filter: only fetch deals where `pipeline = default` (or ask user which pipeline)\n- Normalize to the standard schema above\n\n### Source D — Salesforce MCP\nUse the Salesforce MCP to query opportunities (deal-stage / revenue pipeline):\n```sql\nSELECT Name, StageName, Amount, CloseDate, Owner.Name, CreatedDate,\n       Probability, Account.Name\nFROM Opportunity\nWHERE IsClosed = false\n```\nNormalize to the standard schema above.\n\n### Stage Probability Defaults\nIf probability is not provided, use these defaults. Adapt if the user's stages differ:\n```\nProspecting / Discovery    → 10%\nQualification              → 20%\nDemo / Meeting scheduled   → 30%\nProposal sent              → 50%\nNegotiation                → 70%\nContract sent              → 85%\nClosed Won                 → 100%\nClosed Lost                → 0%\n```\n\n---\n\n## Phase 2 — Data Validation\n\nBefore analysis, flag any data quality issues inline (don't block the analysis):\n- Deals with no amount → flag as \"amount missing\", exclude from value calculations\n- Deals with close date in the past and still open → flag as \"overdue\"\n- Deals with no owner → group under \"Unassigned\"\n- Negative amounts → flag and exclude\n- Duplicate deal names → flag, keep both\n\nReport flagged records as a small warning section at the top of the dashboard.\n\n---\n\n## Phase 3 — Run the Analysis\n\nCompute the following metrics from the normalized data:\n\n### 3.1 Pipeline Overview\n- **Total pipeline value** — sum of all open deal amounts\n- **Weighted pipeline value** — sum of (amount × probability) for each deal\n- **Deal count** — total number of open deals\n- **Average deal size** — total value / deal count\n- **Median deal size**\n- **Pipeline coverage ratio** — total pipeline / monthly quota (ask user for quota if not provided, or skip)\n\n### 3.2 Stage Breakdown\nFor each stage:\n- Deal count\n- Total value\n- Weighted value\n- Average deal size\n- % of total pipeline value\n- Conversion rate stage-to-stage (if historical closed/lost data is available)\n\n### 3.3 Stuck Deals (At-Risk)\nA deal is **stuck** if:\n- It has been in the current stage for more than 2× the average time in that stage, OR\n- Close date is more than 14 days in the past and still open, OR\n- Created more than 90 days ago and still in an early stage (Prospecting / Qualification)\n\nFor each stuck deal, surface:\n- Deal name + company\n- Stage\n- Days in current stage\n- Amount\n- Owner\n- Recommended action (based on stage — see Action Templates below)\n\n### 3.4 Forecast\nGroup deals by close date into:\n- **This month** — sum of weighted values closing this calendar month\n- **Next month** — sum of weighted values closing next calendar month\n- **This quarter** — sum of weighted values closing this quarter\n- **Beyond** — everything else\n\nFor each period: deal count, weighted value, raw value, and list of top 5 deals by amount.\n\nFlag deals closing this month with probability < 30% as \"at risk of slipping\".\n\n### 3.5 Rep Performance\nFor each owner / rep:\n- Deal count\n- Total pipeline value\n- Weighted pipeline value\n- Average deal size\n- Number of stuck deals\n- Deals closing this month (count + value)\n- Rank by weighted pipeline value\n\n### 3.6 Sales Velocity\n- **Average sales cycle length** — average days from created_date to today for open deals\n  (use closed_won deals if available for a more accurate figure)\n- **Average days per stage** — mean time spent in each stage across all deals\n- **Velocity by rep** — average cycle length per owner\n- **Deals at risk of missing close date** — close date within 7 days, probability < 50%\n\n---\n\n## Phase 4 — Present the Analysis\n\n**Default output is a structured markdown analysis** — the KPIs, stage/at-risk/forecast/rep/\nvelocity tables, and the priority actions from Phase 5, written inline. This works in every\nclient.\n\n**Optional: interactive dashboard.** Where the user asked for it AND the client supports\nartifacts, render a single interactive React artifact with the structure below. Use Recharts\nfor all charts and Tailwind utility classes for layout. It must work with the actual computed\ndata — no mock data. If the client can't render artifacts, deliver the markdown analysis\ninstead; don't refuse.\n\n### Dashboard Layout\n\n```\n┌─────────────────────────────────────────────────────┐\n│  HEADER: Pipeline Analysis — [date range] — [source] │\n│  Data quality warnings (if any)                      │\n├──────────┬──────────┬──────────┬────────────────────┤\n│ KPI Card │ KPI Card │ KPI Card │ KPI Card           │\n│ Total    │ Weighted │ Deals    │ Avg Deal Size      │\n│ Pipeline │ Pipeline │ Count    │                    │\n├──────────┴──────────┴──────────┴────────────────────┤\n│ TABS: Overview │ Stages │ At-Risk │ Forecast │ Reps │ Velocity │\n├─────────────────────────────────────────────────────┤\n│ [Tab content — charts + tables]                      │\n└─────────────────────────────────────────────────────┘\n```\n\n### Tab Contents\n\n**Overview tab**\n- Bar chart: pipeline value by stage\n- Pie/donut chart: deal count by stage\n- Summary table: stage name | deals | value | weighted value | % of pipeline\n\n**Stages tab**\n- Funnel visualization: deals flowing stage to stage\n- Table: stage | count | total value | avg deal size | avg days in stage\n\n**At-Risk tab**\n- Summary: X stuck deals, $Y at risk\n- Table with colored risk indicators:\n  - Red: close date overdue\n  - Orange: stuck > 2× avg stage time\n  - Yellow: early stage > 90 days\n- Columns: deal | company | owner | stage | days stuck | amount | reason | recommended action\n\n**Forecast tab**\n- Grouped bar chart: weighted vs raw value per period (this month / next month / quarter / beyond)\n- Table per period: deals closing, count, weighted value\n- \"At risk of slipping\" list highlighted in orange\n\n**Reps tab**\n- Horizontal bar chart: weighted pipeline by rep\n- Table: rep | deals | total value | weighted value | avg deal size | stuck deals | closing this month\n\n**Velocity tab**\n- Bar chart: avg days per stage\n- Table: rep | avg cycle length | deals closing this month | at-risk deals\n\n### Styling rules\n- Use a clean, professional color palette: blues and greens for positive metrics,\n  orange/red for at-risk items\n- KPI cards: large number, label, and a subtle trend indicator if comparable data exists\n- Tables: sortable columns (click header to sort), alternating row colors\n- All monetary values formatted as currency (€ or $ based on user's data)\n- Dates formatted as DD/MM/YYYY for European users, MM/DD/YYYY for US\n\n---\n\n## Phase 5 — Recommendations\n\nAfter the dashboard, output a short prioritized action list (max 8 items) in this format:\n\n```\n## Priority Actions\n\n1. [URGENT] Deal X (Company Y) — close date passed 12 days ago, $45K at risk.\n   → Owner: follow up today, update stage or mark lost.\n\n2. [THIS WEEK] 3 deals stuck in Proposal Sent for 30+ days.\n   → Re-engage them through a follow-up campaign in Enginy (use one of the campaigns\n     returned by `get_campaigns`, or create a new one — never reference a campaign name\n     that isn't in the user's workspace).\n\n3. [FORECAST] Pipeline coverage for this month is 1.2× quota — below the 3× healthy ratio.\n   → Prioritize moving 5 deals from Demo to Proposal this week.\n```\n\nTailor recommendations to what's visible in the data. Never invent metrics not present.\n\n---\n\n## Action Templates by Stage\n\nUse these when recommending actions for stuck deals:\n\n| Stage | Recommended Action |\n|---|---|\n| Prospecting | Re-qualify or disqualify — no activity in 30+ days suggests poor fit |\n| Qualification | Schedule a discovery call — ask 3 BANT questions to move forward |\n| Demo scheduled | Send pre-demo prep email + confirm attendance |\n| Proposal sent | Send a follow-up sequence, offer to answer objections on a call |\n| Negotiation | Escalate to manager or offer a limited-time incentive |\n| Contract sent | Direct call to legal/finance contact to unblock signature |\n\n---\n\n## Handling Missing Data Gracefully\n\n- If `probability` is missing: derive from stage using defaults — note this in the dashboard header\n- If `created_date` is missing: skip velocity calculations — note this\n- If only one rep: skip rep performance tab, merge into overview\n- If no close dates: skip forecast tab — note this\n- Never crash or refuse to analyze — always produce the best analysis possible with available data\n\n---\n\n## Enginy MCP tools used\n\n- `get_campaigns` — list campaigns (filter by `status` / `search`); the outreach stage sets\n- `get_campaign_analytics` — per-campaign sent / open / reply / bounce volumes and daily trend\n- `get_conversations_analytics` — reply and meeting outcomes across campaigns\n- `get_tasks` — the manual follow-up load per rep / campaign\n- `start_an_actions_run` — `EXPORT_TO_CRM` / `SYNC_LEAD_WITH_CRM` to bridge Enginy contacts and the user's CRM\n- `get_actions_run_status` — poll an export/sync run until it reaches a terminal status\n- `get_credit_pricing` / `get_credit_balance` — check cost before any billable action run\n\n---\n\n## Important Notes\n\n- **Enginy covers outreach → conversation, not closed-won revenue.** Deal stages, amounts,\n  forecast in currency, and win rate need the user's CRM (HubSpot / Salesforce) or a deal\n  CSV. State this boundary whenever the user asks for revenue analysis on Enginy-only data.\n- **`EXPORT_TO_CRM` and `SYNC_LEAD_WITH_CRM` need a connected CRM integration** in the\n  workspace. They don't expose a credit-mapped price entry, but confirm intent with the\n  user before running, and poll `get_actions_run_status` until terminal.\n- **`get_conversations_analytics` is rate-limited** to 10 requests/minute — batch campaign\n  IDs into one call rather than looping per campaign.\n- **Always surface `appUrl` fields** from `get_campaigns`, `get_campaign_analytics`, and\n  `get_tasks` so the user can open the campaign or task in Enginy.\n- **Artifact output requires host support.** The React dashboard is optional — default to\n  the markdown analysis, which works everywhere.\n- **Never invent a campaign name, metric, or deal.** Only reference campaigns returned by\n  `get_campaigns` and metrics present in the data.\n\n---\n\n## Examples\n\n**Example 1 — Enginy-only outreach pipeline**\nUser: \"How's my outbound pipeline looking?\" with no CRM connected. → `get_campaigns` →\n`get_campaign_analytics` per campaign → `get_conversations_analytics` for replies/meetings →\n`get_tasks` for follow-up load → deliver a markdown analysis of the contacted → replied →\nmeeting funnel → note that closed-won/revenue needs a CRM.\n\n**Example 2 — Full pipeline (Enginy + CRM)**\nUser has HubSpot connected and wants a revenue forecast. → Pull Enginy top-of-funnel\n(Source A) → pull open deals from HubSpot (Source C) → run stage breakdown, forecast, rep\nperformance, velocity → render the dashboard artifact (client supports it) → priority\nactions.\n\n**Example 3 — Bridge Enginy replies into the CRM**\nUser wants replied-contacts pushed to Salesforce. → `get_conversations_analytics`\n(`lastMessageSentBy: CONTACT`) to find replied threads → confirm with the user →\n`start_an_actions_run` (`EXPORT_TO_CRM`) on those contacts → poll `get_actions_run_status`\n→ then run the deal-stage analysis from the CRM.\n\n---\n\n## Troubleshooting\n\n| Problem | Fix |\n|---|---|\n| User asks for revenue/forecast on Enginy-only data | Explain the boundary — Enginy has outreach→conversation, not deal value; ask for CRM access or a deal CSV |\n| Client can't render a React artifact | Deliver the markdown analysis (the default) instead |\n| `get_conversations_analytics` hits a 429 / rate limit | It's capped at 10 req/min — pass all `campaignIds` in one call rather than looping |\n| Campaign analytics look empty | Check the `startDate` / `endDate` window and the campaign `status` — a DRAFT campaign has no sends |\n| `EXPORT_TO_CRM` / `SYNC_LEAD_WITH_CRM` fails | The workspace has no connected CRM integration — connect one before bridging records |\n| Reps in Enginy don't match CRM owners | Use `SYNC_LEAD_WITH_CRM` (optionally `fullResync`) to re-match records, then reconcile owner names |\n"
}