Reading saved projects…
£981.41 gross profit less £13,000.00 SEO investment over 12 months.
Net contribution divided by investment over 12 months.
Checked through month 36. The cumulative result stays non-negative after recovery within that modelled period.
- Incremental clicks
- 363.48
- Incremental leads
- 10.9
- Incremental customers
- 2.18
- Incremental revenue
- £2,453.52
Google Ads traffic cost equivalent
No actual Google Ads CPC has been supplied, so no traffic cost equivalent has been calculated. Enter your average CPC in Business economics to add this optional comparison.
Profit and investment over 12 months
- Gross profit
- Investment
- Net contribution
Cumulative, incremental results for base case. Figures are conditional on the entered targets and economics; they include negative outcomes.
How the outcome could change
Planning cases for the same 12-month period.
| Planning case | Gross profit | Investment | Net contribution | ROI | Sustained payback |
|---|---|---|---|---|---|
| £0.00 | £13,000.00 | -£13,000.00 | -100% | Not reached | |
| £453.12 | £13,000.00 | -£12,546.88 | -96.5% | Not reached | |
| £981.41 | £13,000.00 | -£12,018.59 | -92.5% | Not reached | |
| £1,971.64 | £13,000.00 | -£11,028.36 | -84.8% | Not reached |
Cases are not probabilities or statistical confidence intervals. Rank multipliers scale declines as well as improvements, so labels do not guarantee the order of returns. Payback is checked through month 36, including months beyond this report period.
View the monthly calculation and payback checks
- First cumulative break-even
- Not reached by month 36
- First positive cashflow
- Not reached by month 36
- Sustained payback
- Not reached by month 36
Sustained payback means the cumulative result stays non-negative after a positive recovery through month 36. This does not predict what happens after month 36.
| Month | Effect factor | Monthly gross profit | Monthly investment | Monthly net | Cumulative gross profit | Cumulative investment | Cumulative net |
|---|---|---|---|---|---|---|---|
| 1 | 0% | £0.00 | £2,000.00 | -£2,000.00 | £0.00 | £2,000.00 | -£2,000.00 |
| 2 | 5% | £7.06 | £1,000.00 | -£992.94 | £7.06 | £3,000.00 | -£2,992.94 |
| 3 | 15% | £21.18 | £1,000.00 | -£978.82 | £28.24 | £4,000.00 | -£3,971.76 |
| 4 | 30% | £42.36 | £1,000.00 | -£957.64 | £70.61 | £5,000.00 | -£4,929.39 |
| 5 | 45% | £63.54 | £1,000.00 | -£936.46 | £134.15 | £6,000.00 | -£5,865.85 |
| 6 | 60% | £84.73 | £1,000.00 | -£915.27 | £218.88 | £7,000.00 | -£6,781.12 |
| 7 | 72% | £101.67 | £1,000.00 | -£898.33 | £320.55 | £8,000.00 | -£7,679.45 |
| 8 | 82% | £115.79 | £1,000.00 | -£884.21 | £436.34 | £9,000.00 | -£8,563.66 |
| 9 | 90% | £127.09 | £1,000.00 | -£872.91 | £563.43 | £10,000.00 | -£9,436.57 |
| 10 | 96% | £135.56 | £1,000.00 | -£864.44 | £698.99 | £11,000.00 | -£10,301.01 |
| 11 | 100% | £141.21 | £1,000.00 | -£858.79 | £840.20 | £12,000.00 | -£11,159.80 |
| 12 | 100% | £141.21 | £1,000.00 | -£858.79 | £981.41 | £13,000.00 | -£12,018.59 |
| 13, outside selected period | 98.1577% | £138.61 | £0.00 | +£138.61 | £1,120.02 | £13,000.00 | -£11,879.98 |
| 14, outside selected period | 96.3492% | £136.05 | £0.00 | +£136.05 | £1,256.07 | £13,000.00 | -£11,743.93 |
| 15, outside selected period | 94.5742% | £133.55 | £0.00 | +£133.55 | £1,389.62 | £13,000.00 | -£11,610.38 |
| 16, outside selected period | 92.8318% | £131.09 | £0.00 | +£131.09 | £1,520.71 | £13,000.00 | -£11,479.29 |
| 17, outside selected period | 91.1215% | £128.67 | £0.00 | +£128.67 | £1,649.38 | £13,000.00 | -£11,350.62 |
| 18, outside selected period | 89.4427% | £126.30 | £0.00 | +£126.30 | £1,775.68 | £13,000.00 | -£11,224.32 |
| 19, outside selected period | 87.7949% | £123.98 | £0.00 | +£123.98 | £1,899.66 | £13,000.00 | -£11,100.34 |
| 20, outside selected period | 86.1774% | £121.69 | £0.00 | +£121.69 | £2,021.35 | £13,000.00 | -£10,978.65 |
| 21, outside selected period | 84.5897% | £119.45 | £0.00 | +£119.45 | £2,140.80 | £13,000.00 | -£10,859.20 |
| 22, outside selected period | 83.0313% | £117.25 | £0.00 | +£117.25 | £2,258.05 | £13,000.00 | -£10,741.95 |
| 23, outside selected period | 81.5015% | £115.09 | £0.00 | +£115.09 | £2,373.14 | £13,000.00 | -£10,626.86 |
| 24, outside selected period | 80% | £112.97 | £0.00 | +£112.97 | £2,486.10 | £13,000.00 | -£10,513.90 |
| 25, outside selected period | 78.5261% | £110.89 | £0.00 | +£110.89 | £2,596.99 | £13,000.00 | -£10,403.01 |
| 26, outside selected period | 77.0794% | £108.84 | £0.00 | +£108.84 | £2,705.83 | £13,000.00 | -£10,294.17 |
| 27, outside selected period | 75.6593% | £106.84 | £0.00 | +£106.84 | £2,812.67 | £13,000.00 | -£10,187.33 |
| 28, outside selected period | 74.2654% | £104.87 | £0.00 | +£104.87 | £2,917.54 | £13,000.00 | -£10,082.46 |
| 29, outside selected period | 72.8972% | £102.94 | £0.00 | +£102.94 | £3,020.48 | £13,000.00 | -£9,979.52 |
| 30, outside selected period | 71.5542% | £101.04 | £0.00 | +£101.04 | £3,121.52 | £13,000.00 | -£9,878.48 |
| 31, outside selected period | 70.2359% | £99.18 | £0.00 | +£99.18 | £3,220.70 | £13,000.00 | -£9,779.30 |
| 32, outside selected period | 68.9419% | £97.35 | £0.00 | +£97.35 | £3,318.06 | £13,000.00 | -£9,681.94 |
| 33, outside selected period | 67.6718% | £95.56 | £0.00 | +£95.56 | £3,413.61 | £13,000.00 | -£9,586.39 |
| 34, outside selected period | 66.425% | £93.80 | £0.00 | +£93.80 | £3,507.41 | £13,000.00 | -£9,492.59 |
| 35, outside selected period | 65.2012% | £92.07 | £0.00 | +£92.07 | £3,599.48 | £13,000.00 | -£9,400.52 |
| 36, outside selected period | 64% | £90.37 | £0.00 | +£90.37 | £3,689.86 | £13,000.00 | -£9,310.14 |
Page forecast
1 pages in this model.
| Page | Extra clicks | Revenue | Gross profit | Allocated cost | Net contribution |
|---|---|---|---|---|---|
| Example service page/services/ | 363.48 | £2,453.52 | £981.41 | £13,000.00 | -£12,018.59 |
| All pages in scope | 363.48 | £2,453.52 | £981.41 | £13,000.00 | -£12,018.59 |
Investment is allocated equally across the listed keywords for this breakdown. Page costs sum their keyword shares; this is not an itemised delivery quote. Totals use unrounded values, so displayed row amounts can differ by a few pence.
Keyword forecast
2 keywords in this model.
| Keyword | Current → case rank | Extra clicks | Revenue | Gross profit | Allocated cost | Net contribution |
|---|---|---|---|---|---|---|
| example serviceGB / all devices | 12 → 6 | 281.47 | £1,899.96 | £759.98 | £6,500.00 | -£5,740.02 |
| example service costGB / all devices | 18 → 8 | 82.01 | £553.57 | £221.43 | £6,500.00 | -£6,278.57 |
| All keywords in scope | 363.48 | £2,453.52 | £981.41 | £13,000.00 | -£12,018.59 |
Investment is allocated equally across the listed keywords for this breakdown. Page costs sum their keyword shares; this is not an itemised delivery quote. Totals use unrounded values, so displayed row amounts can differ by a few pence.
Read the scope and modelling limits
2 keywords across 1 pages. Countries: GB.
- Ranks are manually supplied planning targets. SEO spend and activities do not mechanically predict positions.
- Planning cases vary inputs; their labels do not imply probabilities or confidence intervals. Rank multipliers scale declines too, so cases are not guaranteed to appear in label order.
- Historical workbook baseline: Backlinko/Semrush 2023 aggregate CTR for positions 1–10. It is not a current market, device or country-specific prediction.
- Positions 11–30 are agency extrapolations; >30 to 100 uses the editable tail CTR; >100 is zero.
- Legacy agency planning curve, not a curve measured by Google. The shape requires calibration to the campaign.
- Investment is allocated equally across listed keywords for breakdowns; it is not an itemised delivery quote.
- Forecasts omit seasonality, competitor/algorithm changes, query overlap and demand changes. Summed keyword volumes may overlap even after exact intent deduplication.
- Payback is checked through month 36, including months beyond the selected reporting period; sustained payback is only sustained within that modelled horizon.
- When no investment is incurred, ROI, break-even and sustained payback are not applicable; first positive cashflow is still reported.
- Scenario conversion rates are capped at 100%; forecast clicks are capped between zero and the entered monthly search volume.
- The entered annual retention factor reduces the incremental run rate after engagement ends; it is a planning assumption.
Keyword ledger
Each keyword, country and device combination belongs to one primary landing page.
Monthly search volume is an input, not observed site traffic. Ranks 1–1000 are accepted; ranks above 100 receive zero CTR. Targets can improve or worsen.
Use GB for the United Kingdom. An all-device row must not overlap desktop or mobile rows for the same keyword and country. Exact duplicates are blocked; related search terms may still overlap.
Landing pages and page economics (1)
Page names and URLs can change without losing keyword assignments.