How I Discovered Inside Linking Alternatives With Vector Embeddings

Do the identical factor for every subsequent “URL # hyperlinks to A?” rows.
The reference to column B “Hyperlinks to Goal URL” isn’t going to vary, however the reference to the associated URL column will. For instance:
In F2 (“URL 2 hyperlinks to A?”) you may be searching for the E2 URL inside the checklist of URLs in B2:

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

Copy this system down column F. In H2 you may be searching for the G2 URL inside the checklist of URLs in B2:

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

Copy this system down column H. Repeat this course of for every of the “URL # hyperlinks to A?” columns.

Spotlight lacking hyperlinks for simple assessment

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

This made it simple to identify the place the interior hyperlinks had been lacking.

Validate the information

I double-checked a number of entries manually to make sure all the things was correct. Now, I’ve a whole checklist that reveals every goal URL in column A, the highest 5 associated URLs, and whether or not these URLs are linking again to the goal URL.
My remaining spreadsheet regarded like this, with “Exists” or “Not Discovered” indicating whether or not every associated URL was linking again to the goal URL: