DEV Community

Cover image for What Data Should You Store When Tracking Keyword Rankings?
Florian
Florian

Posted on

What Data Should You Store When Tracking Keyword Rankings?

Keyword rank tracking sounds simple at first.

You search a keyword, check where your website appears, and record the position.

But once you start tracking rankings over time, the problem becomes more complicated. A single position number is often not enough to explain what actually changed.

Why position alone is not enough?

If a keyword drops from position 3 to position 8, it is tempting to assume that the page became weaker.

But the SERP itself may have changed.

For example:

  • Google may show more ads
  • local results may appear
  • a featured snippet may take more space
  • the query intent may shift
  • competitors may rank with a different type of page
  • results may vary by country, city, language, or device

This is why storing only the ranking position can be misleading.

Basic data to store

For each keyword check, I would usually store:

  • keyword
  • target domain
  • ranking position
  • ranking URL
  • title
  • snippet
  • country
  • language
  • device
  • timestamp

This gives you enough context to compare changes over time.

Why location matters?

Search results can look very different depending on location.

For local SEO, this is especially important. A business may rank well in one city but not in another. Even for non-local keywords, Google may still adjust results based on regional intent.

If your project involves international SEO, local services, or market research, location should not be treated as an optional field.

Why device matters?

Desktop and mobile SERPs are not always the same.

Mobile results may show different layouts, different local packs, and different visible elements. If most of your traffic comes from mobile, tracking desktop rankings only may give you an incomplete picture.

Why SERP features matter?

Sometimes your ranking position stays the same, but your visibility changes.

This can happen when the SERP includes:

  • ads
  • featured snippets
  • People Also Ask
  • local packs
  • image results
  • video results
  • shopping results

A page ranking in position 3 may receive less traffic if several SERP features appear above it.

Also track competitors

Rank tracking is not only about your own domain.

It is also useful to record which competitors appear above and below you. This helps answer questions like:

  • Did we lose position to the same competitor repeatedly?
  • Did a new site enter the SERP?
  • Are review sites, marketplaces, or forums taking over the results?
  • Did Google start favoring a different content format?

These details are often more useful than the position number alone.

A simple rank tracking checklist

Before building or choosing a rank tracking system, I would check whether it can store:

  • keyword
  • location
  • language
  • device
  • ranking URL
  • title and snippet
  • SERP features
  • competitor URLs
  • timestamp
  • historical snapshots

Without this context, it becomes difficult to understand why rankings move.

Final thoughts

Keyword rank tracking is not just about knowing whether a page is number 1, 3, or 10.

The more important question is: what changed in the search results?

If you store only position, you may miss the real reason behind traffic changes.

If you store structured SERP context, ranking data becomes much more useful for SEO monitoring, competitor research, and long-term decision making.

Top comments (0)