Skip to main content
Question

Tracking indexed vs non-indexed pages for a growing content site, good Airtable base structure?

  • August 7, 2026
  • 4 replies
  • 61 views
abubakar1210

Hi everyone, I run a content site called Crab Guide, it has grown to 90+ published pages but not all of them are indexed by Google yet, and I have been tracking this manually in a spreadsheet which is getting messy (columns for publish date, index status, clicks, and which pages still need internal links).

I want to move this to Airtable and set it up properly, maybe with a view just for "needs attention" pages. Would a single table with status fields work fine, or does something like this usually need linked tables (like a separate table for keywords or backlink tracking)? Curious how people managing larger content sites structure this kind of tracker.

Thanks!

    4 replies

    vera_green
    Forum|alt.badge.img+4
    • vera_green
    • Participating Frequently
    • August 7, 2026

    One table sounds good to me, since all your cases are the same kind of thing. You can do all of those details in fields.

    Odey
    • Odey
    • New Participant
    • August 9, 2026

    for now 1 table will work fine,but then you are right at the age where 1 table will begin to strain you. with time and as you increase the pages, you will need a linked table for better managment.

     

     

    anthonyXRay
    Forum|alt.badge.img+6
    • anthonyXRay
    • Participating Frequently
    • August 9, 2026

    Initially you will be fine with a single table but when you start tracking indexing status along with internal links and clicks most people would have wished they had split up their base sooner.  A good middle ground for this is a single main “Pages” table with status fields and a separate “Keywords” table linked to Pages if you’re tracking rankings per keyword.  That relationship will quickly get chaotic in a single table because pages often target multiple keywords.  I would only split out backlinks when you get past a hundred or so.

    A “needs attention” filtered view on Pages table would be great.  This would include conditions like Index Status is not “Indexed” or “Needs Internal Link” is equal to true.  You can put in a formula that flags the pages older than a certain number of days that aren’t indexed.

    Anthony at XRay
    Mike_AutomaticN
    Forum|alt.badge.img+30

    Hey ​@abubakar1210, feel free to grab a slot using this link and I’d be happy to discuss live and help you out :D

    https://automaticnation.com/book-a-call

    Mike, Consultant @ Automatic Nation 
    YouTube Channel  

    Terms & ConditionsAccessibility statement