Tabellab
Marketing Analytics Intermediate

Link Building & Digital PR Outreach: Prospect Lists, the Outreach Funnel, Cost per Link, Anchor-Text Mix, Link Quality & Referring-Domain Growth

Run link building as a measured process. You will follow outreach campaigns through the funnel from emails sent to opens, replies and links, qualify a prospect list, cost every link including the hours, check the anchor-text mix, track referring-domain growth and the gap to competitors, and score link quality. Then you go deeper: follow-up sequences, results by prospect type, digital PR coverage and unlinked mentions, a trend forecast, link decay, a significance test for two subject lines, list hygiene and opt-outs, a budget ranked by cost per quality point, a what-if grid, the payback of link campaigns, a risk audit and a capacity plan, before you finish with a half-year dashboard. 20 hands-on labs, fictional outdoor retailer and fictional sites, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course treats link building and digital PR outreach as a process you can measure in a spreadsheet. In 20 interactive labs you work through the campaign log of Quillfern Outdoors, a fictional online shop for hiking and camping gear. You follow outreach emails through the funnel from sent to opened, replied and linked, qualify a prospect list, calculate cost per link including the team's hours, check the anchor-text mix, track referring-domain growth against competitors and build a weighted link quality score. Later labs cover follow-up sequences, results by prospect type, digital PR coverage and unlinked mentions, a trend forecast, link decay, a significance test for two email templates, list hygiene, budget allocation, a what-if grid, payback of link campaigns, a risk audit and a capacity plan, and a final dashboard brings it together. Every formula is typed by you and checked at once. All companies, sites and numbers are fictional and benchmarks are illustrative.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. The Outreach Funnel: Emails Sent, Opened, Replied and Linked, with Open Rate, Reply Rate and Link Rate per CampaignLabFree
  2. Building a Prospect List: Qualifying Sites by Authority, Organic Traffic and Topical Relevance with AND and COUNTIFSLab Locked
  3. Cost per Link: Labour, Content and Tool Costs per Campaign, the Blended Cost per Link and a Bar ChartLab Locked
  4. Anchor-Text Mix: Branded, Naked, Generic, Partial and Exact Match, Shares Against Guide Values and a Pie ChartLab Locked
  5. Referring-Domain Growth: New and Lost Domains, Net Change, a Running Total and the Growth Rate of the YearLab Locked
  6. Referring Domains vs Competitors: Growth %, Monthly Velocity, Rank and the Months Needed to Close the GapLab Locked
  7. Link Quality Scoring: Weighted Authority, Relevance, Traffic and Follow Status, Tiers with IFS and a Highlight RuleLab Locked
  8. Follow-Up Sequences: Replies per Step, Reply Rate per Prospect, the Follow-Up Share and a Stacked Column ChartLab Locked
  9. Results by Prospect Type: SUMIFS Summaries for Journalists, Bloggers, Resource Pages and Podcasts, and the Best BatchLab Locked
  10. Digital PR Coverage: Follow Links, Nofollow Links and Unlinked Mentions, the Linked Coverage Rate and Link ReclamationLab Locked
  11. Forecasting Referring Domains: SLOPE as Link Velocity, FORECAST.LINEAR, the Month a Target Is Reached and R²Lab Locked
  12. Link Decay: Link Age in Days, Loss Rates by Source Type, Surviving Old Links and a Rule That Highlights Lost LinksLab Locked
  13. Testing Two Outreach Templates: Lift in Reply Rate, the Pooled z-Test, p Values and a Verdict for Small ListsLab Locked
  14. List Hygiene Before a Send: Duplicate Sites, Email Verification, Opt-Outs and a Cool-Down Period with DatesLab Locked
  15. Allocating the Link Budget: Cost per Quality Point, Ranking Tactics and Funding in Rank Order Until the Budget EndsLab Locked
  16. What-If Grid: Cost per Link by Emails Sent and Link Rate with Mixed References, a Heat Map and Backward PlanningLab Locked
  17. Do the Links Pay? Incremental Organic Visits, Margin per Month, Payback and 12-Month ROI per Target PageLab Locked
  18. Link Risk Audit: Risk Points for Weak Sites, Exact-Match Anchors and Site-Wide Links, Labels with IFS and a Flag RuleLab Locked
  19. Backward Planning: From Target Links to Replies, Emails and Hours with ROUNDUP, and the Capacity the Team NeedsLab Locked
  20. Final Project: A Half-Year Link Building Dashboard with Links, Link Rate, Cost per Link and Link-Weighted Quality by TacticLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy