Categories: BLOG2

How I Found Internal Linking Opportunities With Vector Embeddings

Do the same thing for each subsequent “URL # links to A?” rows.
The reference to column B “Links to Target URL” isn’t going to change, but the reference to the related URL column will. For example:
In F2 (“URL 2 links to A?”) you will be looking for the E2 URL within the list of URLs in B2:

=IF(ISNUMBER(SEARCH(E2, B2)), "Exists", "Not Found")

Copy this formula down column F. In H2 you will be looking for the G2 URL within the list of URLs in B2:

=IF(ISNUMBER(SEARCH(G2, B2)), "Exists", "Not Found")

Copy this formula down column H. Repeat this process for each of the “URL # links to A?” columns.

Highlight missing links for easy review

  • I selected columns D:L and went to Format -> Conditional Formatting in Google Sheets (or Excel).
  • I set a rule to format cells containing “Not Found” in pink for easy identification.

This made it easy to spot where the internal links were missing.

Validate the data

I double-checked a few entries manually to ensure everything was accurate. Now, I have a complete list that shows each target URL in column A, the top 5 related URLs, and whether those URLs are linking back to the target URL.
My final spreadsheet looked like this, with “Exists” or “Not Found” indicating whether each related URL was linking back to the target URL:

If you liked How I Found Internal Linking Opportunities With Vector Embeddings by Everett Sizemore Then you'll love Miami SEO Expert

Everett Sizemore

Share
Published by
Everett Sizemore

Recent Posts

How To Diversify Your Traffic Outside of Google SERPS

How to build a brand-led content strategy that drives demand outside searchYou’ll learn to move…

2 weeks ago

The Future of AI in Search | Whiteboard Friday Revisited With Britney Muller

Five years after this video was created, the idea that machine learning might be “far…

2 weeks ago

Stop Losing SEO Traffic: AI-Powered Strategies to Detect, Fix, and Drive [MozCon 2025 Speaker Series]

 I’ve spent the past year fielding the same panicked question from clients repeatedly: “Why is traffic…

3 weeks ago

How to Claim, Verify, and Manage Google Business Profiles at Scale

Claim and Verify All Listings with a Domain EmailWe all know how to claim and verify…

3 weeks ago

How To Automate Your BoFu Strategy With AI [Free Prompts, Templates & Workflows]

When Teal brought me in, their bottom-of-funnel content was barely moving the needle. Blog posts…

3 weeks ago

F*** Traffic: How To Prioritize Conversion Over Vanity Metrics

Clicks are down, and if you’re working in SEO right now, you’re probably stuck trying…

3 weeks ago