How to analyze ranking exports and decide what to fix
Learn how to analyze ranking exports, compare matching observations, and use ranking pages and search results to decide which pages to fix first.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What it means to analyze ranking exports
When you analyze ranking exports, you turn a file of search positions into decisions about specific pages. A rank tracker may record where a URL appeared for a keyword on a particular day, in a particular market, on a particular device. A Search Console export can give you average position across impressions, or appearances in search, over a date range. Establish what your source measured before comparing positions.
A useful rank tracking report shows where tracked searches stand, what moved where the data supports a comparison, and which page should answer each important query. The file supplies the observations. Read the ranking page and today's search results to decide what needs work. If the home page ranks for a specific service query, check any existing service page before deciding where to improve the answer.
What it does for the business
- Give the client a clear account of what changedA report scoped to the tracked queries helps the client decide which losses deserve investigation. It also shows where a new export could settle a question.
- Use editorial time on pages that already serve the queryAn existing service page may need a clearer answer about availability or the work included. Show the writer where that answer belongs and how it relates to the searches the page serves.
- Route prospective customers to a more relevant pageA visitor who lands on a home page for a specific repair may have to find the service again. Once you identify the intended page, make it easier to find with clearer titles and links from related pages.
- Give the team a repeatable reviewRecord the export settings and the dates of your changes. At the next review, the team can revisit the same queries and see whether the expected page appears.
How to analyze ranking exports, step by step
Identify the source and define each measurement
A position is useful when you can explain how it was measured.
What to do
- Use an export your team owns or is licensed to use. Save the original and record the source and the site or property it represents.
- Read the headers and sample the rows. Define what each row represents, such as a keyword on a tracking date, a query averaged over a period, or a page averaged over a period.
- Record the dates, market, device, engine, and filters shown in the file. Note whether the source uses a fixed keyword list or reports the queries it observed.
- Label any missing settings. If you use the file date as a fallback, flag the assumption and avoid comparisons that need a verified observation date.
Why
The same column label can refer to different measurements. A tracked position reflects a particular search setup. In Search Console data analysis, average position can shift as the mix of impressions changes. Knowing what a row represents tells you which comparisons the file supports.
Account for every row before using the file
Every row needs a traceable place in the analysis or a reason for exclusion.
What to do
- Load the entire file and count the rows. If dates run across columns, turn them into dated observations and keep a reference to each original row and date column.
- Check the available query, date, position, and URL fields. Log unusable rows with a reason, such as a missing field required for the comparison.
- Check for duplicates at the level the export measures. Where the source reports by URL, preserve rows for distinct URLs and flag conflicting values for the same observation.
- Keep blank, failed, or missing observations unknown. Use the tracker's own convention to identify completed checks where the site was unranked within its tracking range.
- Record the keywords, pages, and dates covered. Check for filters or row limits that could narrow the file.
Why
Duplicate rows can skew a summary. Missing rows can make a movement table look more complete than it is. Record how you handled both so a second reader can reconstruct the analysis from the original file.
Compare matching observations and read the pages
A ranking change earns an action after you check the page behind it.
What to do
- Match the same keyword, market, device, and engine across dates within the same source and metric. Use comparable periods and filters for averages. Name the group that remains after those checks.
- Summarize where keyword rankings stand. Flag meaningful movement, including first-page entries and exits in tracked data, and list missing matches separately.
- Look for queries near a useful ranking threshold and results that point to the wrong page. Check whether URLs alternate for the same query under matching settings. This can suggest keyword cannibalization, where your own pages compete to answer the same search.
- Open the ranking page and today's search results for the main opportunities and losses. Match search settings where possible and record the check date. Identify something specific a higher-ranking page answers that yours leaves out.
- If a general page ranks for a specific service query, look for an existing service page and check what it actually covers before suggesting an edit.
Why
A change in the mix of tracked terms or devices can move an overall summary. Matching observations keeps those effects out of the movement table. Today's results can suggest an edit, while the export establishes what was observed at the time.
Turn what you found into specific edits
An action belongs in the report when someone can open the page and make the change.
What to do
- Name the query, the page that appears, and the page that should answer it. Say why the intended page fits and cite the rows that support the action.
- Give the new heading, describe the section to add, or name the page that should link to the intended destination.
- Order the work by business relevance, evidence, and effort. Record confidence separately from priority so an important issue with uncertain coverage stays visible.
- Keep the list to actions you can support. For each agreed edit, name the query and page to look for in the next comparable export.
Why
A page owner needs to know what to change and why. If a category page leaves a common buyer question unanswered, name the section that should address it and the question it needs to cover.
Check the evidence and write the report
Every headline finding should lead back to a row or a page someone can check.
What to do
- Ask a second reader to recount the headline summaries from the original export and check the handling of duplicates, unusable rows, and missing observations.
- Have the reader reopen the pages behind the main actions and confirm that each edit addresses a visible issue.
- Put the decisions first, then show current standing, supported moves, positions close to the first page, and searches served by an unexpected page.
- Document the source, rows read, dates, and gaps. Label judgments about which page should serve a query. Save the export settings for future reviews.
Why
Clients often act on the summary before opening the tables. A second reader can catch a copied value, a comparison across different query sets, or an edit aimed at the wrong URL.
Common mistakes
- Comparing unlike positionsA one-day tracker snapshot and a period average measure different things, so compare each within its own source and scope.
- Calling a missing query a ranking lossCheck the export coverage and tracking status before interpreting an absent row as a disappearance from search.
- Changing the tracked keyword list mid-comparisonUse the matching group for movement and show where the set of tracked queries changed.
- Treating alternating pages as proof of a problemRead the pages and the results to see whether each URL answers a different need or whether a single page should serve the query.
- Giving the client an edit with no evidenceName the page, the source rows, and the current page content that justify the proposed change.
What a good result looks like
- The file, source, metric, date range, and available search settings are stated.
- Rows read, duplicates, exclusions, and unknowns can be reconciled with the source export.
- Every movement finding compares matching observations under comparable settings.
- Main actions cite both the observations and the page evidence that guided the recommendation.
- The client can see which changes to make and where the findings stop.
And then what? Using the result
- Assign each agreed edit to the page owner and set a review date.
- Add the proposed titles, headings, sections, or links to the relevant content briefs.
- Ask for a fresh export using the same settings if an important query lacks a comparable observation.
- Record when each edit goes live and use the next comparable export to check whether the intended page appears.
- Bring any drop spanning related pages to the site owner with the matching data and affected URLs.
When to run it
- At the start of a client engagementAn export gives you a baseline for the searches and pages it covers. Use the intake to agree which queries the client wants to follow consistently.
- Before planning a content refreshUse the report to pick existing pages with concrete gaps and give the editor a specific change for each one.
- After a release that changes URLs or navigationUse comparable exports to look for changes in the pages that appear for important searches. Inspect those pages before deciding whether the release explains the pattern.
- When a client reports a loss on mobileCheck mobile observations for the affected queries in the same market and engine. Keep the dates and device settings visible when you present the findings.
Questions people ask
How do you analyze ranking exports?
Define the measurement, validate the rows, and compare matching observations. Then open the ranking pages and search results before proposing changes. Cite the observations and what you saw on the page.
Can you compare Search Console average position with a rank tracker?
Keep the measures separate because a period average across impressions and a tracked position under specific settings answer different questions. Show each source with its own date, scope, and metric.
How do you handle missing rankings in an export?
Treat missing positions as unknown. Use the explicit unranked label only where the source completed a check and found the site outside its tracking range. Check rows and filters before claiming a loss.
How can you tell if the wrong page ranks for a keyword?
Read the ranking page and see whether another page answers the query more directly. If a service query lands on the home page, inspect the relevant service page and check which related pages link to it.
Can you analyze rankings from a single export?
Yes. One export can show current standing and page mismatches. It supports movement findings if it includes comparable past observations. Use an export for a single date as a baseline for the next review.
How do you prioritize changes after reviewing rankings?
Start with a query that matters to the business, a page you can edit, and a gap you can point to in the content. Give the editor the detail prospective customers need.
More jobs in SEO agencies
Analyze ranking exports, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac