You published dozens of posts and service pages over the last two years. A few posts earn steady traffic each month. The rest of your pages sit quietly on your server. You know you need to fix the quiet pages. You open a spreadsheet to start a website content audit. You immediately face a long list of links. You spend hours staring at the screen. You wonder if you should rewrite the oldest posts first. You lack a clear rule to decide which page goes first.
Most guides tell you to export your analytics data. The standard method from a web agency looks at pageviews and time on page. You sort the list by content type. You color code the outliers. You decide to keep, merge, revise, or remove the page. You follow the steps and get a tidy list. The list rests on pageviews alone. The data shows what people did after they arrived. The report holds no information about the pages that never earn a visit.
We order the rewrite list by impression data. The sequence below is the one we use.
Start your website content audit in Search Console
The traditional web agency method misses the most valuable pages on your site. A page with zero visits looks like a total failure in your analytics software. That same page might sit on page two of the search results. People search for the target query. Google shows your link to them on the results screen. The searchers see your title and scroll past you. The page has impressions. The page has zero clicks. Your analytics software holds no record of this event.
You must start your website content audit in Google Search Console. You need to pull the query data for your entire site. You export a list that shows the position, the impressions, the clicks, and the URL for every page. This document becomes the foundation of your work. The columns in this export determine your priorities.
You sort the data to find your first target. You look for pages ranking at position eight to twenty. Position eight means you sit near the bottom of page one. Position twelve puts you near the top of page two. You filter for pages with hundreds of impressions and zero clicks. A page in this range is your first rewrite. Google already ranks the page for the query. The rank shows that the text aligns with the user intent. The users simply refuse to click. You only need to fix the title and the opening text to win those missing visits.
Your second priority is a page at position forty with impressions. A page at position forty appears on page four of the search results. People rarely click anything on page four. The impressions prove that the topic has search volume. Google sees some relevance in your text. The main body of this page requires heavy work. The body needs the query answered in the first screen. You must restructure the headings to match the exact search terms. We run this check for our SEO clients to find pages trapped on page four. We rewrite the text to pull the URL onto page one.
A page with zero impressions is your last priority. Nobody searches for the terms on the page. The search algorithm refuses to show the URL to anyone. These pages drag your site down. You deal with the zero impression pages at the end of your project.
The check: Sort your exported data by impressions to find pages ranking between position eight and twenty with zero clicks.
The four fields the rewrite changes first
Your top priority pages sit between position eight and twenty. You already established that Google accepts the core text. The search engine places the URL near the top of the list. The problem happens on the search results screen. The user looks at your listing and chooses a competitor. You must fix the presentation.
You change four specific fields first. You rewrite the title. You rewrite the meta description. You rewrite the H1 header. You rewrite the first two paragraphs.
The title and the meta description control your appearance in the search results. The title must carry the exact query. The title must offer a clear answer. The meta description expands on the title. A weak meta description repeats the title or cuts off in the middle of a sentence. A strong meta description captures the user click. You write a complete thought under 155 characters. You remove passive language. You add active verbs.
The H1 header and the first two paragraphs control the user experience after the click. A user clicks your new title. The user arrives on your page. The user immediately looks at the H1 header to confirm they landed in the right place. The H1 must align with the title tag. The first two paragraphs must confirm the promise. Writers often waste the first two paragraphs on background information. The reader hits the back button when the answer takes too long. You must delete the fluff. You state the problem clearly. You provide the short answer immediately.
You update these four fields. You leave the main body text alone. The main body already earns a high rank. You do not want to disrupt the core relevance of the document. We focus entirely on these four fields when we handle a position ten page for a client. We change the hook to capture the existing traffic.
You must handle the published date carefully. A content management system often updates the published date automatically when you hit save. You should change the date on the page only when the main body changes. A new title and a new meta description do not justify a new date. A reader expects fresh information when they see today’s date. A cosmetic update fails to meet that expectation. You manually preserve the original published date when you only fix the four top fields.
The decision: Update the title, the meta description, the H1, and the first two paragraphs for your highest priority pages.
When to merge and remove during the check
Pages with zero impressions go to the bottom of the list. You eventually reach these URLs after you fix your ranking pages. Here the decision is merge or remove.
You often find two pages targeting the same query. You wrote a service page about a topic last year. You published a blog post about the exact same topic last month. The two pages compete against each other. Two pages on one query split the ranking. You confuse the search algorithm when you publish multiple pages on one topic. The URLs swap places in the index every week. Neither page earns a high position.
You must merge these competing pages. You identify the weaker page based on total history. You move the useful text from the weaker page over to the stronger page. You set up a redirect from the weaker page to the stronger page. A redirect works as a permanent forwarding address. A visitor clicks a link to the old URL. The server automatically sends them to the new combined page. The weaker page disappears from your site. The combined page moves up in the rankings.
Sometimes you find a page with zero impressions and zero useful text. The topic holds no value for your current business. The page targets an obsolete service. You remove this page entirely. You delete the URL and let the server return a standard error code. Removing useless pages focuses your site structure. A smaller site with high relevance performs better than a massive site filled with dead text. We clean out dead pages regularly as part of our SEO and website content service.
The decision: Merge competing pages by redirecting the weaker URL to the stronger URL.
What the audit spreadsheet holds per row
You need a central document to track your progress. A simple text file fails to organize the project. You must build a formal audit spreadsheet. The spreadsheet brings order to the chaos of a large website. You share this document with your team to establish the exact priority order.
You create one row for every URL on your site. You define eight specific columns. The columns are URL, target query, position, impressions, clicks, the decision, the owner, the date done.
The URL column holds the exact address of the page. The target query column lists the primary search term. You check the target query column before you write a new post to prevent future overlaps. The position, the impressions, the clicks, and the URL columns hold your data from Google Search Console. You update these four metrics right before you start a new phase of rewrites.
The decision column determines the next action. You enter keep, merge, remove, or rewrite in this field. A content marketing consultant reviews this column to understand the scope of the project. The keep designation means the page performs perfectly. The rewrite designation flags the page for immediate work based on your sorted data.
The owner column assigns the task to a specific person. A blank owner column means the work never happens. You put a name in every row marked for a rewrite. The assigned person takes responsibility for the title, the meta description, the H1, and the paragraphs.
The date done column tracks your momentum. You record the exact date you publish the revisions. You use this column to measure your results. You wait four weeks after the date done. You then check Search Console to see the new impression and click totals.
The check: Create an eight column spreadsheet to track the URL, the data, the decision, and the owner for every page.
The cadence for monthly checks and updates
A website content audit is never a one-time project. Search behavior changes constantly. Competitors publish new pages that push your URLs down the list. A page that earns clicks today might fall to position twenty next year. You need a regular cadence to defend your traffic.
The audit runs each month on the pages that lost clicks. You pull a fresh export from Search Console. You compare the new click totals to your previous spreadsheet. You identify the pages sliding down the rankings. You add these declining pages to your rewrite list. You catch the problem before the page drops to page four.
A massive list of broken pages paralyzes a marketing team. You abandon the project when the scope feels impossible. You avoid this failure when you limit the work. Two rewrites a month keep the site moving beside new posts. You assign one person to handle these two updates. The workload remains manageable. You build a habit that recovers lost traffic steadily. A good content strategy consultant plans the calendar to balance fresh topics with necessary repairs.
We run this audit for our SEO clients. We manage the spreadsheet and track the data. We do the rewrites as website content work. Our team handles the titles, the meta descriptions, the body text, and the redirects. We monitor the results in Search Console over the following weeks. The monthly report shows each rewritten page before and after. You see the exact impact of the ordered list on your traffic.
The check: Schedule two page rewrites every month to repair URLs that lost clicks.
Let us build your ordered rewrite list
You know valuable pages sit trapped on page two of the search results. You know you miss your best opportunities when you use the standard analytics method. You have the rules to find the pages with high impressions and zero clicks. You know exactly which four fields to change first.
We build this list for you. Send us the site and we return the ordered rewrite list in the free consultation. Ask for it. You provide access to your Search Console. We run the check. We return the exact sequence of pages you need to fix. We handle the monthly rewrites for you. Call +1 501.232.1017 to book your consultation today, or visit our contact page to send us your details.
The decision: Call our team to request your free ordered rewrite list.