Link Building Tracker Spreadsheet: Track Every Backlink You Build

A link building tracker is a spreadsheet that records every prospect you identify, every outreach email you send, and every backlink you earn. Without one, your link building effort is a black box. You spend hours on outreach, you know some links land, but you can’t tell your manager or client exactly how many links you acquired last month, what your response rate was, or which tactics produced the highest-authority placements.

Link building tracker: A structured spreadsheet that manages the full link acquisition pipeline from prospect identification through outreach, follow-up, and placement confirmation, with automated metrics for response rates and link velocity.

According to Ahrefs’ analysis of over 14,000 search queries (2024), the top-ranking pages have an average of 3.8x more referring domains than pages ranking in positions 2-10. Links still move rankings. But most SEO teams can’t answer a basic question: how many links did we build last quarter? This template gives you that answer in 10 seconds. The Search Engine Journal link building workflow guide recommends tracking prospect domain authority, contact details, outreach status, and link type in one centralized sheet. That’s exactly what this tracker does, with formulas that calculate your response rate, placement rate, and monthly link velocity automatically.

• Prospect List: Your master database. Enter every potential link target with their domain, Domain Authority (from Moz) or Domain Rating (from Ahrefs), contact name, email address, topic relevance score (1-5), and current status. Dropdown menus for status include: Identified, Researching, Ready to Contact, Contacted, Responded, Link Placed, and Declined. Conditional formatting turns rows green when a link is placed and gray when declined.
• Outreach Log: Every outreach email gets a row. Linked to the Prospect List by domain name, so you can see the full history for any prospect. Track the initial email date, up to 3 follow-up dates, whether they opened (if you use a tool like Mailtrack or Yesware), and the final response. Formulas auto-calculate average days to response and flag prospects who haven’t been followed up within 7 days.
• Links Acquired: When a link goes live, record the linking domain, the page it links to on your site, anchor text used, whether it’s dofollow or nofollow, the date it went live, and the domain authority at the time of placement. This tab is your proof of work. It’s what you show in monthly reports and client calls.
• Monthly Summary: This tab auto-populates using COUNTIFS and SUMIFS formulas. For each month, it calculates total prospects added, emails sent, responses received, links won, response rate, win rate (links per emails sent), and average DA of acquired links. A sparkline chart at the top shows your link velocity trend over the past 12 months.

1. Build your initial prospect list in Tab 1. Use Ahrefs, SEMrush, or Moz to find sites linking to your competitors. Export the top 50-100 prospects with DA 25+. Enter each one with contact details and a topic relevance score. A relevance score of 4 or 5 means the site covers your exact topic. A score of 1-2 means it’s a general site with loose topical overlap.
2. Log every outreach email in Tab 2. When you send an email, add a row. Don’t skip this step. The most common failure mode is sending outreach, forgetting to log it, and then re-contacting the same person 2 weeks later. The tracker prevents that.
3. Set follow-up reminders. The template uses conditional formatting to highlight rows where the initial email was sent 5+ days ago with no response and no follow-up. Follow up at day 5, day 10, and day 17. Three follow-ups is the standard.
4. Record acquired links in Tab 3 the day they go live. Verify each link using a browser extension like Check My Links or Ahrefs’ Site Explorer. Record the exact URL, anchor text, and link type (dofollow vs. nofollow). Don’t wait until month-end to log these.
5. Review the monthly summary in Tab 4 during your weekly standup or monthly report. If your response rate drops below 5%, your email templates need work. If your win rate is below 2%, you’re targeting the wrong prospects. The summary tab gives you the diagnostic data to fix your process.