DIY SEO Audit Template: The Complete Step-by-Step Checklist for Small Businesses
Running a professional SEO audit used to mean hiring an agency for thousands of dollars — or running a scanner that spits out a meaningless “72/100” with zero explanation. This DIY SEO audit template is the third option: a complete copy-paste checklist any small business owner can finish in about 90 minutes with free tools. No coding, no subscriptions, no vague scores — every check tells you what to look at, what “good” looks like, and how to verify the fix. Below: five audit modules — technical, indexation, on-page, content, off-page — plus a prioritization matrix, a free-tool stack, and the seven mistakes that ruin DIY audits. Grab a spreadsheet, open this DIY SEO audit template, and let’s begin. Before You Start: Set Up Your DIY SEO Audit Template Workspace An audit without a baseline is sightseeing. Before touching a check, record where your site stands today — otherwise you’ll never know which fix moved the needle. Step 1 — Gather access. You’ll need Google Search Console (free; verify domain ownership), your CMS login, and Google Analytics or any traffic tool you use. No Search Console yet? Set it up first — the indexation module of this DIY SEO audit template depends on it. Step 2 — Open a spreadsheet. Copy each module table below into its own tab, and add four columns to every row: Status (Pass / Issue / Critical / Not checked), Finding (the exact evidence), Priority (P1–P3, assigned later), and Owner. Step 3 — Record your baseline. In a separate tab, note your preferred canonical URL version (www vs. non-www, https), your 5–10 most important pages, your primary keywords, and current monthly organic clicks from Search Console. One-sentence verdict: “We get X clicks/month; the goal is Y.” Step 4 — Adopt the evidence rule. Every finding must be verifiable: a command output, a Search Console screenshot, a measured number. “Titles seem short” isn’t a finding; “Homepage title is 78 characters and truncates” is. The “How to verify” column builds this into every row. The Complete DIY SEO Audit Template, Step by Step Work the five modules of this DIY SEO audit template in order: fix access and indexing before polishing copy, and content before chasing backlinks. A beautiful page Google can’t reach is worth nothing. Module 1 — Technical & Crawlability Technical SEO is the foundation. This first module of the DIY SEO audit template answers one question: can search engines reach, read, and render your pages? These checks come first because nothing else matters until they pass. Check What “good” looks like How to verify robots.txt Allows important pages; doesn’t block CSS/JS/images Visit yourdomain.com/robots.txt in a normal browser tab — not with cache-busting parameters, which can hide a stale cached copy XML sitemap Exists, lists only indexable canonical URLs, submitted to Search Console Check yourdomain.com/sitemap.xml; confirm “Sitemaps” report in Search Console shows success HTTPS Entire site loads over https with no mixed-content warnings Check the padlock icon on several page types No accidental noindex Important pages have no “noindex” directive View Source on key pages, search for “noindex”; check SEO plugin settings Redirect chains No page requires more than one redirect hop to reach its final URL Run a free redirect checker on old URLs and homepage variants Broken links (404s) No internal links point to dead pages Search Console → Pages; or free Screaming Frog crawl (500 URLs) Canonical tags Each page has a self-referencing canonical pointing to its preferred URL View Source on sample pages, search for rel=”canonical” Mobile rendering Content, navigation, and CTAs all work on a phone screen Test homepage + one service page on your actual phone Core Web Vitals Real-user field data in the “Good” range for LCP, INP, CLS PageSpeed Insights on top 3 pages; read field data, not lab score Module 2 — Indexation Being crawlable isn’t the same as being indexed. This short DIY SEO audit template module confirms Google actually stores your pages — a step beginners skip and agencies charge for. Check What “good” looks like How to verify Indexed page count Roughly matches your real page count (not 10x more, not near zero) Google “site:yourdomain.com” and compare the result count to your actual pages URL Inspection Key pages show “URL is on Google” with the correct canonical Search Console → URL Inspection per key URL Coverage errors No “Excluded” or error spikes in the Pages report Search Console → Pages; investigate “Crawled – currently not indexed” on key pages Duplicate versions Only one version (www or non-www, https) is indexed site: search — indexed URLs should use one consistent format Stray indexed junk No tag archives, internal search pages, or staging URLs in the index Same site: search; noindex any thin or irrelevant URLs found Module 3 — On-Page SEO With the foundation solid, the on-page module of your DIY SEO audit template checks whether each page clearly tells visitors and Google what it’s about. Audit your homepage plus your 3–5 most important service or product pages — not every blog post. Check What “good” looks like How to verify Title tag Unique per page, describes the page accurately, keyword near the front, under ~60 characters Read each page’s browser-tab title; check truncation with a free SERP preview tool Meta description Unique, reads like an ad for the page, includes the keyword, ~150–160 characters View Source or a meta-tag checker; confirm no duplicates across pages H1 heading Exactly one per page, matches the page’s topic, visible to users Scroll each page; if you can’t spot one clear headline, neither can Google Heading structure H2s and H3s form a logical outline a reader could scan Use a free headings-outline extension; read the outline cold URL structure Short, readable, hyphenated words; no parameters or random IDs Read URLs aloud; if gibberish, fix with 301 redirects Image alt text Every meaningful image has descriptive alt; decorative images have empty alt Alt-text checker on one page; spot-check the rest Internal links Each key page is linked
How to Write an SEO Content Brief That Writers Actually Follow
An seo content brief is the single highest-leverage document in a content operation — yet most of them fail before a writer ever types a word. They arrive as a keyword dump, a vague title suggestion, and a word-count target, and the writer is left to guess at search intent, angle, and structure. The result is predictable: drafts that need heavy rewrites, pages that miss intent, and rankings that never arrive. This guide shows you how to write an SEO content brief that writers actually follow, with the exact sections, a real-world example, and the mistakes that send most briefs straight to the trash. What Is an SEO Content Brief? An SEO content brief is a structured document that tells a writer exactly what a page needs to achieve. It bridges the gap between your keyword strategy and the final draft by defining the target keyword, search intent, audience, working title, outline, internal links, proof requirements, and the business goal the content serves. It is not a keyword list. A keyword list tells a writer what terms to sprinkle in. An seo content brief tells them what the searcher is trying to accomplish, what page type will satisfy that intent, and what the article must cover to compete with the pages already ranking. That distinction is what separates content that ranks from content that just exists. Think of the brief as a contract between strategy and writing. The strategist promises to do the research — the SERP read, the intent analysis, the gap finding — so the writer never has to. The writer promises to follow the spec. When both sides hold up their end, the first draft arrives close to publish-ready, review cycles shrink, and every article ships with SEO baked in rather than bolted on. Why Most SEO Content Briefs Get Ignored Before fixing the format, it helps to understand why writers quietly ignore most briefs. If you have ever received a draft that felt like it was written for a completely different assignment, one of these failures is usually the cause. The brief is too thin. A target keyword and a 2,000-word target tell a writer almost nothing. Without intent guidance, the writer guesses — and guesses default to generic. The draft covers everything shallowly instead of the one thing deeply, because nobody told the writer which one thing matters. The brief is too rigid. The opposite extreme is just as bad. A 40-row spreadsheet of keyword density targets, exact-match anchor quotas, and sentence-level instructions turns a skilled writer into a formatter. Good writers stop reading rigid briefs and write whatever feels natural — which is exactly the opposite of what the strategist wanted. The brief is research-free. When the brief contains no SERP analysis, the writer must do the strategist’s job on a writer’s budget. They will not open the top five results, map the subtopics, and identify the gap. They will write from memory and intuition. The page will resemble nothing that ranks. The brief has no point. Many briefs never state what the page should make the reader do — subscribe, book a call, visit a service page, or simply stay and read. A page with no defined job reads like a page with no defined job. Every brief needs a primary action, even if that action is just “keep reading the next section.” The sweet spot sits between these failures: specific about outcomes, flexible about expression. An seo content brief should answer every question a writer would otherwise ask in a meeting, and nothing more. Let us build one. The 9 Sections Every SEO Content Brief Needs A complete seo content brief contains nine sections. Each earns its place by preventing a specific, common failure. You can scale the length of each section to the writer’s experience — a senior writer needs three sentences where a junior needs a paragraph — but skipping sections is what creates rewrite cycles. 1. Target keyword and secondary terms State one primary keyword — the single query this page exists to rank for. Add three to five secondary keywords or natural variants the writer should weave in where they genuinely belong. Avoid density targets; telling a writer to use a term “8-10 times” produces awkward prose that reads badly and performs worse. The primary term belongs in the title, the opening, and at least one heading. Everything else is natural placement. 2. Search intent and page type Read the intent off the SERP, never assume it. Tell the writer what the searcher is trying to do — learn, compare, buy, find a tool — and what page type the SERP demands: a how-to guide, a listicle, a comparison, a product page. This one field prevents the most expensive mistake in content production: writing an article when the SERP wants a tool, or a service page when the SERP wants a guide. For a broader look at how search demand is shifting, read our guide on how to rank in Google AI Overviews, where intent matching matters even more than it does in classic results. 3. Working title Give the writer a working title that includes the primary keyword and stays under roughly 60 characters. Mark it clearly as a starting point, not a mandate — let the writer improve it. A suggested title anchors the piece without handcuffing the writer’s creativity, and it gives the review stage a baseline to judge the final title against. 4. Meta description draft Draft a 150–160 character meta description that includes the keyword and a reason to click. Writers and editors routinely forget meta descriptions until publish day, then write something rushed. A brief that arrives with a strong draft in place saves that scramble and usually produces a better click-through result than a last-minute effort. 5. Audience and angle Define the reader with uncomfortable specificity: job title, company size, expertise level, and what they already know. “SEO managers at mid-size SaaS companies who have published 50+ articles” beats “marketers.”
How to Fix Content Decay: Find & Refresh Dying Pages
Even your best-performing pages have an expiration date. One quarter a guide sits comfortably at position two and drives hundreds of visits a week; two quarters later it has slid to the bottom of page two and the traffic has quietly evaporated. This guide shows you how to fix content decay before it erodes your organic revenue — from spotting the first warning signs in Google Search Console to running a repeatable refresh playbook that wins rankings back. Content decay is the gradual decline in rankings, clicks, and engagement that aging pages experience as competitors publish fresher resources, search intent shifts, and facts go stale. It is not a penalty, and it rarely means the page was bad. It simply means the web moved on while the page stood still. The encouraging news is that pages which already earned authority usually recover faster than brand-new pages rank, which makes fixing content decay one of the highest-return activities in SEO. Refreshing what you own is almost always cheaper than building from zero. What Content Decay Really Looks Like True content decay is a slow bleed, not a cliff. The classic signature is a page whose average position drifts from 4 to 9 to 15 over six to twelve months while impressions hold reasonably steady and clicks fall off. That pattern tells a specific story: Google still considers the page relevant enough to show, but searchers are choosing someone else, and the algorithm is gradually losing confidence in it. Recognizing this signature early is the first step in knowing how to fix content decay before revenue slips away. That slow bleed is different from three problems that only look like decay. A sudden 40% drop overnight is usually an algorithm update or a technical issue, not aging content. A traffic dip that repeats every year at the same time is seasonality — your swimsuit guide does not need a rewrite in October, it needs patience. And clicks falling while positions hold steady usually means a SERP feature, such as an AI Overview or a featured snippet, is intercepting the click rather than your content failing. Treating any of these as content decay leads to wasted rewrites, so diagnosis comes before action. Separating true decay from its lookalikes is the first skill in learning how to fix content decay without burning your content budget. Why Pages Decay: The 6 Root Causes Content decay always has a cause, and naming the right one determines the right fix. These six account for nearly every case we see in audits: Stale facts and statistics. A post citing 2022 data in 2026 reads as unreliable to both readers and ranking systems. Studies, pricing, screenshots of retired interfaces, and year-specific claims age fastest. Search intent drift. A query that wanted a simple definition two years ago may now expect a comparison table, pricing breakdown, or step-by-step tutorial. If the SERP changed format and your page did not, that mismatch alone can bleed positions. Stronger competition. A rival published a deeper, better-structured, more current resource on the same topic. You did not get worse; the bar got higher. Coverage gaps. Your page answers the original question but ignores the follow-up questions searchers now ask — the ones visible in People Also Ask boxes and competitor headings. Weak internal support. The page stopped receiving fresh internal links from newer content, so crawl priority and authority flow quietly dried up. Eroding trust signals. Broken outbound links, thin author credentials, and outdated design make both users and search engines hesitate. How to Fix Content Decay Starts with Accurate Diagnosis Before touching a single paragraph, confirm the page is actually decaying. Open Google Search Console, select the page, and compare the last three months against the previous three. Decay is confirmed when you see the average position fall by roughly three or more places, or clicks fall by 30% or more while impressions stay flat or decline more slowly. Pages ranking in positions 4 through 20 for keywords with real search volume deserve special attention — they sit in striking distance, where a refresh can pay off quickly. This careful diagnosis is what separates teams that know how to fix content decay from teams that just rewrite at random. Next, rule out the impostors. Check whether the decline aligns with a known algorithm update, whether the pattern repeats seasonally year over year, and whether clicks dropped while positions held — that last pattern points to AI Overviews or snippets absorbing clicks, a problem that needs a different answer. Our guide on how to rank in Google AI Overviews covers that scenario in detail. Only when position loss and click loss move together should you commit to a full refresh. How to Find Dying Pages in Google Search Console You do not need expensive software to run a decay audit. Search Console’s Performance report is the best free decay detector available. Follow this process once a quarter: Open the Performance report and set the date range to the last 6 months, then enable the comparison against the previous 6 months. Click the Pages tab and sort by the click difference column so the biggest losers rise to the top. Ignore pages with tiny baselines — a page that fell from 10 clicks to 5 is noise, not decay. Focus on pages that once earned meaningful traffic. Switch on the average position metric and flag pages whose position dropped 3+ places alongside the click decline. Export the list and add a column for page age and last meaningful update date. Anything untouched for 12+ months in a fast-moving topic is a prime suspect. Cross-check the top candidates against seasonality: compare the same months year over year before labeling anything as decay. Prioritize by traffic-loss multiplied by ease of fix. A page that lost 2,000 monthly clicks and needs a facts update beats a page that lost 50 clicks and needs a total rewrite. This simple process routinely surfaces a dozen pages with genuine recovery