FormulaPad for marketing analysts
Channel ROAS by campaign, funnel conversion by step, cohort retention — describe the metric, paste the formula, update the report. Skip the Stack Overflow detour.
Sound familiar?
- •Manual copy-paste into ad-platform reports that change schema every quarter.
- •Calculating ROAS across 8 channels with different attribution windows.
- •Pivot-style channel-by-quarter reports when Looker is overkill.
- •Funnel drop-off percentages without building a whole dashboard.
- •LTV:CAC ratios that need to update when a single row changes.
FormulaPad understands marketing math. Describe "ROAS for channel X" and get the formula. Describe "cohort retention from signup week" and get it. 5/day free, upgrade if you live in spreadsheets.
Formulas you will actually use
ROAS by channel
Calculate ROAS (revenue divided by spend) in column E for each row, showing "N/A" when spend is zero
=IF(D2=0, "N/A", C2/D2)Guarded division. No #DIV/0 mess when a row has zero spend.
Funnel conversion between steps
Show conversion rate from column A (visitors) to column B (signups) as a percentage
=IFERROR(B2/A2, 0)Format the result cell as percentage and it reads cleanly in reports.
Channel totals with SUMIFS
Sum revenue in column E where channel in column A is "Paid Search" and month in column B is January 2024
=SUMIFS(E:E, A:A, "Paid Search", B:B, ">="&DATE(2024,1,1), B:B, "<="&DATE(2024,1,31))Locale-safe dates, two criteria combined, ready for a channel table.
LTV:CAC ratio
Calculate LTV to CAC ratio in column F where LTV is column D and CAC is column E
=IFERROR(D2/E2, 0)Flag rows where this ratio is below 3 with conditional formatting for a quick signal.
FAQ
Does it connect to Google Ads or Facebook directly?
No. FormulaPad writes the formulas — connecting live data is your job (native importers, Supermetrics, etc.).
Can I generate cohort analysis formulas?
Yes. Describe the cohort definition and retention metric, and it returns the formula set.
Other roles
Try it — 5 formulas free, no signup
No credit card•Cancel anytime•Excel + Sheets
Generate your first formula