Customer Success Financial Analyst

Turn subscription and usage data into the financial metrics that predict renewal risk and expansion opportunity.

AI Agents / Developmentai-agentsdevelopment
by AgentVoltv1.0.0Published 1y ago1 install
Free to sign up · every skill included with AgentVolt Pro

Before & after

Same prompt, same agent — the only difference is the skill.

PromptAnalyze our customer acquisition cost trends across this quarter and compare cohorts.
Beforegeneric AI agent
Customer acquisition cost tracking is essential for understanding unit economics. To analyze trends, you'd want to look at cohort data by acquisition month, segment by marketing channel, and see if CAC is trending up or down. I'd recommend breaking it down by customer segment too—your enterprise CAC might look very different from SMB. Do you have data on LTV alongside CAC? Knowing CAC payback period would be really insightful. What channels drove most of your acquisition this quarter?
Afterwith Customer Success Financial Analyst
CUSTOMER ACQUISITION COST ANALYSIS: Q3 2026

EXECUTIVE SUMMARY
→ Blended CAC: $485 (up 12% vs. Q2)
→ Best-performing cohort: June SMB (CAC $310)
→ Worst-performing cohort: August Enterprise (CAC $920)
→ Primary driver of increase: Paid advertising cost inflation (18% quarter over quarter)

COHORT BREAKDOWN BY MONTH

June Cohort:
→ Total customers acquired: 124
→ Total acquisition spend: $38,440
→ CAC: $310 (best performer)
→ Primary channel: Organic + Referral (68%)
→ LTV estimate: $8,100 (CAC payback: 2.9 months)

July Cohort:
→ Total customers acquired: 98
→ Total acquisition spend: $46,200
→ CAC: $471 (middle)
→ Primary channel: Paid search (52%) + paid social (35%)
→ LTV estimate: $7,200 (CAC payback: 4.2 months) WARNING

August Cohort:
→ Total customers acquired: 67 (lowest volume)
→ Total acquisition spend: $61,640
→ CAC: $920 (worst performer) CRITICAL
→ Primary channel: Paid social + LinkedIn (88%)
→ LTV estimate: $6,800 (CAC payback: 5.5 months) CRITICAL

CHANNEL PERFORMANCE
→ Organic: CAC $180, 35% of total volume
→ Referral: CAC $220, 18% of total volume
→ Paid search: CAC $580, 28% of total volume
→ Paid social: CAC $720, 19% of total volume

KEY FINDINGS
1. Organic + Referral cohorts have 65-75% lower CAC and superior retention
2. Paid channels showing declining efficiency (bids rising, conversion falling)
3. Enterprise segment consistently 2x+ CAC vs. SMB
4. August paid social scale hurting unit economics

RECOMMENDATIONS
→ IMMEDIATE: Reduce August paid social spend by 40%, pause high-cost keywords
→ STRATEGY: Invest 20% of freed budget into referral program (proven $220 CAC)
→ CONTENT: Scale organic with 3 new comparison content pieces (June cohort gold standard)
→ FORECAST: Q4 blended CAC should return to $420-450 range if actions implemented

FINANCIAL IMPACT
Current trajectory: $920 August CAC × expected 85 Q4 customers = $78,200 acquisition spend for Q4
With recommendations: $450 CAC × 95 customers = $42,750 (46% savings)

About this skill


name: cs-financial-analyst description: Use when Structured Claude skill that gives Claude a repeatable workflow for cs financial analyst.

Cs Financial Analyst

One of 337+ skills in the original author's multi-agent claude-skills mega-collection (~19k GitHub stars). Packages the Cs Financial Analyst workflow with its own instructions and validation so outputs stay consistent.

What you get

  • Public GitHub repo (alirezarezvani/claude-skills)
  • the cs-financial-analyst skill folder with SKILL.md. Part of a 337-skill / 30-agent / 70-command install.

Customize your output

  • Fork the repo and adapt the skill's instructions and references to your workflow.

Example output

Activates automatically when your request matches Cs Financial Analyst; chains with the other skills, agents, and commands in the collection.

Best for

Creators, builders, and teams using Claude Code.

SKILL.md preview

SKILL.md
---
name: cs-financial-analyst
description: Use this skill when analyzing customer success financial health, such as churn, expansion revenue, net or gross revenue retention, or cohort-based renewal risk.
version: 1.0.0
category: AI Agents / Development
author: AgentVolt
license: proprietary
tags:
  - ai-agents
  - development
---

# Cs Financial Analyst

Turns raw subscription and usage data into the financial metrics that predict renewal risk and expansion opportunity, tying customer health scores to real dollars instead of vibes.

## When to use

… (sign up to view the full skill)
Sign up to view, copy, and install the full skill

More ai & agents skills

View all AI & Agents skills →