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.
- 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
- The Outreach Funnel: Emails Sent, Opened, Replied and Linked, with Open Rate, Reply Rate and Link Rate per CampaignFree
- Building a Prospect List: Qualifying Sites by Authority, Organic Traffic and Topical Relevance with AND and COUNTIFS Locked
- Cost per Link: Labour, Content and Tool Costs per Campaign, the Blended Cost per Link and a Bar Chart Locked
- Anchor-Text Mix: Branded, Naked, Generic, Partial and Exact Match, Shares Against Guide Values and a Pie Chart Locked
- Referring-Domain Growth: New and Lost Domains, Net Change, a Running Total and the Growth Rate of the Year Locked
- Referring Domains vs Competitors: Growth %, Monthly Velocity, Rank and the Months Needed to Close the Gap Locked
- Link Quality Scoring: Weighted Authority, Relevance, Traffic and Follow Status, Tiers with IFS and a Highlight Rule Locked
- Follow-Up Sequences: Replies per Step, Reply Rate per Prospect, the Follow-Up Share and a Stacked Column Chart Locked
- Results by Prospect Type: SUMIFS Summaries for Journalists, Bloggers, Resource Pages and Podcasts, and the Best Batch Locked
- Digital PR Coverage: Follow Links, Nofollow Links and Unlinked Mentions, the Linked Coverage Rate and Link Reclamation Locked
- Forecasting Referring Domains: SLOPE as Link Velocity, FORECAST.LINEAR, the Month a Target Is Reached and R² Locked
- Link Decay: Link Age in Days, Loss Rates by Source Type, Surviving Old Links and a Rule That Highlights Lost Links Locked
- Testing Two Outreach Templates: Lift in Reply Rate, the Pooled z-Test, p Values and a Verdict for Small Lists Locked
- List Hygiene Before a Send: Duplicate Sites, Email Verification, Opt-Outs and a Cool-Down Period with Dates Locked
- Allocating the Link Budget: Cost per Quality Point, Ranking Tactics and Funding in Rank Order Until the Budget Ends Locked
- What-If Grid: Cost per Link by Emails Sent and Link Rate with Mixed References, a Heat Map and Backward Planning Locked
- Do the Links Pay? Incremental Organic Visits, Margin per Month, Payback and 12-Month ROI per Target Page Locked
- Link Risk Audit: Risk Points for Weak Sites, Exact-Match Anchors and Site-Wide Links, Labels with IFS and a Flag Rule Locked
- Backward Planning: From Target Links to Replies, Emails and Hours with ROUNDUP, and the Capacity the Team Needs Locked
- Final Project: A Half-Year Link Building Dashboard with Links, Link Rate, Cost per Link and Link-Weighted Quality by Tactic Locked
Learner reviews
Be the first to review this course.