Most link building reports are a mess.

A spreadsheet here. A Google Doc there. Screenshots from Ahrefs pasted into Slack. Numbers that don’t match across tools. Clients asking “what did we get for the £4,000 last month” and you trying to answer with whatever you can find.

Looker Studio fixes this. One dashboard. Live data. Auto-updating. Free.

This article gives you the full blueprint — every page, every metric, every data source, every calculation — to build a working link building dashboard yourself in about 90 minutes. No paid template required. Section 1 is the build blueprint (start there). The rest of the article explains why each metric matters, how to interpret what you’re seeing, and the calculations that turn raw backlink data into actual ROI numbers a client will believe.

Quick note before we start: in April 2026, Google renamed Looker Studio back to Google Data Studio. Same product, same templates, same connectors. I’ll keep calling it Looker Studio throughout this article because that’s what most people still call it, but if you see “Google Data Studio” in your Google account, it’s the exact same thing.

The link building dashboard blueprint: 5 pages, copy-and-build

Here’s the full structure. Build these five pages, in this order, with these data sources. That’s the whole dashboard.

Page	What it shows	Key visualisations	Data sources
1	Executive Summary	Scorecards: total backlinks, referring domains, average DR, organic conversions. Single trend chart: links acquired over time.	Ahrefs Site Explorer + GA4
2	Backlink Acquisition	New/lost links monthly bar chart, referring domain growth, anchor text distribution pie, DR bucket distribution.	Ahrefs Site Explorer (or Semrush Backlink Analytics)
3	Ranking Impact	Target keyword position over time, position distribution histogram, top-gaining vs top-losing keywords table.	Ahrefs Rank Tracker + Google Search Console
4	Traffic & Revenue	Non-brand organic traffic trend, conversion trend, attributed revenue scorecard, revenue per link calculation.	GA4 + Google Search Console
5	Campaign Log	Manual table of placements (date, URL, DR, target page, anchor, status). Filter by campaign/client.	Google Sheets (manual entry)

The data source stack you need

Five connectors. Four are free, two need paid plans.

Connector	Cost	Plan required	Used for
Google Analytics 4	Free	Any GA4 account	Traffic, conversions, revenue
Google Search Console	Free	Any GSC account	Keyword positions, impressions, clicks
Google Sheets	Free	Any Google account	Campaign log, outreach status
Ahrefs Site Explorer	Paid	Advanced plan or higher	Backlinks, referring domains, anchors
Ahrefs Rank Tracker	Paid	Advanced plan or higher	Keyword ranking changes

If you don’t have Ahrefs, Semrush works the same way — Position Tracking (rankings) and Backlink Analytics (backlinks) both have Looker Studio connectors. Per Swydo’s 2026 connector roundup, Semrush Position Tracking requires the Guru plan at $249.95/month, and Ahrefs Looker Studio connectors require the Advanced plan or above (confirmed on the Ahrefs Looker Studio connector page). If you have neither, build pages 3 and 4 first using GSC alone — you’ll get 70% of the value at zero cost.

The 90-minute build sequence Minutes 0–15: Set up data sources. Connect GA4, GSC, Sheets first (free, fastest). Add Ahrefs/Semrush after if available. Minutes 15–45: Build page 1 (Executive Summary). Get the four scorecards and one trend chart working. This is the only page most stakeholders will look at — make it solid. Minutes 45–75: Build pages 2 and 3 (Backlink Acquisition + Ranking Impact). Use Ahrefs/GSC native chart types — don’t over-engineer. Minutes 75–90: Build pages 4 and 5 (Traffic & Revenue + Campaign Log). Page 5 is just a connected Sheet — five minutes max.

Why bother with a dashboard at all?

Three reasons. Be honest about which one applies to you.

Reason 1: You’re an agency that needs to justify retainers

This is the biggest one. Clients pay £3,000–£15,000/month for link building. They want to see what they’re getting. A monthly PDF with 30 screenshots from different tools doesn’t build confidence. A single live dashboard does.

The dashboard becomes part of the client relationship. They check it themselves between calls. Renewals get easier. Scope conversations get easier. You stop being a black box.

Reason 2: You’re in-house and your boss keeps asking “is this working”

Same dynamic, different stakeholder. CMO or VP Marketing wants to know if the SEO budget is producing returns. You want to keep the budget. A live dashboard answers the question once and then keeps answering it without you having to re-make the deck every quarter.

Reason 3: You actually want to run a better programme

This is the underrated one. Most link builders don’t track the right things, so they don’t know what’s working. They build links, hope, and check ranking changes occasionally. A proper dashboard makes patterns visible — which link types correlate with ranking moves, which target pages convert best after authority improvements, where the wasted spend is.

