Keyword Audit: How to Match Search Queries to the Right Pages

Quick Answer
A keyword audit examines the search queries your website already appears for and checks whether the right pages are targeting them. Use Google Search Console to compare queries, ranking URLs, clicks, impressions, click-through rates, and average positions. Then identify mismatches, investigate overlapping pages, and decide whether to keep, improve, consolidate, reassign, or create content. The goal is a useful action plan, not simply a longer keyword spreadsheet.
Key Takeaways
- A keyword audit evaluates your existing organic search performance, rather than simply finding new keywords.
- Google Search Console provides first-party information about queries, pages, clicks, impressions, CTR, and average position.
- Compare the URL actually appearing in search results with the page you intended to target.
- Multiple pages appearing for one query do not automatically mean harmful keyword cannibalization.
- Prioritize meaningful search-intent mismatches and business opportunities rather than arbitrary ranking thresholds.
- Record every decision and review performance again after making changes.
What Is a Keyword Audit?
A keyword audit is a systematic review of the relationship between a website's existing search queries and its pages.
It helps answer several practical questions:
- Which search terms already bring people to the website?
- Which pages appear for those searches?
- Are those pages relevant to what visitors want?
- Are multiple pages targeting essentially the same search intent?
- Are important queries associated with the wrong pages?
- Should an existing page be improved, replaced, consolidated, or left alone?
Consider a company that provides commercial cleaning services. Its website contains separate pages for office cleaning, industrial cleaning, and residential cleaning.
A keyword audit might reveal that its office cleaning page receives impressions for searches related to industrial cleaning. That observation does not automatically mean the page is broken. However, it raises an important question: does the page adequately address the industrial cleaning searcher's needs, or should another page serve that audience?
The audit helps the company investigate the situation before changing its website.
Keyword audit vs. keyword research vs. keyword optimization
These activities are related, but they solve different problems.
| Activity | Main question | Typical outcome |
|---|---|---|
| Keyword research | What should people search for, and which topics are relevant? | A list of potential keywords |
| Keyword audit | Which existing queries and pages are working, and what needs attention? | A prioritized page and keyword action plan |
| Keyword optimization | How should a particular page be improved for its intended topic? | Better-aligned page content and structure |
| Rank tracking | Where does a website appear for selected searches? | Ranking observations and performance reports |
For example, a keyword research project might identify opportunities related to commercial cleaning prices. A keyword audit determines whether an existing page already addresses those searches and whether its current targeting makes sense.
If you need a broader review of website health, see Google SEO Checklist: Audit Your Site and Fix What Matters. A keyword audit is a narrower exercise focused on existing organic search queries and page assignments.
What Data Do You Need Before Starting?
The most useful starting point is Google Search Console, Google's free platform for monitoring how a verified website performs in Google Search.
Its Performance report provides information about the queries associated with your website and the pages appearing in search results.
You should understand four important measurements before interpreting the results.
| Metric | What it tells you | How to use it |
|---|---|---|
| Clicks | How many clicks your website received from Google Search results | Identify queries and pages attracting visitors |
| Impressions | How often your website appeared in search results | Discover existing search visibility and potential opportunities |
| CTR | The percentage of impressions that resulted in clicks | Investigate whether search-result presentation and relevance deserve attention |
| Average position | The average position of your website's topmost result for the relevant reporting data | Understand broad visibility trends alongside other metrics |
CTR means click-through rate. For example, if a page receives 100 impressions and 5 clicks, its CTR is 5%.
Average position requires more careful interpretation. It is an average measurement, not a promise that your page appears in exactly the same position for every person or search.
Google explains these measurements in its Search Console Performance report documentation.
Set up a consistent reporting period
Open Search Console and select the verified website property you want to investigate.
Before exporting information, establish a consistent reporting context:
- Select the appropriate search type, usually Web.
- Choose a date range long enough to provide meaningful observations.
- Apply the United States country filter if your main audience is American.
- Review the available device information when mobile and desktop behavior may differ.
- Keep the same property, search type, filters, and observation period when comparing different reports.
The Performance report normally opens with a three-month period, but you can change the date range.
For an initial audit, a recent 90-day period can provide a useful starting point. Compare it with an earlier equivalent period when you need to understand whether performance is changing.
Do not compare two reports with different date ranges or filters and assume that their figures are directly equivalent.
Understand the limitations of Search Console data
Search Console is valuable because it provides first-party information about your own website. However, its reports are not a complete record of every search performed by every user.
Google omits anonymized queries from the query table for privacy reasons. Reporting row limits also mean that not every query necessarily appears in an exported report.
Another important detail concerns canonical URLs. Google may aggregate performance information under a canonical URL rather than showing every URL variation as an independent result.
These limitations matter when investigating whether multiple pages are competing for the same query.
Read Google's Search Console reporting dimensions and data groupings before interpreting an export as a complete inventory.
How to Perform a Keyword Audit Step by Step
A useful audit should produce decisions about existing pages. Follow these steps to move from search-performance data to practical improvements.
1. Create an inventory of important website pages
Start by identifying the pages that matter to your website's goals.
These might include:
- Main service and product pages.
- Important category pages.
- High-value informational articles.
- Location-specific landing pages.
- Pages that already attract substantial organic traffic.
- Pages supporting important customer journeys.
For each page, record its intended topic and purpose.
For example:
| Page | Intended topic | Main purpose |
|---|---|---|
| /office-cleaning/ | Office cleaning services | Generate service enquiries |
| /industrial-cleaning/ | Industrial cleaning services | Explain specialized cleaning services |
| /commercial-cleaning-cost/ | Commercial cleaning prices | Explain pricing and cost factors |
| /cleaning-maintenance-guide/ | Cleaning maintenance advice | Provide educational information |
These are illustrative URLs and examples, not actual pages from a customer website.
The important point is to establish what each existing page is supposed to accomplish before examining its search performance.
Without this reference, you can identify ranking URLs but may struggle to recognize genuine targeting problems.
2. Export query and page performance data
Open the Search Console Performance report.
Start with the Queries tab to understand which searches are associated with your website. Then examine the Pages tab to understand which URLs appear in search results.
Export the available information so you can sort, filter, and compare it in a spreadsheet.
Useful fields include:
- Search query.
- Page URL.
- Clicks.
- Impressions.
- CTR.
- Average position.
- Country, where relevant.
- Device, where relevant.
- Reporting period.
One useful feature of Search Console is its ability to connect a query with the pages shown for that query.
Select an individual query in the Performance report and inspect the Pages tab. This provides a practical way to investigate which URLs appeared for that search.
Google documents this workflow in its Search Console common tasks guide.
For a large website, export information in manageable groups. You may want to separate important page categories, countries, or search types rather than immediately combining everything into one enormous spreadsheet.
3. Group related queries by search intent
A website can appear for thousands of different search phrases. Reviewing every phrase independently is rarely the most useful approach.
Group related queries according to their subject and the information people want.
For example, a commercial cleaning website might organize its searches into groups like these:
| Query group | Example searches | Likely intent |
|---|---|---|
| Services | Commercial cleaning company, office cleaning services | Find a provider |
| Pricing | Office cleaning cost, commercial cleaning prices | Understand expenses |
| Industrial services | Factory cleaning, industrial floor cleaning | Find specialized services |
| Information | How often should offices be cleaned? | Learn about cleaning requirements |
Search intent means the underlying reason someone enters a query.
Two searches can contain similar words but require different pages. Someone searching for commercial cleaning prices wants different information from someone searching for a commercial cleaning company.
Do not group keywords solely because they share words. Consider whether the same page could genuinely satisfy both searches.
For a deeper explanation of this principle, see Content Relevance in SEO: What It Means and How to Improve It.
4. Compare the observed URL with the intended URL
This is one of the most important parts of the entire keyword audit.
For each meaningful query, compare two different things:
Observed ranking URL: The page that Search Console reports as appearing for the query.
Intended target URL: The page your content strategy expects to serve that query.
These URLs may be identical, but they do not always match.
Consider this hypothetical example:
| Search query | Intended page | Observed page | Initial assessment |
|---|---|---|---|
| Office cleaning services | /office-cleaning/ | /office-cleaning/ | Expected match |
| Industrial cleaning company | /industrial-cleaning/ | /office-cleaning/ | Investigate relevance |
| Commercial cleaning prices | /commercial-cleaning-cost/ | /cleaning-maintenance-guide/ | Investigate intent mismatch |
| Office cleaning checklist | /cleaning-maintenance-guide/ | /cleaning-maintenance-guide/ | Expected match |
The second and third rows deserve attention because the observed pages differ from the intended pages.
However, a mismatch is an investigation trigger, not proof of an SEO problem.
Google may consider a page relevant to a query even when the website owner intended another page to rank. The observed URL could also be appropriate for a related interpretation of the search.
Open both pages, inspect their content, and compare them with the actual search results before deciding what to change.
5. Identify performance opportunities
After mapping queries to pages, look for patterns that deserve further investigation.
Some useful situations include:
Relevant queries with impressions but few clicks. A page appears in search results, but its visibility does not translate into many visits. Examine its position, title, description, search intent, and competing results before deciding whether its presentation needs improvement.
Pages receiving clicks for unintended queries. These can reveal content that is serving an unexpected audience or a mismatch between the page's purpose and its actual search visibility.
Important pages with limited search visibility. Check whether their topics are adequately covered and whether the pages are accessible, internally linked, and useful.
Queries associated with several pages. Investigate whether the pages serve different needs or genuinely overlap.
Declining performance. Compare equivalent reporting periods to identify changes in impressions and clicks. Consider seasonality and other external influences before attributing a decline to a particular page change.
Avoid selecting arbitrary universal thresholds for impressions, CTR, or average position. A meaningful opportunity depends on the website, query, audience, business value, and available evidence.
6. Review the actual pages
Search-performance data tells you what is happening in search results. It does not explain every reason behind the observed behavior.
Visit the relevant pages and ask:
- Does the page directly answer the searcher's question?
- Is its primary purpose clear?
- Does its content match the query's intent?
- Is important information missing or outdated?
- Are other pages providing substantially the same information?
- Do internal links help visitors discover the appropriate page?
- Is the page accessible and technically suitable for search engines?
Google's people-first content guidance is useful when evaluating whether content provides genuine value rather than simply containing relevant phrases.
If you discover a technical indexing or canonical issue, investigate it separately using the appropriate tools. The Google Search Console URL Inspection guide explains how to examine individual URLs and distinguish indexed information from a live test.
7. Record a decision for every important finding
Do not finish the audit with a spreadsheet full of observations and no clear next steps.
Give every meaningful finding a recommended action and a reason.
A practical classification system is:
| Action | When to use it | Example response |
|---|---|---|
| KEEP | The page matches the query and serves the intended need | Leave the page unchanged and monitor it |
| IMPROVE | The page is relevant but has identifiable weaknesses | Improve missing information or clarify its purpose |
| CONSOLIDATE | Several pages substantially overlap in purpose and intent | Combine content when one stronger page would serve readers better |
| REASSIGN | Another existing page is more appropriate for the query | Improve the appropriate destination and clarify page roles |
| CREATE | An important audience need has no suitable existing page | Research and develop a genuinely useful new page |
| INVESTIGATE | The available evidence is incomplete or uncertain | Collect more data before changing anything |
These are practical editorial decisions, not official Google classifications.
How to Find Keyword Cannibalization Without Misdiagnosing It
Keyword cannibalization is a term used when multiple pages on a website appear to compete for the same search queries or search intent.
For example, a company might publish two articles about the same service, each attempting to answer essentially the same customer question.
Both pages could appear for overlapping searches, creating a reason to examine whether the content strategy is unnecessarily fragmented.
However, multiple URLs appearing for one query do not automatically establish harmful cannibalization.
A website may legitimately have several pages associated with a broad search topic because they address different needs.
Consider a business that sells accounting software. It might have:
- A product page explaining its accounting platform.
- A comparison article examining accounting software options.
- An educational guide explaining accounting software features.
All three pages may relate to accounting software searches, but their purposes are different.
Combining them into one page could make the website less useful.
How to investigate possible cannibalization
Use this sequence before deciding to consolidate pages:
- Select the relevant query in Search Console.
- Examine the Pages tab to identify associated URLs.
- Compare the pages' intended audiences and purposes.
- Examine their content and the actual search results.
- Compare their performance over the same observation period.
- Determine whether the pages satisfy substantially the same search intent.
- Choose between differentiation, improvement, consolidation, or no change.
The Search Engine Land guide to keyword cannibalization and Semrush's keyword cannibalization guide provide additional perspectives on investigating overlapping pages.
When should you consolidate pages?
Consolidation may make sense when two or more pages substantially duplicate each other, serve the same audience, and provide overlapping information without offering distinct value.
Before merging anything, check:
- Whether the pages address the same underlying question.
- Whether one page contains useful information missing from the other.
- Whether either page has valuable external links or established traffic.
- Which URL should remain the primary destination.
- Whether a suitable redirect is necessary after consolidation.
Do not delete a useful page simply because another page contains the same keyword.
Sometimes the better solution is to make the pages more distinct. A general educational guide and a commercial service page can coexist when each fulfills a different purpose.
Turn Audit Findings Into an Action Plan
The most valuable outcome of a keyword audit is a documented list of decisions.
A spreadsheet can make this process easier by separating observed performance from editorial interpretation and subsequent actions.
Keyword-to-Page Audit Decision Worksheet
Use the following structure when building your audit spreadsheet.
| Field | Information to record |
|---|---|
| Search query | The actual query reported by Search Console |
| Topic group | The subject or keyword cluster |
| Observed ranking URL | The page appearing for the query |
| Intended target URL | The page expected to serve the query |
| Impressions | Reported search impressions |
| Clicks | Reported search clicks |
| CTR | Reported click-through rate |
| Average position | Reported average position |
| Country and device | Relevant reporting filters |
| Observation period | The exact dates covered by the data |
| Search intent | The likely information or action the visitor wants |
| Other associated URLs | Additional pages appearing for the query |
| Relevance assessment | Whether the observed page satisfies the search intent |
| Identified issue | The specific problem or opportunity |
| Recommended action | KEEP, IMPROVE, CONSOLIDATE, REASSIGN, CREATE, or INVESTIGATE |
| Decision rationale | Evidence supporting the recommendation |
| Assigned owner | Person responsible for the work |
| Change date | When the improvement was implemented |
| Follow-up observation | Subsequent performance information |
This structure is useful because it keeps three different questions separate:
- What does the performance data actually show?
- What does the evidence suggest about the page and its search intent?
- What action should the website owner take?
That separation reduces the risk of turning a single ranking observation into an unnecessary content change.
A practical example of making an audit decision
Imagine an accounting firm that wants its accounting software comparison page to appear for searches comparing accounting platforms.
Its Search Console report shows that an educational article about accounting software basics also appears for some comparison-related queries.
The firm should not immediately delete the educational article or redirect it to the comparison page.
Instead, it should investigate whether the educational article genuinely helps people understand the subject while the comparison page helps people evaluate products.
If the two pages serve different purposes, both may be worth retaining. If they substantially duplicate each other and neither has a distinct reader benefit, consolidation may be appropriate.
The final decision should reflect the actual content, search results, performance information, and business objectives.
This is the central value of a keyword audit: it turns search-performance observations into deliberate content decisions.
How Often Should You Review Your Keyword Portfolio?
There is no universal Google requirement that every website complete a keyword audit at a particular interval.
The appropriate frequency depends on how quickly the website changes and how much organic search performance matters to the business.
A practical approach is to:
- Review important pages after substantial content changes.
- Investigate significant changes in clicks and impressions.
- Revisit keyword-to-page assignments when launching new content.
- Check for overlapping topics when multiple articles address similar subjects.
- Review important landing pages periodically using consistent reporting periods.
- Record changes so later comparisons have useful context.
For websites publishing frequently, smaller ongoing reviews may be easier than waiting until hundreds of pages need attention.
For smaller websites with relatively stable content, periodic reviews and checks after significant changes may be sufficient.
After making an improvement, allow enough time for meaningful new search-performance observations to accumulate. Do not assume that an immediate change in average position proves the success or failure of the work.
Compare equivalent periods and consider seasonality, changes in search demand, and other factors that could affect performance.
Frequently Asked Questions
What is the difference between a keyword audit and keyword research?
Keyword research identifies potential search terms and opportunities. A keyword audit examines the queries and pages a website already has, then determines whether their existing targeting makes sense.
Can multiple pages rank for the same keyword?
Yes. Multiple pages can appear for the same query. This is not automatically harmful. Investigate whether the pages serve the same search intent or provide genuinely different information before considering consolidation.
Does a low average position always mean a page needs rewriting?
No. Average position is an aggregated measurement. Review impressions, clicks, CTR, query intent, competing results, and page relevance before deciding whether content changes are necessary.
Should I delete pages that receive few clicks?
Not automatically. A page may serve a valuable audience, support other pages, or address a specialized search need. Check its purpose, impressions, historical performance, usefulness, and relationship with other content before removing it.
Can Google Search Console show every keyword a website ranks for?
No. Anonymized queries are omitted for privacy reasons, and reporting row limits also apply. Search Console provides valuable first-party evidence, but its query report should not be treated as a complete record of every search.
How do I decide whether to merge or improve competing pages?
Compare their audiences, search intent, content, and observed performance. Improve pages that serve distinct purposes. Consider consolidation when their content substantially overlaps and a combined resource would better satisfy the reader.
Make Your Keyword Audit an Ongoing Improvement Process
A successful keyword audit does more than identify which search phrases appear in Google. It explains whether the right pages are serving the right searches and what should happen when they are not.
Start with Google Search Console, establish a consistent reporting period, and compare observed ranking URLs with the pages your website intends to target. Investigate mismatches carefully, evaluate actual search intent, and document the reason behind every important decision.
Most importantly, do not create new pages, merge existing articles, or rewrite useful content simply because two URLs share keywords. Make changes when the evidence shows that a different page structure or a better explanation would genuinely help the reader.
That is what makes a keyword audit useful: a clear understanding of existing organic search performance followed by focused, measurable improvements to your website's content strategy.