D7 to D30 payback bridge worksheet for SLG / 4X
Illustrative bridge from D7 to D30 payback for SLG/4X planning. Operator supplies the multiplier; no market average invented.
SLG cash often arrives after day 7. Killing a cohort on D7 alone can discard good buyers. This bridge worksheet applies an operator-supplied D30/D7 revenue multiplier to a synthetic D7 payback. It does not invent a genre multiplier.
Define the calculation before using it
d30_payback_est = d7_payback * k where k is your historical mature D30 revenue / D7 revenue for comparable cohorts. AppsFlyer ROAS remains revenue/cost under your chosen gross or net definition.
Work through the synthetic example
| Input | Value | Status |
|---|---|---|
| D7 payback | 0.22 | illustrative |
| Operator bridge multiplier `k` | 2.40 | illustrative — replace with title history |
| Media cost | 50,000 | illustrative |
| D7 revenue | 11,000 | illustrative |
| Output | Result |
|---|---|
| Estimated D30 payback | 0.5280 |
| Implied D30 revenue | 26,400.0000 |
Facts versus limits
| Field | Evidence |
|---|---|
| Formula | `d30_payback_est = d7_payback * k` |
| Market SLG `k` | Not claimed |
| Forecast uncertainty | Not modelled |
Download the worksheet CSV.
