Farm to Table — Web ads · v2

Meta + Web attribution · Main
AllMainAgencySpanish
Spend
$6,094.82
CPM $64.36 · Link CTR 6.76%
Meta web Stripe net · projected charge horizons
Revenue
Actual
$4,221.31
Projected Day 7
$4,546.96
Projected Day 37
$5,364.59
Projected Day 67
$5,979.86
Base
$3,493.11
Upsells
$728.20
incl. unattributed $221.43
Leads
Total
2,164
CPL
$2.82
Click→lead
33.8%
Lead→paid
7.9%
ROAS
ROAS
69%
Projected Day 7
75%
Projected Day 37
88%
Projected Day 67
98%
CAC
CAC
$35.85
LTV
Actual
$24.83
Projected Day 7
$26.75
Projected Day 37
$31.56
Projected Day 67
$35.18
Purchases
Purchases
234
Customers
170
Active 7d trials
52
Billing errors
15.3%

Ad sets & ads

Period
закрытоещё созревает
Ad set / adSpendCPMLink clicksLink CTRLeadsClick→LeadLead→PaidPaid usersPurchasesRevenueLTVProjected LTV Day 7Projected LTV Day 37Projected LTV Day 67CACCost/leadHook%Hold%BudgetReachFrequency
Web_EN-T1_iOS_18-65_Broad_AS01_Control (6) Backup ACTIVE$6,094.82$64.366,4016.8%2,16433.8%7.3%159218$3,951.81$24.85$26.90$31.81$35.50$38.33$2.8213.9%23.6%—66,9761.41
WEB_C11_BreakingNews_322$3,560.86$69.503,7697.4%1,37036.3%8.5%116162$2,949.43$25.43$28.23$34.42$39.07$30.70$2.600.0%——37,0261.38
WEB_Ring2_Demo_C5_322$1,897.71$54.092,1156.0%63930.2%5.5%3547$818.06$23.37$23.37$25.17$26.51$54.22$2.9736.3%22.9%—29,7751.18
WEB_C10_ProduceCompare_322$267.46$86.701404.5%3827.1%13.2%56$132.34$26.47$26.47$26.47$26.47$53.49$7.040.0%——2,6021.19
WEB_Control_SF08$218.62$60.292677.4%8331.1%2.4%22$47.45$23.73$23.73$23.73$23.73$109.31$2.630.0%——3,3261.09
WEB_C9_FoodHaul_322$118.45$129.31768.3%2634.2%0.0%00$0.00—————$4.5643.8%44.9%—7381.24
WEB_C10.1_MeatEggsCompare_322$31.72$42.46344.5%823.5%12.5%11$4.53$4.53$4.53$4.53$4.53$31.72$3.960.0%——6611.13
US Broad (1) TecDo PAUSED$0—0—0——11$48.07$48.07$48.07$48.07$48.07$0.00——————
SF08_winner$0.00—0—0——11$48.07$48.07$48.07$48.07$48.07$0.00——————
Click an ad set to expand its ads. Meta web: only campaigns whose name contains Web are shown. Account-level financial KPIs include every Stripe purchase because this funnel has no non-Meta traffic; revenue without a captured ad ID is disclosed as Unattributed and is not guessed onto a creative. Revenue = Stripe charge-level net after Stripe processing fees, refunds and disputes. Leads = Meta Lead events attributed to each web ad; in this funnel Lead is the email submission. PostHog is used only as a fallback when Meta has no lead data for the selected period. Click→Lead = leads ÷ Meta link clicks; Lead→Paid = unique paid customer orders ÷ leads. Actual LTV = realized Stripe net ÷ unique paid users in the selected cohort. Projected LTV Day 7 / 37 / 67 = factual Stripe cohort net received so far plus expected subscription charges by that horizon, divided by the same acquired paid-user base. Current 7-day trials convert to $14.99/week: the optimistic scenario uses 45% Trial→Paid, then weekly conditional renewals of 70%, 88% and 92%; after renewal 3, 92% remains the temporary prior until our own cohorts mature. The assumption reflects the expected reduction in insufficient-funds failures at the lower charge and low voluntary churn among current successful Web payers. Legacy 7-day → $29.99/month trials already in flight retain their actual destination price and the prior monthly benchmarks 70.7%, 79.7% and 83.3%. Active Recipe Book subscriptions project their $19.99 monthly renewals with the monthly assumptions. A 3% refund reserve is deducted from every projected charge; factual Stripe refunds already reduce Actual revenue. The open dispute is deducted from Actual revenue only and is not counted as a refund. These Health & Fitness retention benchmarks come from RevenueCat 2025 and will be replaced with our web retention as cohorts mature. Other upsells stay factual and are never projected. CAC = spend ÷ unique paid users. Active trial users already paid their entry fee and are already in that denominator, so forecasting their later conversion must not add them again. There is no +30% baseline or organic uplift on this page. Unattributed payments stay outside per-creative rows instead of being assigned by guesswork. Reach / Frequency = deduplicated lifetime.