Every SEO decision on Servicehub247 eventually loops back to one keyword's detail page - that's where the full crawl history lives: every timestamp, position, SERP page, and which URL of yours is actually ranking. This guide walks through the four core data fields, and especially what it means when the ranking URL changes.
4 fields stored per crawl
Every time Servicehub247 crawls a keyword (per your plan's update_frequency), a record is written to keyword_rankings with:
- position - actual ranking (1–100+). Smaller = better.
- rank - SERP page number (1, 2, 3...). Derived from position: 1–10 → page 1, 11–20 → page 2.
- url - which URL of your domain shows up on the SERP. May differ from the target URL you originally entered.
- title - the SERP-displayed title of that ranking page.
- checked_at - Unix timestamp of the crawl.
Ranking URL - the most-overlooked field
The url field answers: "which page of mine is actually ranking for this keyword?" When that URL differs from the target URL you entered, that's a signal worth reading.
Scenario 1: Different URL but same domain (cannibalization)
Target = /products/water-filter-ro, but the tracker reports the ranking URL = /blog/how-to-choose-water-filter. Google decided the blog matches search intent better than the product page.
Action: either (a) refactor the product page to match intent better, or (b) accept the blog is the ranker and add conversion CTAs to it.
Scenario 2: URL keeps switching between multiple pages
Week 1 ranks URL A, week 2 ranks URL B, week 3 back to A. Classic cannibalization - multiple pages targeting one keyword, Google unsure which is best.
Action: consolidate. One keyword → one canonical page; other pages either 301 or change intent.
Scenario 3: URL suddenly missing, position = 0
Previously ranked URL X, latest crawl has no URL. Page X might have been: deindexed, lost canonical, URL changed without 301, or hit by a penalty.
Action: open URL X in an incognito tab and check HTTP status + meta robots + canonical.
Position vs SERP page - don't conflate
Two related but different fields:
- position: specific (e.g. 23).
- rank (SERP page): 23 → page 3 (since 21–30 is page 3).
For granularity tracking, follow position. For real impact, follow page transitions. A keyword moving from page 2 (position 11) to page 1 (position 10) is a major event despite "only +1 position".
Gaps between crawls
If update_frequency = daily but the timeline has >1-day gaps, three causes:
- Crawl queue backlog that day (rare).
- The keyword was over your plan limit → crawl was paused during that period.
- Temporary failure from the external ranking API.
Gaps >7 days → check Plan Usage. If everything looks healthy, contact support.
Title field also carries signal
The title field stores the SERP-displayed title of the ranking page. If the title suddenly changes between crawls, two possibilities:
- You (or your dev team) changed the <title> tag.
- Google rewrote the title (common when your title is too long or doesn't match intent).
This is gold for title A/B testing - compare title values across crawls to confirm if your new title is making it onto the SERP.
Signals worth keeping an eye on
- URL suddenly shifts from product page to blog → intent / cannibalization issue.
- URL disappears, position → 0 → possibly deindexed / penalized / canonical broken.
- Crawl gaps >7 days → check Plan Usage.
- Title rewritten by Google → consider editing the original title.
- Position swinging wildly (>10 ranks) between crawls → technical or competitor issue.
