ClearPath AI — FB Ad Reverse Engineer & ROI Calculator

Section 1

Ad Results Input

Add rows and input your ad metrics. KPIs update live without losing focus.

Ad Name	Spend ($)	Reach	Impressions	Clicks	Purchases	KPIs (per ad)	Remove

ℹ️ Tip: CTR/CPM will use "Impressions" when provided (CTR = clicks ÷ impressions, CPM = spend ÷ (impressions/1000)). If Impressions is blank/0, the calculator falls back to Reach.

Section 2

Blended Metrics (All Ads)

This is your current baseline from the ads you entered.

Blended CTR

—

Clicks ÷ Impressions (fallback: Reach)

Blended CPC

—

Spend ÷ Clicks

Blended CPM

—

Spend ÷ (Impressions / 1000) (fallback: Reach)

Blended CVR

—

Purchases ÷ Clicks

Blended CPA

—

Spend ÷ Purchases

Totals

—

$Spend / Reach / Impressions / Clicks / Purchases

Section 3

Spend ↔ Results (What-If Scenarios)

Use your baseline rates to project results. Either scale up/down your spend to see outcomes, or set a target (purchases or revenue) to reverse-engineer required spend.

Use rates from

Average Purchase Value ($)

Required for revenue calculations.

Forward Projection: Spend → Results

Enter a spend amount to see projected reach, clicks, purchases, and revenue.

Projected Spend ($)

—

Gross Profit Margin (%)

Applied to revenue to show gross profit.

Projected Reach

—

Scaled from baseline

Projected Clicks

—

Scaled from baseline

Projected Purchases

—

Scaled from baseline

Projected Revenue

—

Purchases × Avg Order Value

Projected Gross Profit

—

Revenue × (Margin / 100)

Net Profit

—

Gross Profit − Spend

📊 Phase 1 Metrics: ROI & Breakeven

Return on investment, profit margins, and breakeven analysis.

ROAS (Return on Ad Spend)

—

Revenue ÷ Spend

Profit Margin %

—

Gross Profit ÷ Revenue

Breakeven Purchases

—

Spend ÷ Avg Purchase Value

Breakeven AOV (if needed)

—

Spend ÷ Projected Purchases

ROI %

—

(Net Profit) ÷ Spend

Status

—

Profitable or Loss

Phase 1 Insights: ROAS > 1 = profitable. Breakeven shows minimum purchases/AOV needed to cover ad spend. ROI % shows net return (negative = loss). All metrics update as you adjust spend, AOV, or margin.

🎯 Reverse Engineer: Target → Required Spend

Set a target purchases or target revenue to reverse-engineer the spend needed using your selected baseline.

Target Purchases

Uses baseline Purchases/Spend rate. Requires baseline purchases > 0.

Target Revenue ($)

If set and AOV > 0, target purchases = revenue ÷ AOV (overrides Target Purchases).

Required Spend

—

Scaled from baseline

Required Reach

—

Scaled from baseline

Required Clicks

—

Scaled from baseline

Target Purchases Used

—

From Purchases or Revenue

Target Revenue Used

—

Revenue (if provided)

Status

—

Requirements met?

📈 Phase 2: Sensitivity Analysis

See how AOV and CVR changes impact your profit. Adjust sliders to explore different scenarios.

AOV Adjustment

+0%

Simulates AOV increase/decrease (e.g., +20% = higher prices)

CVR Adjustment

+0%

Simulates CVR improvement (e.g., +30% = better conversion optimization)

Adjusted AOV

—

Base AOV × Adjustment

Adjusted CVR

—

Base CVR × Adjustment

Impact on Net Profit

—

vs. current projection

New Revenue

—

With adjustments applied

New Gross Profit

—

With adjustments applied

New Net Profit

—

With all adjustments

Sensitivity Insight: Shows profitability impact of AOV increases (price optimization) and CVR improvements (conversion testing).

🎯 Phase 2: Ad Comparison

Side-by-side performance of all ads—see which performs best. Click column headers to sort.

Ad Name	Spend	CTR	CPC	CVR	CPA	Est. ROAS	Est. Profit

🔄 Phase 3: Historical Tracking & Snapshots

Save snapshots of your baseline to track changes over time. See trends and confidence levels.

No snapshots yet

Date/Time	Spend	CTR	CPC	CVR	CPA	Trend	Action

Tracks baseline changes over time. Trend shows if metrics are improving (↑), declining (↓), or stable (→).

⚠️ Phase 3: Risk Assessment

Data quality, projection confidence, and risk flags.

Data Completeness

—

% of fields filled

Projection Confidence

—

Low/Medium/High

Data Age

—

Time since first snapshot

Sample Size

—

Ad count & purchase count

CVR Stability

—

Variance in conversion rate

Risk Flags

—

⚠️ issues detected

Confidence Levels: HIGH = 5+ snapshots, 100+ purchases | MEDIUM = 2-4 snapshots, 20-100 purchases | LOW = 0-1 snapshots or <20 purchases

Section 3b

Forecast Scenarios (Quick Comparison)

Compare outcomes across common spend multipliers (0.5x, 1x, 1.5x, 2x baseline).

Section 4

Formulas (what the page computes)

Equations match the calculator logic.

Baseline is the selected ad (or blended totals): baselineSpend, baselineReach, baselineImpressions, baselineClicks, baselinePurchases CTR/CPM Base: baselineBase = (baselineImpressions > 0) ? baselineImpressions : baselineReach Scale Factor = whatIfSpend / baselineSpend Projected Reach = baselineReach × Scale Factor Projected Impressions = baselineImpressions × Scale Factor Projected Clicks = baselineClicks × Scale Factor Projected Purchases = baselinePurchases × Scale Factor Revenue & Profit Calculations:
Projected Revenue = Projected Purchases × Average Purchase Value
Projected Gross Profit = Projected Revenue × (Gross Profit Margin / 100)
Net Profit = Projected Gross Profit − What-If Spend

Reverse-engineer Spend (requires baselinePurchases > 0):
requiredSpend = (targetPurchases / baselinePurchases) × baselineSpend
(If using revenue target: targetPurchases = targetRevenue / avgPurchaseValue)