Google Sheet For Planning Your Internal Links

A few weeks ago I shared some strategies around finding internal linking opportunities. If you missed that one, you can go read it here.

I got asked by a lot of people how I keep track and/or plan out the internal linking on a site, especially when creating new topic clusters.

I’ve tried different methods. I have used, and that can still work well if you set it up correctly but it can feel a little bit complicated.

If you want something simple, this is what I have used for years. A simple Google Sheet:

On this sheet, the Pillar Page is the main page for your topic cluster. You then list the supporting articles (I list the titles and then hyperlink them to the live URL, what anchor text you want to use to link back to the pillar page, and any additional pages you want to link to from that piece of content.

The Additional Links section is for a website with existing content that may be worth using for some links to the pillar page as well.

If you like, you can also copy these into different tabs and keep each cluster separate that way.

When you go to the Sheet, just click on File >> Make a Copy, and it is all yours.

There is also a video below on how I use this sheet.

Tools I Use:

πŸ”Ž  SemrushCompetitor and Keyword Analysis

βœ”  Monday.comFor task management and organizing all of my client work

πŸ—„  FraseContent optimization and article briefs

πŸ‘‘  ContentKing AppSite crawler, monitoring, and audit tool

πŸ“ˆ SEOPress – It’s like Yoast, if Yoast wasn’t such a mess.

Sign Up So You Don't Miss the Next One:

vector representation of computers with data graphs
Subscription Form

Past tips you may have missed...