Summary
- Reviewed published content across:
- Website Pages Database
- Blog Content
- App pages
- Hub (Bullet)
- Tags Database
- Biggest theme this week: keyword-goal mapping gaps (some published items have no 🔑 Keyword Goal relation set) and inconsistent meta coverage in App pages.
Issues Found (highest priority)
Unmapped pages (published, no 🔑 Keyword Goals)
- Website Pages
- Always Accepting Applications — missing 🔑 Keyword Goals
- App pages
- Many published App entries appear to have no 🔑 Keyword Goals set (see Unmapped Pages section).
- Blog posts
- Some published posts have no 🔑 Keyword Goals set (see Unmapped Pages section).
Missing / incomplete meta
- App pages
- Several published App entries have empty Meta Title and/or Meta Description.
- Blog posts
- A subset of published posts have empty Meta Title and/or Meta Description.
Duplicate Meta
Website Pages (confirmed duplicate 🔑 keyword goal link)
- Multiple published Website Pages entries point to the same Keyword Goal record business process automation (review for cannibalization risk if that record represents a single target keyword).
- Example pages include:
- Get Airtable Help
- Terms & Conditions
- Thank You for Contacting Us
- Thank You For Booking
- Connex Products
- Privacy Policy
- Home
- Apps
- Blog
- 404
- etc.
Note: I did not run a full cross-database duplicate-meta-title/description join (Website Pages vs Blog vs Apps vs Hubs vs Tags) in this run; the report above flags likely risk areas based on the available structured fields.
Unmapped Pages (details)
Website Pages Database
- Always Accepting Applications (published) has no 🔑 Keyword Goals relation set.
Blog Content
- There are published blog rows with 🔑 Keyword Goals empty.
- Examples seen in the published list include:
- Automatic Social Media content with OpenAI and Zapier
- LinkedIn Ads → Salesforce Integration
- Simple ChatGPT CMS for Translation Agencies
- plus additional older posts with empty meta fields and/or keyword goal relations
App
- Published App entries with missing 🔑 Keyword Goals exist (example seen: Slack).
Hub (Bullet)
- All published hubs sampled in this run had 🔑 Keyword Goals populated.
Tags Database
- Tag pages show a 🔑 Keyword Goals relation field in the schema, but I did not compute a complete “missing keyword goal” list for tags in this run.
Keyword Opportunities
- Add / enforce a workflow to require 🔑 Keyword Goals for any item with Publish = true (Pages, Posts, Apps, Hubs, Tags).
- Review the Keyword Goal business process automation for scope: if it represents one specific keyword, re-map broad sitewide pages (e.g., Privacy Policy, Terms) to either no keyword goal or to a more appropriate grouping to avoid cannibalization.
Recommendations
- Add validation views in each database for:
- Publish = true AND 🔑 Keyword Goals is empty
- Publish = true AND Meta Title is empty
- Publish = true AND Meta Description is empty
- Standardize meta length checks (target ranges):
- Meta Title: 50–60 characters
- Meta Description: 150–160 characters
Metrics (this run)
- Website Pages reviewed (Publish = true): 31
- Blog posts reviewed (Publish = true): 67 (first 500 rows returned; 67 published matches in the current output)
- App pages reviewed (Publish = true): 87
- Hub pages reviewed (Publish = true): 19
- Tags reviewed: not fully computed in SQL for meta-coverage/duplicates
