AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

workload-analysis

Generate comprehensive workload analysis visualizations for PostHog customer accounts. Use when user requests account analysis, workload breakdown, SDK analysis, spend allocation, or expansion opportunity assessment. Triggers include "analyze [account]", "workload analysis for [account]", "SDK breakdown for [account]", "show me how [account] uses PostHog", or any request to understand customer usage patterns across products and platforms.

Original source
posthog
License
MIT
Pinned revision
cac7c80a9e5b73484d18eda1bffb47297c938e0c

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

This skill also requires local files or dependencies. Remote reading alone may not be enough.

Ask your assistant

Use Agentic Memory skills to read posthog--workload-analysis at revision cac7c80a9e5b73484d18eda1bffb47297c938e0c, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 5

references/opportunity-framework.md

Opportunity & Risk Framework

Opportunity Identification

Priority 1: Annual Contract Conversion

Trigger: stripe.subscriptionInterval === "month" AND MRR > $3,000

| Confidence | Value | Action | |------------|-------|--------| | 85-95% | MRR × 12 | Propose annual with 10-20% discount |

Talking points:

  • "Lock in current pricing"
  • "10-20% discount on annual commitment"
  • "Simplify budget planning"

Priority 2: Product Gaps (Enrolled but $0)

Trigger: Has *_plan but *_forecasted_mrr === 0

| Product | Typical MRR | Confidence | |---------|-------------|------------| | Surveys (enrolled) | $50-200 | 60% | | Error Tracking (enrolled) | $100-400 | 70% | | Feature Flags (enrolled) | $100-500 | 65% |

Action: "I see you have [product] enabled but haven't used it yet. Would you like help setting it up?"

Priority 3: Cross-sell by Profile

Web-Heavy (web > 80%)

| Missing Product | Opportunity | Confidence | |-----------------|-------------|------------| | Session Replay | $100-500 MRR | 80% | | Error Tracking (web) | $100-400 MRR | 75% | | Surveys | $50-200 MRR | 60% |

Mobile-Heavy (ios + android > 30% OR flutter > 20% OR react_native > 20%)

| Missing Product | Opportunity | Confidence | |-----------------|-------------|------------| | Mobile Replay | $200-4000 MRR | 85% | | Error Tracking (mobile) | $200-800 MRR | 80% |

Note: Flutter/React Native often have HIGHER event volumes than native - check these first!

Backend-Heavy (node/python > 80%)

| Missing Product | Opportunity | Confidence | |-----------------|-------------|------------| | Error Tracking (backend) | $100-500 MRR | 75% | | Feature Flags (local eval) | $200-800 MRR | 70% |

AI Company (ai_events > 0)

| Missing Product | Opportunity | Confidence | |-----------------|-------------|------------| | LLM Analytics expansion | $500-2000 MRR | 85% | | Surveys (AI feedback) | $100-300 MRR | 60% |

B2B Company (Company_Type__c === "private" AND employees > 20)

| Missing Product | Opportunity | Confidence | |-----------------|-------------|------------| | Group Analytics | $300-1000 MRR | 80% | | Teams addon ($450/mo) | $450 MRR | 75% |

Priority 4: Usage Expansion

Trigger: Usage at 80%+ of billing limit

| Metric | Action | |--------|--------| | Near recording limit | Propose limit increase | | Near FF request limit | Propose local evaluation | | Near DW limit | Propose limit increase |

Priority 5: Data Platform

Trigger: Using batch exports OR external schemas > 5

| Opportunity | Potential | Confidence | |-------------|-----------|------------| | Data Warehouse expansion | $200-1000 MRR | 65% | | Additional destinations | $100-500 MRR | 55% |

Risk Assessment

Severity: HIGH 🔴

1. Usage Declining

Trigger: forecasted_mrr < mrr (diff_dollars negative)

| Decline | Risk Level | Action | |---------|------------|--------| | >20% | Critical | Immediate outreach, investigate cause | | 10-20% | High | Schedule call within 1 week | | 5-10% | Medium | Monitor, send check-in email |

2. Monthly at High MRR

Trigger: Monthly billing AND MRR > $5,000

| Risk | Impact | |------|--------| | Churn exposure | Full ARR at risk any month | | No commitment | Easy to switch competitors |

Action: Priority annual conversion

3. Payment Issues

Trigger: stripe.delinquent === true OR accountBalance < -1000

Action: Immediate escalation to billing team

Severity: MEDIUM 🟡

4. Low Health Score

Trigger: healthScore < 6

| Score | Risk Level | |-------|------------| | 4-6 | Medium - investigate | | <4 | High - immediate action |

Action: Review engagement metrics, schedule check-in

5. No Recent Activity

Trigger: lastSeenTimestamp > 30 days ago

Action: Outreach to re-engage, check for implementation issues

6. Single Product Dependency

Trigger: One product > 50% of total MRR

| Risk | Mitigation | |------|------------| | If they stop that product, lose >50% | Cross-sell other products |

Severity: LOW 🟢

7. Support Ticket Volume

Trigger: supportTickets > 5 in 30 days

Action: Review tickets for patterns, offer proactive help

8. Single Point of Contact

Trigger: Only 1 admin user

| Risk | Action | |------|--------| | Champion leaves = relationship lost | Identify additional stakeholders |

Risk Score Calculation

function calculateRiskScore(account) {
  let score = 0;
  
  // Usage decline (0-40 points)
  if (account.diff_dollars < 0) {
    const declinePercent = Math.abs(account.diff_dollars / account.mrr);
    score += Math.min(declinePercent * 200, 40);
  }
  
  // Monthly billing (0-25 points)
  if (account.subscriptionInterval === 'month' && account.mrr > 3000) {
    score += 25;
  }
  
  // Health score (0-20 points)
  if (account.healthScore < 6) {
    score += (6 - account.healthScore) * 5;
  }
  
  // No activity (0-15 points)
  const daysSinceActive = daysSince(account.lastSeenTimestamp);
  if (daysSinceActive > 14) {
    score += Math.min(daysSinceActive - 14, 15);
  }
  
  return score; // 0-100, higher = more risk
}

Opportunity Value Calculation

function calculateOpportunityValue(opportunity) {
  const [minMrr, maxMrr] = opportunity.potentialMrr;
  const avgMrr = (minMrr + maxMrr) / 2;
  const confidence = opportunity.confidence / 100;
  
  return {
    expectedValue: avgMrr * confidence,
    annualizedValue: avgMrr * confidence * 12,
    priorityScore: avgMrr * confidence, // Higher = more urgent
  };
}

Confidence Guidelines

| Confidence | Meaning | |------------|---------| | 90-95% | Fixed pricing, clear trigger (e.g., annual conversion) | | 75-89% | Usage-based calculation, strong signal | | 60-74% | Profile match, moderate signal | | 40-59% | Speculative, early signal | | <40% | Long shot, worth mentioning |