A cohort is one period's worth of new customers. In their first period, the cohort generates revenue from both subscription and one-time orders at the blended AOV. After that, only the subscription portion repeats, decayed by churn each period.
Each column is one 28-day period. The Total column sums all 12 periods (336 days, the full forecast horizon).
The problem. Determining the optimal ROAS to set depending on your
ad spend is a complex problem. As your ROAS changes, your daily spend has to change
non-linearly to keep net income the same. Sometimes it's better to keep a lower spend
at a higher ROAS, but the answer is non-trivial. For example, moving from 1.5 to 1.3
ROAS might require a 10% increase in spend to hold the same net income, but moving
from 1.3 to 1.1 might require a 20% increase.
How to use this tool. Set your current ROAS and daily spend, then
drag your target ROAS. The tool shows how much you need to spend daily to keep the
same net income.
Every point on the curve is a (ROAS, spend) combo that hits the same net income as your baseline. Above the curve = more NI than baseline. Below = less.