Sales Decline Analyzer
Funnel Decomposition Analyst — Claude Skill

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)
npx skills add growthack88/growth-marketing-os --skill funnel-decomposition-analyst -g -a claude-codenpx degit growthack88/growth-marketing-os/skills/funnel-decomposition#main ~/.claude/skills/funnel-decompositionConnects with Agent Alley MCP · agentalley.io/mcp
Files included
SKILL.md3.4 KB
Read SKILL.md here
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:
- Compute each lever for both periods.
- Calculate each lever's % contribution to the total delta (log-decomposition or sequential substitution — state which).
- Rank levers by contribution. The top contributor is the diagnosis; everything else is noise.
- 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 | |
| 2 | name funnel-decomposition-analyst |
| 3 | description > |
| 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. |
| 10 | author "Mahmoud Omar — https://mahmoudomar.com" |
| 11 | license MIT |
| 12 | |
| 13 | |
| 14 | # Funnel Decomposition Analyst — Claude Skill |
| 15 | |
| 16 | **By [Mahmoud Omar]** · 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 | |
| 20 | Revenue = Visitors × ATC% × Checkout% × Purchase% × AOV |
| 21 | |
| 22 | When the user shares two periods of data: |
| 23 | |
| 24 | Compute each lever for both periods. |
| 25 | Calculate each lever's **% contribution to the total delta** (log-decomposition or sequential substitution — state which). |
| 26 | Rank levers by contribution. The top contributor is the diagnosis; everything else is noise. |
| 27 | 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 | |
| 48 | Skill 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] | |
| 60 | | 📕 GrowthOS Guide · Building Growth Machine | [buildinggrowthmachine.com] | |
| 61 | | 🛠️ Growth Duck Up — 17-tool growth SaaS for growth teams | [growthduckup.com] | |
| 62 | | 🎓 Growth Hack Academy | [growthhackacademy.com] | |
| 63 | | 🚀 StartupKit Pro — Startup OS for MENA founders | [startupkit.pro] | |
| 64 | | 🍅 DuckDoro — calm productivity app | [duckdoro.com] | |
| 65 | | 🎥 YouTube (40K+ marketers) | [Subscribe → Growth Hack Academy] | |
| 66 | |
| 67 | ⭐ **Saved you time? [Star the repo]** — it helps more marketers find these assets. |
| 68 | |
| 69 | > All assets are original work by [Mahmoud Omar], battle-tested on real accounts. Free to use with attribution. Not AI-generated filler. |
| 70 |
Details
- License
- MIT
- Stars on the repo
- ★ 117
- Checked
- Source
- growthack88/growth-marketing-os ↗
- Creator
- growthack88 · 13 listings
Similar skills
See all →
SkillCross-Platform Reverse Engineer
SkillBrainstorm Ideas
SkillCode Review Feedback Analyzer
SkillBug Diagnosis Framework
SkillImplement Spec
SkillPR Description WriterMore from growthack88
SkillArabic Marketing Copy Localizer
SkillCompetitive Win Cards
SkillMetric Benchmark Analyzer
SkillCash-on-Delivery Ops
AgentPage Analysis Toolkit
SkillExperiment Coach