The cells, and which ones you are not allowed to invent
| Cell | Source | Teaching fill, not a result |
|---|---|---|
| URL | You | ledgerline.example/renewals |
| Clicks, last 28 days | Search Console export, dated | 400 |
| Clicks you will credit to new links | You, and you must be able to say why this slice | 50 |
| Value per credited click | Your close rate or your ad cost, written down | $3 |
| Placement | A catalog cell | SAAS-109 guest post, $179 |
| Credited value in a month | 50 × $3 | $150 |
| Months of that value to cover this one placement | 179 / 150 | 1.2 |
400, 50, and $3 are suppose. They are not measurements from a ChainEpic customer. $179 is a real cell on SAAS-109 in the catalog shipped with this site. The 1.2 months is what those suppose numbers do to that cell. If your export says 80 clicks and you cannot defend crediting more than 10 of them, the months number gets worse and the order might come off. That is the sheet working. A sheet that only gets happier as you edit the suppose line is a pitch.
Why the credited clicks have to be a slice
The 400 clicks are already happening without this order. Attributing all 400 to a link you have not placed is how a $179 purchase 'returns' in a week on paper. The 50 is a ceiling you choose for the upside you are willing to bet. Write the reason next to it. Acceptable reason: the queries you saved are the ones this comparison article could plausibly touch, and those queries are a slice of the 400. Unacceptable reason: 50 made the months look short. If you cannot write the reason, leave the cell blank and do not describe the order as ROI. Buy it only if you have another reason, such as a mention you would want even with rel="sponsored", which is the test in the boundary article.
Brand queries stay off this sheet. A guest post can make people search the name. That is a mention effect. Add a separate line if you want to watch it. Do not add those clicks into the 50. The AI search guide uses the same split. Assisted revenue stays off unless the analytics view already ties it to this URL. A revenue column you cannot filter is how the teaching $3 becomes a case study you did not run.
The same sheet deletes TECH-107
Swap the placement cell to TECH-107 at $349. Months become 349 / 150, about 2.3, and only if the 50 clicks arrive and only if you were right to credit them. You also still need a news peg, which decision A in the two-row piece says Ledgerline does not have. Two independent reasons to delete the row: the months are a longer bet than you wanted, and the publication does not match. Either reason is sufficient. Teams keep the row because DR is 76 and then use the sheet to decorate the decision. Fill the sheet first. Delete second. Open the cart third.
Four guest posts at the median, which the calculator fills from whatever rows are loaded now, is a different bet again. The calculator multiplies your count by your unit price and divides by the monthly value you type. It does not know about news pegs. After it gives you a number of months, you still run the topic sentence. A short months figure on the wrong niche is a fast way to waste the smaller bill.
What you do with the sheet on day 90
Export the same URL, the same 28-day window. Put the new clicks next to 400. If they are 430, you write 430. You do not convert the change into a percentage for a headline. If they are 360, you look at whether the page title changed before you buy anything else. That is the filled log in the update article. The sheet's job was to stop you promising 1.2 months as a fact. The export's job is to replace the suppose line with a number you can point at. Until the export exists, the campaign plan's rule stands: say you do not have the after number yet.
Sensitivity belongs on the sheet before you order, not as a regret. If you only dare credit 20 clicks at $3, monthly value is $60. SAAS-109 at $179 takes about 3 months of that value, not 1.2. TECH-107 at $349 takes about 5.8. Neither figure is a forecast. Both are what the suppose line does when you stop being generous. If the order only feels fine at 50 credited clicks, you do not yet have a reason. Shrink the credited number until it feels slightly pessimistic, then see if the row survives. Rows that survive only the optimistic cell are the ones to delete.
FAQ
What if I do not know a value per click?
Leave it blank. Do not borrow $3 from this page. Without a value you can derive, do not justify the order as ROI. Use the mention test instead, or do not buy.