If you only build a dashboard for client reporting, you’re missing 60% of the value.

Concrete example. In our experience auditing dashboards for SEO teams, the single most common pattern we see is mismatched effort and outcomes — agencies spending 60% of their outreach time on guest posts that produce 15% of the ranking lift, while data studies producing 65% of the lift get 20% of the time. Nobody can see the mismatch until the dashboard makes it visible. Once it’s visible, the team reallocates effort in the next quarter and outcomes improve immediately. The dashboard pays for itself in the first reallocation decision.

Building page 1: the Executive Summary

This page exists for one purpose: to answer “is the link building working” in five seconds. Stakeholders who only look at one page will look at this one. Get it right.

The four scorecards

Put these four numbers at the top of the page, in this order, with month-over-month % change as a comparison metric:

Total referring domains — from Ahrefs Site Explorer. The headline link building number. Counts unique domains linking to your site, not total links.
New referring domains (this month) — from Ahrefs Site Explorer, filtered to current period. Shows campaign output specifically.
Average DR of new links — calculated field in Looker Studio. Quality indicator. New links averaging DR 25 means you’re earning weak placements; DR 50+ means tier-2 and up.
Non-brand organic conversions — from GA4, filtered to exclude branded search queries. The downstream business outcome.

Don’t add a fifth scorecard. Four numbers is the maximum a stakeholder will absorb in five seconds. If you make it eight, they remember none of them.

The trend chart

Below the scorecards: one line chart showing new referring domains per month for the last 12 months. Overlay with non-brand organic conversions per month on a secondary axis.

This single chart shows whether your link building is producing downstream organic results. If the link line goes up and the conversion line follows 2–4 months later, you have proof the programme is working. If the link line goes up and the conversion line stays flat, you have proof you’re earning low-impact links.

This isn’t theory. The mechanics map directly onto the attribution thinking we covered in the link building attribution models article — links drive ranking lift, ranking lift drives traffic lift, traffic lift drives conversions, with a 4–16 week delay. The trend chart makes that lag visible.

Building page 2: Backlink Acquisition

This is where you prove campaign work happened and where you spot quality drift before it kills results.

Chart 1: New vs lost referring domains (bar chart, monthly)

Two-colour bar chart. Green for new domains, red for lost. By month.

Why this matters: link decay is the silent killer of link building programmes. Sites take old links down. Pages get redirected. Domains expire. If you’re losing 12 referring domains a month and earning 14, your net growth is 2 — but the total backlinks dashboard makes it look like 14. The lost domains chart catches the leak.

Chart 2: Referring domain growth (cumulative line chart)

Single line, climbing (hopefully) over 12+ months. This is the chart you screenshot for case studies.

If the line is flat or declining, you have a leak somewhere — either you’re not earning new links fast enough, or you’re losing them faster than you’re earning them. Either way, the chart forces the diagnostic conversation.

Chart 3: Anchor text distribution (pie chart)

Pie chart split into five buckets: branded anchors, naked URL anchors, exact-match keyword anchors, partial-match keyword anchors, generic anchors (“click here”, “learn more”).

Healthy distribution for most sites in 2026: 40–55% branded, 15–25% naked URL, 5–10% exact-match keyword, 15–25% partial-match, 10–15% generic. These are general industry guidelines — there’s no single canonical source, so treat the bands as directional rather than precise. If exact-match anchor percentage climbs above 15%, you’re at over-optimisation risk.

Chart 4: DR bucket distribution (column chart)

Bar chart with five buckets: DR 0–20, 21–40, 41–60, 61–80, 81–100. Shows what quality of links you’ve earned over the period.

This is the chart that exposes weak campaigns. If 70% of your new links are DR 0–20, you’re earning from low-quality sites that won’t move rankings on competitive terms. If you have a healthy spread with at least 15% DR 60+, your authority is compounding properly.

Building page 3: Ranking Impact

This is where you connect links to actual ranking outcomes. Most link builders don’t build this page and then wonder why clients churn.

Chart 1: Target keyword position over time

Line chart, one line per target keyword, position on the Y-axis (inverted — position 1 at the top), time on the X-axis. Filter by the 10–30 keywords that actually matter commercially.

Don’t put 200 keywords on this chart. Nobody will read it. Pick the commercial-intent keywords where ranking improvements drive business outcomes — the framework for picking those keywords is covered in the link building strategies guide.

Chart 2: Top-gaining and top-losing keywords (two tables)

Side-by-side tables. Top 10 keywords by position improvement on the left. Top 10 keywords by position loss on the right. Both showing: keyword, starting position, current position, change.

