What-If Grid: Cost per Link by Emails Sent and Link Rate with Mixed References, a Heat Map and Backward Planning
Lessons in this course
- 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