Example projectWeb app
Product metrics warehouse
Hypothetical. Not a client, not a result.
// The problem
A SaaS company reports revenue from Stripe, usage from the database and churn from a spreadsheet, and the numbers in the board deck never match the numbers in the product.
// What we would build
A small warehouse that reads billing, product usage and the CRM into one model, with agreed definitions for revenue, churn and activation, and dashboards the team and the board read from the same source.
// What is in it
- Billing, usage and CRM in one model
- Agreed definitions for revenue, churn and activation
- Cohorts and retention by plan and signup month
- Dashboards for the team and the board
- Data in a warehouse you own
// Stack
- PostgreSQL
- dbt
- Next.js
- Stripe interface
- AWS
// estimate
- Build
- ≈ US$44,500 to US$68,100, delivered within 14 weeksCAD 63,400 to 97,000
- Hosting
- ≈ US$176 a monthCAD 250 a month
- Support
- ≈ US$1,000 a monthCAD 1,425 a month
Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.
Timeline by milestone
- Discovery
- 2.9 to 3.4 weeks
- Design approved
- 2.4 to 3.4 weeks
- Core features
- 1.4 to 2.4 weeks
- Full build
- 0.9 to 1.9 weeks
- Testing and fixes
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
How it is paid
- Deposit 30%
- CAD 19,020 to 29,100
- Discovery 6.6%
- CAD 4,184.40 to 6,402.00
- Design approved 6.6%
- CAD 4,184.40 to 6,402.00
- Core features 20%
- CAD 12,680 to 19,400
- Full build 13.3%
- CAD 8,432.20 to 12,901.00
- Testing and fixes 6.6%
- CAD 4,184.40 to 6,402.00
- Launch 6.9%
- CAD 4,374.60 to 6,693.00
- Holdback, 30 days after launch (10%)
- CAD 6,340 to 9,700