Farm to Table — ads · v2

Meta + Adapty · Agency
AllMainAgencySpanish
Spend
$0
CPM — · Link CTR —
Attributed Meta ads only
All attributed + all unattributed
Revenue
$0
Revenue
Actual
$0.00
Projected
$129.16
ROAS
—
ROAS
—
Installs
0
Installs
70
Trials
Total
0
Install→trial
—
Cost/trial
—
3d
0
7d
0
Trials
Total
13
Install→trial
18.6%
Cost/trial
$0.00
3d
10
7d
3
Stayed
Actual
—
Projected
—
3d
—
7d
—
Stayed
Actual
53.8%
Projected
30.2%
3d
50.0%
7d
66.7%
CPA
—
CPA
Actual
—
Projected
$0.00
Subs
Actual
0
Projected
0.0
Grace
0
Billing dead
0
Subs
Actual
0
Projected
3.9
Grace
0
Billing dead
0

Ad sets & ads

No Meta data — run ingest_meta_api.py
Legend.
Revenue = net of Apple 15%; everything cohorts paid to date (first payments + renewals + grace recoveries), refunds subtracted.
Projected Revenue = actual net revenue received + each pending user’s vendor-product net × its 3d/7d age weight + open Grace net × 30%, then the projected part × non-refund probability.
ROAS = revenue ÷ spend; Projected ROAS = projected revenue ÷ spend.
CPA = spend ÷ paid subs.
Projected CPA = spend ÷ ((paid + Σ age-weighted active trials + open Grace × 30%) × 100%). Active 3d/7d weights change with age; ×100% = minus refunds (0.0% so far).
Attributed +30% takes one shared baseline from the unattributed bucket and allocates it across Main, Agency and Spanish by attributed Projected Revenue; source totals add back to All. Organic uplift ≈ is the remaining unattributed Projected Revenue; its share of the unattributed bucket estimates the other cohort metrics. It is part of the total, not extra revenue.
Trials / Pending / Cancelled — крупное число = все триалы вместе; подпись «3d · 7d» — сплит по длине триала (7d = winback-оффер после закрытия пейвола).
Pending = ни отмены, ни оплаты, первое списание ещё не наступило (по реальной дате окончания 3d/7d/30d-триала).
30d trial = 30-дневный intro-оффер основного пейвола (с 23.09): участвует во всём наравне с 3d/7d, включая Projected CPA; его реальная конверсия откалибруется на первых списаниях ~23-24.10.
Cancelled = auto-renew off в триале.
Stayed = (trials − cancels) ÷ trials.
Grace = billing retry in progress.
Billing dead = no charge, never recovered.