Appendix B: Linking Matrix Template

Appendix B provides a complete spreadsheet template for your linking matrix. It includes four tabs: PVNs (Pages of Value to the Business), Source Pages (high-authority pages), Pairings (matches between sources and destinations), and Audit Log (tracking changes over time). You can copy this structure into Google Sheets or Excel and customize it for your site.

The four tabs are: PVNs (list all your Pages of Value to the Business with their metrics), Source Pages (list all your high-authority pages that can share link equity), Pairings (match each source to each destination with anchor text and justification), and Audit Log (track every review you perform over time). Each tab serves a specific purpose in planning and tracking your linking strategy.

The PVNs tab has these columns: ID_PVN (unique identifier), URL (full URL), Business Goal (what this page does for you), DR/PA (current authority from Ahrefs or Moz), Organic Traffic (monthly visits from Search Console), Internal Links (number of internal links pointing to this page from Screaming Frog), and Priority (High/Medium/Low).

The Source Pages tab has these columns: ID_Source (unique identifier), URL (full URL), DR/PA (current authority), Organic Traffic (monthly visits), Outgoing Links (number of links from this page from Screaming Frog), and Topic (the main topic of the page). This helps you identify which pages have the most authority to share.

The Pairings tab has these columns: Pairing ID (unique identifier), Source ID (reference to the source page), Destination ID (reference to the PVN), Relevance Justification (why this link makes sense), Proposed Anchor Text (the exact text you'll use), Priority (High/Medium/Low based on impact), Implemented? (Yes/No), and Date (when you added the link).

The Audit Log tab has these columns: Date (when you performed the review), Type (Quarterly/Semiannual/Annual), Findings (what you discovered), Actions (what you did about it), and Status (Pending/In Progress/Complete). This creates a historical record of your linking work.

Get DR/PA from Ahrefs or Moz. Get Organic Traffic from Google Search Console (Performance report). Get Internal Links from Screaming Frog (In Links count). Set Priority based on business value. This data collection takes about 30 minutes for a medium-sized site.

Get DR/PA from Ahrefs or Moz. Get Organic Traffic from Google Search Console. Get Outgoing Links from Screaming Frog (Out Links count). Note the Topic based on the page's content. Focus on pages with DR > 30 or high traffic. This identifies your best sources of link equity.

For each PVN, identify 3-5 source pages that are contextually relevant. For each source, identify 3-5 PVNs that are relevant to its topic. Rate each pairing on relevance: High, Medium, Low. Only include pairings that are at least Medium relevance. This ensures every link makes sense.

A relevance justification explains why this link makes sense. It's a short statement like "Users who read about SEO mistakes are likely to need an SEO audit." This justification ensures the link is contextually appropriate and guides your anchor text choice. It also helps you communicate the link's purpose to your team.

Proposed anchor text should be descriptive (3-7 words), include relevant keywords naturally, and fit the context of the source page. For example, "our complete technical SEO audit service" is better than "click here." Consider what the user expects to find when they click the link.

Use this framework: High priority = Source DR > 40 OR Traffic > 1,000/month AND Destination is a high-value PVN. Medium priority = Source DR 20-40 OR Traffic > 500/month AND Destination is a medium-value PVN. Low priority = Source DR < 20 OR Traffic < 500/month OR Destination is a low-value PVN. Start with High priority first.

Use statuses: Planned, In Progress, Done, Needs Review, and Blocked. Update the status as you work through each pairing. Also, record the implementation date when a link is added. This creates a historical record of your linking activity.

Quarterly as part of your full audit cycle. But also update it whenever you publish new content or make significant changes to your site. If a new PVN emerges, add it to the matrix. If a source page gains authority, add it as a new source. A stale matrix is useless.

Add it! The matrix is a guide, not a prison. If you find a good opportunity that you didn't plan for, add it to the matrix and track it like any other link. The matrix should evolve with your site, not constrain it.

Before publishing new content, check your matrix. Identify which PVNs the new content should link to. Also identify which existing pages should link to the new content. This ensures your linking strategy is proactive, not reactive. Add these pairings to your matrix.

Share the matrix with your team. Use a shared Google Sheet so everyone can see and update it. Assign ownership for specific pairings. Use comments for questions or discussions. The matrix becomes your single source of truth for internal linking work.

Common mistakes include: not having enough PVNs or source pages, not including relevance justifications, proposing generic anchor text, not prioritizing pairings, and not tracking implementation status. Also, building the matrix and never using it is a wasted effort.

For a medium site (500-5,000 pages), plan 2-4 hours to build the initial matrix. This includes gathering data, creating pairings, and setting priorities. Implementation takes longer (weeks or months). The matrix is a living document, not a one-time project.

Track your PVN traffic and rankings over time. If they're improving, your matrix-based linking strategy is working. Also, track the number of links added from the matrix and verify they're passing authority. The matrix provides the baseline for measuring improvement.

Update your matrix accordingly. If a PVN becomes less important, reduce its priority. If a new PVN emerges, add it. The matrix should reflect your current business priorities. This is why quarterly reviews are essential.

If a source page loses DR or traffic, reduce its priority in your matrix. Consider whether you should still link from it. If it's no longer valuable, remove it as a source and find alternatives. Your matrix should evolve with your site's authority changes.

Google Sheets is the most accessible and collaborative format. It's free, cloud-based, and supports comments and version history. Excel works too but is less collaborative. Use a template with the five tabs described in Appendix B for a complete matrix.

Regularly review and update it. Add new PVNs and source pages. Remove outdated ones. Update priorities based on current data. Use the Audit Log to track changes. A well-maintained matrix is a powerful strategic tool; a neglected one is just a document.

A content cluster plan focuses on the content structure (what pages belong together). A linking matrix focuses on the link structure (which pages link to which). They complement each other. The cluster plan defines the relationships; the matrix executes them through links.

When you publish new content, add it as a PVN or source to your matrix. Identify old source pages that should link to it. Add these pairings to your matrix with the "old to new" label. This ensures old-to-new linking is tracked and intentional.

For seasonal content, add temporary pairings to your matrix. Link from evergreen content to seasonal content when it's relevant. Remove or deprioritize these pairings after the season ends. This keeps your matrix relevant year-round.

Treat each content type as a separate "section" in your matrix. Create separate tabs or use filters. Link from blog posts to product pages (content-to-product). Link from product pages to blog posts (product-to-content). The matrix should reflect all these relationships.

Create separate matrices for each language version. Or add language columns to your existing matrix. Ensure internal links stay within the same language where possible. Linking across languages should be intentional and clearly indicated in the justification.

If your subdomains are treated as separate sites, create separate matrices. If they're part of the same site, include them in one matrix but note the subdomain. Ensure internal links between subdomains are intentional and justified.

Dynamic content (e.g., product pages that change frequently) can still be in your matrix. Focus on the pages that are stable. For frequently changing pages, link from more stable content. Update the matrix when dynamic pages change significantly.

The Audit Log records every review you perform: date, type (quarterly, semiannual, annual), findings, actions taken, and status. It provides a historical record of your linking work. Use it to track progress and justify your efforts.

Use the Action Plan tab. List each action (pairing to implement), assign ownership, set a deadline, and track status. This turns your matrix from a planning document into an execution tool. Review the Action Plan weekly.

Create a summary tab showing: total pairings, completed pairings, pending pairings, and high-priority pairings. Share this summary weekly or monthly. This keeps your team aligned and motivated. The matrix becomes a project management tool.

Start with a high-level summary: what it is, why it matters, and what it will achieve. Show the PVNs and source pages. Explain the pairings and priorities. Use visuals (diagrams) to make it understandable. Frame it as a strategic tool, not a technical document.

Break implementation into weekly goals: 5-10 links per week. Celebrate small wins. Review progress in team meetings. Update the matrix regularly. Momentum is key to successful implementation.

Focus on High priority pairings first. These deliver the most impact. Don't try to do everything at once. The matrix helps you prioritize. Even implementing 20% of pairings can deliver 80% of the results.

Track PVN traffic and rankings. If they're improving, your matrix is working. Also, track the number of internal links to PVNs from your source pages. If this increases, you're executing the matrix. The matrix provides the data for measuring success.

If a PVN has few source pages that are contextually relevant, you may have a content gap. Consider creating new content that can link to that PVN. The matrix reveals where your content is insufficient.

Analyze your competitors' linking structures. Identify which pages they link to most frequently. Compare with your matrix. This can reveal opportunities: pages you should link to that you're not, or content gaps you should fill.

A sitemap shows all pages on your site in a hierarchical structure. A linking matrix shows which pages link to which, with specific anchor text. A sitemap is for discovery; a linking matrix is for authority distribution. Both are useful.

Identify which source pages could be linked from external sites. Use your matrix to see which PVNs need more authority. Then, when doing guest post outreach, suggest links to these PVNs using the anchor text from your matrix.

Your matrix shows which PVNs need the most authority. Use this to prioritize your PR and link building efforts. Focus on getting external links to your highest-priority PVNs. The matrix aligns your internal and external linking strategies.

If a PVN isn't receiving links from the right sources, consider moving it up in your hierarchy (making it a subcategory or main category). The matrix reveals where your hierarchy is failing. Use it to guide structural changes.

Map your matrix to user journeys. Identify which pages users need to visit before converting. Ensure these pages link to each other. The matrix helps you create natural user flows that drive conversions.

Internal search results are influenced by internal links. Pages with more internal links rank higher in internal search. Use your matrix to boost pages that should appear in internal search results. This improves internal search user experience.

While linking doesn't directly affect site speed, the matrix can help you reduce unnecessary links, which can reduce page weight. Focus your links on what matters. The matrix helps you avoid link bloat.

If you're repurposing content (e.g., turning a blog post into a video), ensure the new content links to the same PVNs. Add the new content as a source in your matrix. This maintains consistency in your linking strategy.

For seasonal content, add temporary pairings to your matrix. Link from seasonal content to relevant PVNs. Remove these pairings when the season ends. This keeps your matrix clean and relevant.

When launching a new product, add it as a PVN to your matrix. Identify existing source pages that should link to it. Add these pairings. This ensures your new product gets authority from day one.

Your matrix is your linking blueprint during a migration. Use it to ensure all internal links are preserved and updated. After migration, verify the matrix links still work. The matrix is your most important document during a migration.

When consolidating content (merging pages), update your matrix. Remove merged pages as sources or PVNs. Add the consolidated page as a new PVN or source. Update pairings accordingly. The matrix keeps your linking structure clean.

Before any redesign, run a full audit and update your matrix. This documents your current linking structure. After redesign, use the matrix to verify links were preserved. This prevents link loss during redesigns.

Common mistakes include: pairing irrelevant sources with PVNs, using generic anchor text, not justifying the link, setting all pairings to high priority, and not tracking implementation status. Avoid these by following the matrix building process in Appendix B.

The matrix documents your linking strategy. New team members can review it to understand what pages are important (PVNs), which pages are sources, and why links are placed where they are. It's a training tool.

Create a summary report from your matrix: number of links added, PVN traffic changes, and progress against goals. Use the matrix data to show the impact of your work. This demonstrates ROI to clients.

Yes, but create separate matrices for each site. Each site has different PVNs, source pages, and linking structures. Combining them would be confusing. Use a separate spreadsheet for each site.

Yes, you can use filters or separate tabs for different sections. For example, one tab for the blog section and another for the product section. This helps you manage complex sites with multiple content types.

The source to destination ratio is the number of source pages per PVN. Aim for 3-5 sources per PVN. This ensures each PVN receives enough authority without over-linking. Too few sources = not enough authority. Too many sources = dilution.

Anchor text diversity is the variety of anchor texts used for each PVN. Aim for 3-5 different anchor texts per PVN. This prevents over-optimization and looks natural. Use a mix of branded, descriptive, and exact-match anchors.

Priority distribution is the balance of High, Medium, and Low priority pairings. Aim for about 20% High, 30% Medium, and 50% Low. This ensures you focus on what matters most while still addressing lower-priority links.

Legacy links are existing links that weren't planned in the matrix. Review them. If they make sense, keep them and add them to the matrix. If they don't, remove them or update them. The matrix should reflect your actual linking structure, not just your planned links.

Implementation velocity is the speed at which you're adding links from your matrix. Aim for 5-10 links per week. This is a sustainable pace that creates momentum without overwhelming your team. Track your velocity to ensure you're making progress.

Gap analysis is identifying PVNs with too few sources or sources with too few PVN links. Review your matrix. If a PVN has fewer than 3 sources, it's underlinked. If a source links to fewer than 3 PVNs, it's underutilized. Fill these gaps by adding pairings.

Link budget is the total number of links you can add without diluting authority. Each page has a limited number of links before authority dilutes. Use your matrix to allocate your link budget to the most important pairings. Quality over quantity.