This is the page clients spend the most time on after the executive summary. Specific keywords moving up answers the “what did the budget do” question concretely. “We moved ‘PA recruitment London’ from position 14 to position 4” is a real answer.

Chart 3: Position distribution histogram

Bar chart showing how many tracked keywords are in each position bucket: 1–3, 4–10, 11–20, 21–50, 51+.

Run it month-over-month. The shift you want to see: keywords moving from the 11–20 bucket up to 4–10 bucket, then from 4–10 up to 1–3. If keywords are stuck in 51+, you have a topical authority problem that links alone won’t fix.

Building page 4: Traffic & Revenue

Where it stops being abstract and starts being commercial. This page answers “what is the money number”.

Chart 1: Non-brand organic traffic (line chart, monthly)

Crucial: filter out branded queries. Branded organic traffic should never be in a link building dashboard. Branded search reflects existing demand, not link-driven discovery. Build a filter in GSC for queries that don’t contain your brand name, then use that filtered dataset.

If you don’t filter brand out, you’ll show traffic growth in a PR-heavy month and look like a hero, when actually the traffic was people Googling your brand after seeing a piece of PR. That growth has nothing to do with the link building component.

Chart 2: Organic conversion trend

From GA4. Non-brand organic conversions per month. Compare against the link acquisition line from page 1.

The 4–16 week lag between link acquisition and conversion lift is consistent in published Ahrefs and Moz data. You should expect to see the conversion line follow the link line with a delay. If it doesn’t, either the links aren’t quality enough to move rankings, or your conversion paths are broken for reasons unrelated to link building.

Chart 3: Attributed revenue scorecard

Single number, hero-sized. Total revenue from non-brand organic in the reporting period.

If you can sync deal source data from your CRM back to GA4 via offline conversion uploads (B2B), do it — the revenue number gets much more accurate. For the detailed mechanics, the link building ROI guide covers the calculations and the link building attribution article covers what to do when last-click is hiding most of your real ROI.

Chart 4: Revenue per link (calculated field)

This is the killer metric. Total attributed revenue divided by total new referring domains in the period. Single scorecard, big number.

It contextualises every other metric. Revenue per link of £2,800 means a programme spending £400 per link is producing 7x ROI. Revenue per link of £40 means something is broken — either the links are too weak, the target pages don’t convert, or the attribution is missing the upstream value (which is more common than people think — see the attribution article for the diagnosis).

Building page 5: the Campaign Log

Page 5 is the simplest and weirdly the most useful page in the entire dashboard.

Connect a Google Sheet with these columns: date placed, target URL on your site, placement URL (the page hosting the link), publisher, publisher DR, anchor text, link type (editorial/guest post/digital PR/listicle/etc), campaign name, status (live/lost/pending/rejected).

Update it manually after every confirmed placement. Display as a filterable table on page 5. That’s the entire page.

Why this is more valuable than it sounds:

It forces the discipline of logging every placement. Half of link building agencies don’t do this consistently and lose track of campaigns.
It becomes the source of truth for which campaigns produced which links — connecting outputs back to specific outreach efforts.
Filtering by campaign or client makes monthly invoicing and reporting trivial.
When you eventually want to do retrospective analysis (“which campaigns earned us our highest-DR links”), the data is already there.

The four calculated fields that turn this from a dashboard into a tool

These aren’t standard metrics. You build them yourself as calculated fields in Looker Studio. They’re what separate a real link building dashboard from a generic SEO report.

1. Cost per referring domain (CPRD)

Formula: Total link building spend / new referring domains earned.

Where to add it: scorecard on page 4 next to revenue per link.

What it tells you: campaign efficiency. CPRD under £200 suggests cheap placements (likely low quality). CPRD between £400 and £900 is typical for editorial outreach in 2026. CPRD above £1,500 is digital PR or tier-1 placements — high-quality, low-volume work.

2. Average DR weighted by link count

Formula: Sum of (DR × number of links from each domain) / total link count.

Why weighted matters: a site with 1 link from DR 80 and 30 links from DR 10 has an unweighted average of DR 45 but a weighted average of around DR 12. The weighted number tells the truth.

3. Topical relevance score

This one’s manual but worth it. In your Google Sheet campaign log, add a column scoring each placement on relevance 1–10 (1 = generic blog, 10 = direct vertical match).

Display average topical relevance as a scorecard. If the average drops below 6, you’re earning links from sites that won’t pass much value to Google’s topical authority signals. The number forces the team to vet placements properly rather than chasing volume.

4. Link velocity (rolling 90-day average)

New referring domains per 90 days, on a rolling basis. Display as a trend chart.

