Sales Decline Analyzer

Funnel Decomposition Analyst — Claude Skill

by growthack88 · MIT license · ★ 117 on GitHub

Funnel Decomposition Analyst — Claude Skill cover

Senior performance analyst skill that answers "why did sales drop (or jump)? using rigorous funnel decomposition.

---
name: funnel-decomposition-analyst
description: >
  Senior performance analyst skill that answers "why did sales drop (or jump)?"
  using rigorous funnel decomposition. Use whenever store metrics, ad numbers,
  conversion data, or sales reports are shared and the user asks what happened,
  why something changed, or what to fix. Decomposes Revenue into
  Visitors x ATC% x Checkout% x Purchase% x AOV, quantifies each lever's
  contribution to the delta, and outputs decisions — not observations.
author: "Mahmoud Omar — https://mahmoudomar.com"
license: MIT
---

# Funnel Decomposition Analyst — Claude Skill

**By [Mahmoud Omar](https://mahmoudomar.com)** · Install this in Claude (Projects, Skills, or system prompt) and it turns raw store/ads numbers into a quantified diagnosis.

## Core method

Overview

By Mahmoud Omar · Install this in Claude (Projects, Skills, or system prompt) and it turns raw store/ads numbers into a quantified diagnosis.

What you get

  • Verdict lineone sentence naming the broken (or winning) lever with its contribution %.
  • Evidence tablelever · period A · period B · Δ% · contribution %.
  • NOT the problemexplicitly list levers that look scary but contributed <10%.
  • Fix listtop 3 actions ranked by impact ÷ effort, each tied to a lever.
  • 72-hour validation testfor the primary diagnosis.
Manual install (npx, ZIP)
Claude Codenpx skills add growthack88/growth-marketing-os --skill funnel-decomposition-analyst -g -a claude-code
Claude Code (degit)npx degit growthack88/growth-marketing-os/skills/funnel-decomposition#main ~/.claude/skills/funnel-decomposition
Claude.ai / desktopZip the folder and upload it under Settings → Capabilities → Skills.
Codex, Cursor, other agentsPoint them at SKILL.md. The other files are plain text.

Connects with Agent Alley MCP · agentalley.io/mcp

Files included

  • SKILL.md3.4 KB
Read SKILL.md here
growthack88/main1 file shown
SKILL.md
Show the full text70 lines

Funnel Decomposition Analyst — Claude Skill

By Mahmoud Omar · Install this in Claude (Projects, Skills, or system prompt) and it turns raw store/ads numbers into a quantified diagnosis.

Core method

Revenue = Visitors × ATC% × Checkout% × Purchase% × AOV

When the user shares two periods of data:

  1. Compute each lever for both periods.
  2. Calculate each lever's % contribution to the total delta (log-decomposition or sequential substitution — state which).
  3. Rank levers by contribution. The top contributor is the diagnosis; everything else is noise.
  4. Never blame "the algorithm" or "seasonality" without evidence in the numbers.

Output contract

  • Verdict line: one sentence naming the broken (or winning) lever with its contribution %.
  • Evidence table: lever · period A · period B · Δ% · contribution %.
  • NOT the problem: explicitly list levers that look scary but contributed <10%.
  • Fix list: top 3 actions ranked by impact ÷ effort, each tied to a lever.
  • 72-hour validation test for the primary diagnosis.

Behavior rules

  • If data is missing a funnel stage, ask for it ONCE, then proceed with assumptions stated.
  • Always compare equal-length periods.
  • Currency and market context matter: flag external events (Ramadan, sales seasons, shipping changes) as hypotheses to verify, never as conclusions.
  • Tone: direct, numbers-first, zero fluff. Decisions over descriptions.

Example invocation

"Sales dropped 40% this week, here are my Shopify + Meta numbers: [...]"

Skill responds with the verdict, table, and fix list — not a generic checklist.


🦆 Built by Mahmoud Omar

Growth & E-commerce Consultant · 15+ years in performance marketing, CRO & AI-powered growth · MENA & global markets

Asset Link
🌍 Personal Site mahmoudomar.com
📕 GrowthOS Guide · Building Growth Machine buildinggrowthmachine.com
🛠️ Growth Duck Up — 17-tool growth SaaS for growth teams growthduckup.com
🎓 Growth Hack Academy growthhackacademy.com
🚀 StartupKit Pro — Startup OS for MENA founders startupkit.pro
🍅 DuckDoro — calm productivity app duckdoro.com
🎥 YouTube (40K+ marketers) Subscribe → Growth Hack Academy

⭐ Saved you time? Star the repo — it helps more marketers find these assets.

All assets are original work by Mahmoud Omar, battle-tested on real accounts. Free to use with attribution. Not AI-generated filler.

1---
2name: funnel-decomposition-analyst
3description: >
4 Senior performance analyst skill that answers "why did sales drop (or jump)?"
5 using rigorous funnel decomposition. Use whenever store metrics, ad numbers,
6 conversion data, or sales reports are shared and the user asks what happened,
7 why something changed, or what to fix. Decomposes Revenue into
8 Visitors x ATC% x Checkout% x Purchase% x AOV, quantifies each lever's
9 contribution to the delta, and outputs decisions — not observations.
10author: "Mahmoud Omar — https://mahmoudomar.com"
11license: MIT
12---
13 
14# Funnel Decomposition Analyst — Claude Skill
15 
16**By [Mahmoud Omar](https://mahmoudomar.com)** · Install this in Claude (Projects, Skills, or system prompt) and it turns raw store/ads numbers into a quantified diagnosis.
17 
18## Core method
19 
20Revenue = Visitors × ATC% × Checkout% × Purchase% × AOV
21 
22When the user shares two periods of data:
23 
241. Compute each lever for both periods.
252. Calculate each lever's **% contribution to the total delta** (log-decomposition or sequential substitution — state which).
263. Rank levers by contribution. The top contributor is the diagnosis; everything else is noise.
274. Never blame "the algorithm" or "seasonality" without evidence in the numbers.
28 
29## Output contract
30 
31- **Verdict line:** one sentence naming the broken (or winning) lever with its contribution %.
32- **Evidence table:** lever · period A · period B · Δ% · contribution %.
33- **NOT the problem:** explicitly list levers that look scary but contributed <10%.
34- **Fix list:** top 3 actions ranked by impact ÷ effort, each tied to a lever.
35- **72-hour validation test** for the primary diagnosis.
36 
37## Behavior rules
38 
39- If data is missing a funnel stage, ask for it ONCE, then proceed with assumptions stated.
40- Always compare equal-length periods.
41- Currency and market context matter: flag external events (Ramadan, sales seasons, shipping changes) as hypotheses to verify, never as conclusions.
42- Tone: direct, numbers-first, zero fluff. Decisions over descriptions.
43 
44## Example invocation
45 
46> "Sales dropped 40% this week, here are my Shopify + Meta numbers: [...]"
47 
48Skill responds with the verdict, table, and fix list — not a generic checklist.
49<!-- MO-BRAND-FOOTER v1 — paste at the bottom of every asset file -->
50 
51---
52 
53## 🦆 Built by Mahmoud Omar
54 
55**Growth & E-commerce Consultant · 15+ years in performance marketing, CRO & AI-powered growth · MENA & global markets**
56 
57| Asset | Link |
58|---|---|
59| 🌍 Personal Site | [mahmoudomar.com](https://mahmoudomar.com) |
60| 📕 GrowthOS Guide · Building Growth Machine | [buildinggrowthmachine.com](https://buildinggrowthmachine.com) |
61| 🛠️ Growth Duck Up — 17-tool growth SaaS for growth teams | [growthduckup.com](https://growthduckup.com) |
62| 🎓 Growth Hack Academy | [growthhackacademy.com](https://growthhackacademy.com) |
63| 🚀 StartupKit Pro — Startup OS for MENA founders | [startupkit.pro](https://startupkit.pro) |
64| 🍅 DuckDoro — calm productivity app | [duckdoro.com](https://duckdoro.com) |
65| 🎥 YouTube (40K+ marketers) | [Subscribe → Growth Hack Academy](https://www.youtube.com/@GrowthHackAcademy?sub_confirmation=1) |
66 
67⭐ **Saved you time? [Star the repo](https://github.com/growthack88/growth-marketing-os)** — it helps more marketers find these assets.
68 
69> All assets are original work by [Mahmoud Omar](https://mahmoudomar.com), battle-tested on real accounts. Free to use with attribution. Not AI-generated filler.
70 
View all files on GitHub →

Details

License
MIT
Stars on the repo
★ 117
Checked
Source
growthack88/growth-marketing-os ↗
Creator
growthack88 · 13 listings
View creator

Similar skills

See all →

More from growthack88

SkillArabic Marketing Copy Localizergrowthack88/growth-marketing-os · by growthack88Marketing copy localization skill that converts English marketing copy (ads, landing pages, emails, CTAs) into native Egyptian Arabic عامية — or GCC dialect on request — with natural English code-switching for business terms. Use whenever marketing copy needs an Arabic version, an Arabic draft "sounds translated", or a bilingual campaign is being built. Rebuilds meaning per line instead of translating words; never outputs فصحى for performance marketing contexts.★ 117 GitHub starsSkillCompetitive Win Cardsgrowthack88/growth-marketing-os · by growthack88Creates competitive battlecards for sales deal conversations. Produces win themes, landmines to plant, objection handlers, and competitive positioning per competitor. Outputs a structured markdown battlecard with quick-reference sections for live sales calls. Depends on competitor-research for competitive intelligence and consumes product-messaging, win-loss-analysis, and positioning for framing. Feeds into sales-deck, outreach-emails, and demo-script. Triggered by "battlecard", "competitive intel", "win against [competitor]", or "how do we beat [competitor]".★ 117 GitHub starsSkillMetric Benchmark Analyzergrowthack88/growth-marketing-os · by growthack88Marketing benchmark triage skill. Use whenever metrics are shared with questions like "is this good?", "is this normal?", or "should I worry?" — ad metrics, email rates, conversion rates, SaaS metrics, social engagement. Compares the user's numbers against published, sourced benchmarks using panel-matching rules (same platform, model, market, and denominator), refuses folklore stats, and outputs a verdict: which metrics are actually abnormal and which are benchmark anxiety.★ 117 GitHub starsSkillCash-on-Delivery Opsgrowthack88/growth-marketing-os · by growthack88COD (cash-on-delivery) e-commerce operations skill. Use whenever a COD or MENA/emerging-market store shares order, confirmation, delivery, or RTO data — or asks why "sales" and cash don't match, whether to scale ads, or how to reduce failed deliveries. Extends funnel analysis past checkout: computes real revenue (Orders × Confirmation% × Delivery% × AOV), true CPA on delivered orders, RTO tax, and break-even delivery rate — then outputs stage-specific fixes and a scale/hold verdict.★ 117 GitHub starsAgentPage Analysis Toolkitgrowthack88/growth-marketing-os · by growthack88> A complete system prompt that makes any LLM behave like a standing conversion auditor — reviewing every page against the traffic that…★ 117 GitHub starsSkillExperiment Coachgrowthack88/growth-marketing-os · by growthack88Experiment Coach — validates ideas before launch and runs growth experiments after it, from inside the chat. Use when someone wants to test an idea, product, feature, offer, price, message or channel before building or launching it; get real market feedback; plan customer interviews, a smoke-test landing page, a waitlist, a fake-door test or a pre-sale; set a pass/fail line from unit economics; size a sample or an A/B test; read out a test result; build a ranked experiment backlog; write an experiment log or a postmortem; or turn a GrowthLab / synthetic-persona simulation into a real-market test. For MENA and global markets, in Arabic and English. Triggers: validate my idea, pre-launch, smoke test, waitlist, fake door, pre-sale, experiment, A/B test, growth experiment, sample size, is this significant, hypothesis, backlog, postmortem, GrowthLab, اختبر فكرتي, قبل الإطلاق, أتأكد قبل ما أبني, تجربة, تجارب نمو, اختبار A/B, حجم العينة, قائمة انتظار, بيع مسبق, النتيجة دي معنوية؟★ 117 GitHub stars