Streamly, a subscription video app, increased paid acquisition spend in several markets and wants to estimate how much weekly signups changed after controlling for seasonality and pricing. The goal is to use regression for product growth analysis rather than relying on a simple before/after comparison.
You are given the output of a linear regression where weekly new signups are modeled as a function of paid marketing spend, average subscription price, and a holiday-week indicator.
The fitted model is:
where ad spend is measured in $1,000s, price in USD, and holiday is 1 for holiday weeks and 0 otherwise.
| Parameter | Estimate | Standard Error | t-statistic |
|---|---|---|---|
| Intercept | 820.0 | 95.0 | 8.63 |
| Ad spend | 18.4 | 4.7 | 3.91 |
| Price | -42.0 | 11.5 | -3.65 |
| Holiday | 160.0 | 55.0 | 2.91 |
Additional information:
| Metric | Value |
|---|---|
| Number of weeks | 52 |
| Number of predictors | 3 |
| Baseline ad spend for scenario | 120 |
| Proposed ad spend for scenario | 150 |
| Average price | 12.99 |
| Holiday indicator for scenario | 0 |
| Significance level | 0.05 |