Flat velocity = stagnant programme. Climbing velocity = compounding programme. Spiky velocity (big peaks and troughs) = campaign-driven rather than systematic, which is the most common pattern and usually a sign that you’re treating link building as a project rather than a process.

Five dashboard mistakes I see all the time

Mistake 1: Including total backlinks instead of referring domains

Total backlinks is a vanity number. A single site linking to you 200 times counts as 200 backlinks but the SEO value is roughly the same as one link. Always use referring domains as the headline metric. Total backlinks goes in a hidden detail page if anywhere.

Mistake 2: Showing branded organic traffic in the same chart as non-brand

They behave completely differently. Branded traffic reflects existing brand recognition; non-brand traffic reflects new discovery driven by SEO and links. Mixing them in the same chart hides everything that matters.

Mistake 3: No filter for date range

Make the entire dashboard filter on a single date range control at the top of page 1. Every chart should respond. Without this, the dashboard works for one fixed period and breaks the moment anyone wants to look at a different month.

Mistake 4: Hard-coded data instead of calculated fields

If you’re typing numbers into text boxes (“Total spend: £4,200”), you’re going to forget to update one of them. Connect everything to live data. If it can’t be live, connect it to a Sheet that gets updated in one place. Manual numbers scattered through the dashboard always end up wrong.

Mistake 5: Too many pages

Five pages is the cap. Stakeholders won’t read beyond that. If you find yourself wanting page 6 and 7, you’re either trying to dump every Ahrefs metric onto a dashboard (don’t), or you should build a separate technical SEO dashboard and link to it.

Frequently asked questions

Is Looker Studio actually free?

Yes — Looker Studio (Google Data Studio) is completely free: unlimited reports, unlimited pages, unlimited sharing, no paid tier. The paid components are the data connectors for third-party tools (Ahrefs, Semrush, Supermetrics, Porter Metrics) — if you only need Google products (GA4, GSC, Sheets), the entire dashboard is free.

Do I really need both Ahrefs and Semrush?

No. Pick one. Both have Looker Studio connectors for backlinks and rankings. The connectors aren’t compatible with each other so don’t try to use both at once. Choose based on which tool you already pay for.

What if I can’t afford either Ahrefs or Semrush?

Build pages 3 and 4 first using GSC alone. You get keyword positions, impressions, clicks, and CTR without paying for anything. You miss the backlink-side data (pages 1 and 2), but you have enough to demonstrate ranking and traffic outcomes — which is most of what clients actually care about. Add Ahrefs or Semrush later when budget allows.

Can I white-label the dashboard for clients?

Yes. Add your logo to the header, use the client’s brand colours, set view-only sharing permissions, and disable data download if you want to protect methodology. Most agencies build one template and clone it per client, with each clone connected to that client’s specific data sources.

How often does the dashboard refresh?

GA4 and GSC data refreshes natively in Looker Studio every 12 hours by default. Ahrefs and Semrush connectors refresh based on their plan — typically daily on standard plans. Google Sheets data is real-time. For client-facing dashboards, this is fine — nobody needs hourly refreshes on link building data.

Should I email PDFs of the dashboard or just share the live link?

Share the live link as the primary delivery. PDFs are a fallback for clients who insist on static reports. Most senior marketing stakeholders prefer the live link — they can dig in when they have questions rather than waiting for the next monthly call.

What about adding paid ads data to the same dashboard?

Don’t. Link building has different timescales, different attribution challenges, and different stakeholder questions than paid media. Mixing them creates a dashboard that does neither job well. Build a separate paid ads dashboard if needed.

How do I handle multiple clients on one Looker Studio account?

Build the template once. Save it as a Master Template in your Looker Studio. For each client, copy the template and rebind the data sources to their accounts. Most agencies organise dashboards into folders by client. The template-and-copy pattern means a structural improvement to the master propagates to every client dashboard when you re-link.

Closing

The five-page structure above isn’t the only way to build a link building dashboard. It’s just the version that survives client meetings and answers the questions stakeholders actually ask.

Start with page 1. Get the four scorecards and the trend chart working. Show it to one client. They’ll have questions. Their questions are the brief for what to build next.

The single biggest mistake people make with Looker Studio dashboards is over-engineering them before anyone has used one. Build the minimum version. Get feedback. Iterate. The dashboard exists to drive conversations and decisions, not to look impressive in a screenshot.

For the broader measurement series this dashboard supports, the link building ROI guide covers the financial calculations, the link building forecasting article covers turning historical data into projections, and the link building attribution models article covers what the dashboard’s revenue numbers are actually measuring (and what they’re missing). For the strategic picture of which tactics deserve dashboard tracking in the first place, the complete guide to link building strategies sets the scope.