Skip to content
NewAI dashboards.See how →
Open MammothTry free
Workflow · Customers · Opening soon

Price increase impact by customer

Use Stripe exports to show the revenue impact of a price increase by customer. You get the old price, the new price, and the change for each customer.

Early access opens shortly. Check back soon.

Book a demo
Someone typed

“show the revenue impact of the price increase by customer: old price, new price and the change”

The agent read it as

Show the revenue impact of the price increase by customer: old price, new price and the change using Stripe subscription price changes, Stripe customers and Stripe prices.

What the agent built

8 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Stripe subscription price changes
    CSV export · 12 rows
  2. File
    Stripe customers
    CSV export · 12 rows
  3. File
    Stripe prices
    CSV export · 12 rows
  4. File
    Stripe prices
    CSV export · 12 rows
  5. Step
    Make change keys
    Step 4
  6. Step
    Make customer key
    Step 1
  7. Step
    Make old price key
    Step 2
  8. Step
    Make new price key
    Step 3
  9. Join
    Find customer name
    12 of 12 paired
  10. Join
    Get old price
    12 of 12 paired
  11. Join
    Get new price
    12 of 12 paired
  12. Step
    Show price change
    Step 8
  13. Result
    Customer Price Impact
    12 rows
  14. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 12 rows came out, and the join paired 12 of 12 rows; the join paired 12 of 12 rows; the join paired 12 of 12 rows.

What you get back

The result of that run, the rows to look at first.

Customer Price ImpactSample data12 rows
CustomerOld price (USD)New price (USD)Change (USD)
Northstar Studio495910
Harbor & Pine12914920
Morrow Health24928940
Lumen Cart49957980
Summit Thread798910
Copperleaf Ops24928940
Bluegate Co12914920
Orchard Nine495910
Fieldline Media9991,149150
Keystone Bento798910
Aster Works12914920
Northwind Goods24928940
12 rows in the result. Sample data: illustrative figures, not business results.

How do you show the revenue impact of a price increase by customer?

Export the Stripe data for subscription price changes, customers, and prices. Mammoth matches the rows, finds the customer name, gets the old price and new price, then shows the change by customer.

How it works

How to use the Customer Price Impact workflow

  1. 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.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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 Price Impact: questions

What Stripe export should you use?
Use the Stripe exports for subscription price changes, customers, and prices. These files give the workflow the rows it needs to compare the old price and the new price by customer.
What happens to rows that do not match?
Rows that do not match the keys you set are left out of the result. You can review the unmatched rows and adjust the matching rules if needed.
How do you change the matching rules?
Edit the keys and lookup steps in words, then run the workflow again. You can change which columns are used to match customers, old prices, and new prices.

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.

Early access opens shortly. Check back soon.

Book a demo

Workflows like this

Cohorts, churn, repeat purchases, retention, RFM segments and recurring revenue, from your orders or payments.

All customer templates →

Keep reading

Read nextAll workflowsDescribe yours, or start from one the agent already built.Take a lookProductData EngineConnected sources, cleaning and scheduled refresh.Take a lookConnectorsConnectorsBring the data in from the tools you already use.Take a look