Customer segmentation by revenue
“segment customers into tiers by their last 12 months of revenue and show how many customers and how much revenue sits in each tier”
Segment customers into tiers by their last 12 months of revenue and show how many customers and how much revenue sits in each tier from Stripe customers, Stripe charges and Revenue tier thresholds.
What the agent built
6 steps, each one an ordinary Mammoth step you can open and change.
- FileStripe customersCSV export · 18 rows
- FileStripe chargesCSV export · 32 rows
- FileRevenue tier thresholdsCSV export · 6 rows
- StepTotal paid revenue per customerStep 1
- StepPrepare tier comparison (Revenue tier thresholds)Step 4
- JoinAdd customer revenue18 of 18 paired
- StepPrepare tier comparison (Stripe customers)Step 3
- JoinBring in tier thresholds18 of 18 paired
- StepCount customers and revenue by tierStep 6
- ResultCustomer Revenue Tiers6 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 6 rows came out, and the join paired 18 of 18 rows; the join paired 18 of 18 rows.
- Download Stripe customers sample (18 rows)Stripe: Customers > All customers > Export CSV
- Download Stripe charges sample (32 rows)Stripe: Payments > Charges > Export CSV
- Download Revenue tier thresholds sample (6 rows)Stripe: Not a native export; maintained as a spreadsheet lookup for segmentation rules
What you get back
The result of that run, the rows to look at first.
| Tier | Customer count | Revenue (USD) |
|---|---|---|
| starter | 2 | 820 |
| grower | 2 | 1,215 |
| builder | 6 | 10,410 |
| accelerator | 4 | 12,190 |
| enterprise | 3 | 18,650 |
| strategic | 1 | 12,900 |
How do you segment customers by revenue?
Export your Stripe customers and charges, plus your revenue tier thresholds. Mammoth totals paid revenue per customer, matches each customer to a tier, then shows customer counts and revenue by tier.
How it works
How to use the Customer Revenue Tiers workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Customer Revenue Tiers: questions
What export do I need from Stripe?
What happens if a row does not match a tier?
How do I change the tier rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Measure how fast the pipeline turns into revenue, and where people drop out of your funnel.
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template
- Funnel analysisHow many people reach each step of your funnel, in order, and where they drop offSee the workflow Template
- Sales forecast from pipelineForecast this quarter’s sales from a HubSpot export, using stage probability, close month, and closed won revenue.See the workflow Built by the agent
- Survey results analysisSummarize Typeform survey responses by question and respondent segment, with score averages and response counts.See the workflow Built by the agent
- Time to first valueMeasure how many days new accounts take to reach their first key action, grouped by signup week, from a Mixpanel events export.See the workflow Built by the agent
- Feature adoptionCompare feature adoption this month and last month from a Mixpanel export. See which features held, dropped, or shifted.See the workflow Built by the agent