← Blog
Posts

Copy this content audit template and give each fact its own row

A one-tab spreadsheet for a young B2B blog, with one row for every price, plan, feature, date and number your posts state, and a rule for when to run it again.

Ghaith Ayadi · 14 Nov 2026 · 6 min read

We've laid the sheet out below. Copy it into a blank spreadsheet, name the tab "Facts" and keep traffic numbers out of it for now.

Post URL Sentence that states the fact Fact type Source of truth Owner Last checked Still true Fix

The first column holds the post's address. In the second you paste one sentence, word for word, stating something anyone could check against reality. Fact type takes one of five labels (price, plan name, feature status, date or number), and it exists so the sheet can be filtered later. Source of truth names the page outside the blog where that fact is kept current. Owner is the person who would know first if it changed. Last checked records the day somebody compared the sentence with its source. Still true takes yes, no or unsure. And in the fix column you write the replacement sentence out in full, ready for whoever edits the post to paste in.

A post goes wrong one sentence at a time

The content audits that agencies sold through the 2010s were lists of pages. Each URL got a row, then a title, a word count, a traffic figure and a verdict of keep, update or cut. Agencies used that format to list what the site held, the way a librarian would. The list never showed which sentence had gone bad, and whoever got the verdict "update" had to reread a 2,000-word post in the hope of spotting the problem.

Here a post that names three prices gets three rows. If one of those prices changed and the other two held, you mark one row no and two rows yes, and the fix takes a minute. We think the fact is the right unit for a young blog, since you remember what your company charges far better than what you wrote about it in an old post. Facts are also where a stale blog does its damage. An old opinion ages into a period piece that readers forgive. An old price ages into an awkward first call with a prospect who quoted it back.

Read each post once and copy out the facts

Filling the sheet takes one pass through the blog in publishing order. Read each post once and paste out every sentence with a price, a plan name, a feature, a date or a number. Skip the opinions and the jokes. For a blog of a few dozen posts you'll spend an afternoon on it, and you'll have to fight the urge to rewrite paragraphs on the way through. Rewriting can wait.

Here are three rows as they would look for a post about our own product.

Post URL Sentence that states the fact Fact type Source of truth Owner Last checked Still true Fix
/blog/example-post "Propaganda has a paid plan, and the current price lives on the pricing page.." Price Our pricing page Whoever sets prices Date of this pass Yes None needed
/blog/example-post "Propaganda Light is free.." Plan name Our pricing page Whoever sets prices Date of this pass Yes None needed
/blog/example-post "Propaganda sends every post to your newsletter list." Feature status Our product page Whoever owns the roadmap Date of this pass No "A newsletter module is planned. Today posts go to the blog."

In the first row we quoted our paid plan and pointed at the pricing page, which is where the price would change first. The third row is the sentence that slips into a launch post when somebody describes the roadmap in the present tense, so mark it no and write a fix that states what is true today.

The source of truth lives somewhere other than the blog

The whole method rests on the fourth column. When a row points back at the post itself, you can only confirm that the sentence matches itself, which is a low bar even by marketing standards. So you need a source page that somebody updates when the business changes, such as a pricing page, a changelog, the docs or a contract template.

Sometimes there is no such page. If one of your posts mentions a rollout date, a usage limit or a customer count, go looking for where that figure lives, and you may find it in the post and nowhere else. Write "none" in the source column and leave the row open. We think those rows are the most valuable in the sheet. They mark facts that entered the company's public record through a draft written in a hurry, and nobody has owned them since. Then you, or the owner named in that row, decide where the fact belongs. Often it gets a proper home on the pricing page or in the docs. Sometimes nobody can vouch for it, and you delete the sentence. We'd rather lose a sentence than keep a number with no parent.

Run it again when a price changes

The first time a price moves, the sheet pays back the afternoon it took to build. Once you filter the fact type column to price and search the sentence column for the old figure, every sentence that ever quoted it comes back in one list, which is a slightly grim thing to read when the figure has been wrong for a while. After those rows are fixed and the last checked date is updated, the job is done before lunch. You can handle a renamed plan the same way, and a feature that has moved from beta to shipped. Whoever made the change should run the filter, because nobody else knows it happened.

A quarterly pass catches what slipped through. Other facts drift without anyone touching them. Dates pass, numbers age, and third-party APIs get retired by the companies that run them. Once a quarter, sort by last checked with the oldest first and recheck anything older than ninety days against its source. New posts add their rows on the day they publish. That habit keeps the sheet from going the way of the brand book, which was written with great care, admired at launch and never opened again.

Traffic numbers go on their own tab

Traffic and backlinks still belong in the audit, on a second tab. Paste in visits, time read, inbound links and the search each post targets, and use that tab to decide which posts stay, which merge and which get cut. You use the fact tab for a different job. On one tab you choose which posts deserve to exist, and on the other you pick which sentences in them need fixing. When the two lived in one sheet, audits grew to forty columns, and the wrong price sat three screens to the right of the traffic figure where no one scrolled.

Run the traffic tab first. Fixing the price in a post you were about to delete is a fine way to spend a Friday if the goal is to feel busy.

Big sites start with a page inventory

This template stops working somewhere past a few hundred posts. On a site with thousands of URLs, a fact-level pass would take weeks, and most of the rows would sit on pages nobody has read since they went live. So you go back to the old method. Crawl the site with a tool like Screaming Frog, list every URL with its traffic and page type, and run the page-level inventory the agencies always ran.

Then fact-audit only the pages a buyer reads before paying, such as the pricing page, plan comparisons, feature pages, the posts that rank for the searches buyers make and the help articles sales sends to prospects. Even on a big site that list usually runs to a few dozen pages, which brings the job back down to an afternoon or two. The other thousands can stay in the inventory, judged by traffic, until one of them starts selling.

You can automate the filter step later. Until then, do the same job by hand in this spreadsheet, and for a blog of a few dozen posts it works well.