Tabellab

Final Project: A Half-Year Link Building Dashboard with Links, Link Rate, Cost per Link and Link-Weighted Quality by Tactic

Lesson 20 of 20 Lab 🔒 Locked

Lessons in this course

  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