Leverage BigQuery for Superior Inner Hyperlink Evaluation

Table of Contents

Conditions

First, you may want a CSV containing all of your inside hyperlinks.

On the very least, your file ought to have a column for the supply (origin of the inner hyperlink) and a column for the vacation spot (the place the hyperlink leads). Nevertheless, if doable, embody extra columns for the anchor, standing code, and sort of hyperlink (similar to picture, textual content, and hreflang) to complement your evaluation.

For instance, I used information from my company’s web site. Whereas it’s a small website with 1,678 pages (together with redirects and faulty pages), it incorporates 338,656 hyperlinks when accounting for CSS, JavaScript, sitemaps, and extra. Though manageable in a uncooked Excel sheet, making use of customized formulation and filters might turn into difficult.

Under are my CSV columns:

Sort: Identifies whether or not the hyperlink is from a sitemap, hreflang, canonical, easy hyperlink, picture, CSS, and many others.
Supply: The web page the place the hyperlink is situated.
Vacation spot: Factors to the goal web page.
Alt Textual content: If the hyperlink is a picture, this column incorporates its alt attribute textual content.
Anchor: The HTTP standing code of the vacation spot.
Standing: The standing of the vacation spot (e.g., canonicalized, non-indexable).
Observe: Helpful for figuring out if the hyperlink impacts web optimization.
Hyperlink place: Signifies if the hyperlink is within the navigation, head, content material, or elsewhere. Make sure the device settings are correct.
Hyperlink origin: Specifies whether or not the hyperlink is simply current within the HTML or the rendered HTML post-JavaScript execution. That is useful in troubleshooting JavaScript-rich web sites.