Also known as: Project Pages, Pages data base, Site Pages
The Project Pages (database table project_pages) form the central URL data base for each project in Rankmio. Every URL of a project that appears anywhere in the system — through a crawl, sitemap import, GSC sync or manual entry — is stored here as a unique record with metadata (status, last crawl timestamp, index status, last modified). All other modules (site audit, GEO audit, keyword hub, citation tracker, Content Studio) reference project_pages as the single source of truth — whatever is not held here does not exist within the project context.
When a record is inserted into project_pages, the function ProjectPage::isCrawlable() runs — it filters out junk URLs: Cloudflare email obfuscation paths (/cdn-cgi/*), Rankmio app routes on your own subdomains, and dynamic parameter variations. This keeps the data base lean — only genuine, indexing-relevant URLs are stored. Without this filter the database would quickly fill up with duplicates and junk paths.
The project_pages pattern solves a common SEO tool problem: when site audit, GSC and sitemap each maintain separate URL lists, discrepancies arise constantly — the sitemap holds 1,200 URLs, the audit finds 850, GSC sees 1,450. Which one is correct? With a central project_pages table as the basis of trust, the picture is clear: 1,450 URLs are recorded in the project, each with a note of its source. The audit checks them all, the GSC sync adds missing ones, and the sitemap import reconciles the rest. This shortens diagnosis time dramatically.
Example: A shop with 12,000 products had conflicting tool reports: the site audit found 8,400 indexable URLs, GSC showed 11,200 and the sitemap held 9,800. Diagnosis was impossible. After migrating to Rankmio, all three sources flowed into project_pages, with a source tag for each URL. The result: 12,100 unique URLs, of which 8,400 appeared in both (audit + sitemap), 1,400 only in the sitemap (the audit does not find them — a crawler issue) and 2,300 only in GSC (missing from the sitemap). A clear action list followed: check the crawler configuration and complete the sitemap. Within 4 weeks the URL housekeeping was in order.
URL overview in the site audit
Free SEO & GEO Check
SEO score, AI visibility and citability of your website in 30 seconds — no registration required.
Register for free, get 10 credits and start right away.
Register now