SEO Report Template for Link Building (Free Sample + SEO Experts Opinion)
An SEO report template is a ready-made structure that shows a client what changed in search this month, why it changed, and what happens next. For link building and guest post campaigns, it must also prove every link: is it live, is it indexed, what anchor does it use, and did the target page move up. The free template and filled sample below cover all of it using only free Google tools.
What Is an SEO Report Template?
An SEO report is a regular summary of how a website performs in organic search. An SEO report template is the fixed structure you reuse every month, so only the numbers and comments change.
Three documents often get mixed up:
- SEO audit: a one-time check that lists problems and fixes.
- SEO report: a monthly update that tracks whether the work is paying off.
- SEO dashboard: a live data screen with no explanation.
Only the report has to explain itself. A dashboard can show that clicks rose 12%. A report says why they rose, which links or pages caused it, and what you will do next month.
A dashboard shows numbers. A report tells the client what those numbers mean for their money.
Why Do Most SEO Report Templates Fail Link Building Clients?
We studied the pages that rank on the first page of Google for “seo report template” and “seo report sample.” They are well made, but they share the same gaps:
- Backlinks get one slide. Most templates show new referring domains sorted by a tool score. Nothing about anchor text, link attribute, indexing or placement.
- Some treat link building as out of scope. One popular sample report lists new referring domains “for context only” because link building was not part of the contract.
- They depend on paid tools. Several templates need Ahrefs, Semrush or a paid connector before they work.
- They use outdated steps. Older guides still point to Universal Analytics menus that no longer exist in Google Analytics 4.
- Many have no AI search section. Clients now ask whether their brand appears in Google AI Overviews and ChatGPT.
- Few show a filled example. An empty template with fake placeholder data does not teach you how to write the commentary.
Key insight: A link building client does not judge you by Domain Rating. They judge you by three things: the link exists, Google can see it, and the target page moved. Your report must prove all three for every single link.
What Should an SEO Report Include in 2026?
The structure below works for agencies, freelancers and in-house teams. Sections 5 and 6 are what make it a link building report.
| # | Section | What it answers | Free data source |
|---|---|---|---|
| 1 | Executive summary | What changed, why, and what the client must decide | Written by you |
| 2 | Search performance | Are clicks and impressions growing, beyond brand searches? | Google Search Console |
| 3 | Traffic and conversions | Do visits turn into leads or sales? | Google Analytics 4 |
| 4 | Keyword rankings | How did the money keywords move? | Search Console |
| 5 | Links built this month | Which links went live, where, with which anchor? | Your link log + Google search |
| 6 | Link health and impact | Are links live and indexed? Did target pages improve? | Search Console Links report |
| 7 | AI search visibility | Is the brand shown or cited in AI answers? | Search Console, GA4, prompt log |
| 8 | Technical health | Can Google crawl and index the important pages? | Search Console Pages report |
| 9 | Next month | The plan, the owner and the expected result | Written by you |
Keep the full report between 4 and 8 pages. A CEO usually reads page 1 only, so the executive summary must stand on its own.
The Link Building Section Most Templates Skip
This is the part that separates a professional link building report from a generic one. For every link delivered in the month, record these 10 fields:
- Publishing site β the domain where the guest post or link lives.
- Live URL β the exact page, so the client can click and check.
- Date published β needed for the 30 to 90 day impact check.
- Target page β which page on the client site the link points to.
- Anchor text β the clickable words used in the link.
- Anchor type β branded, exact match, partial match, URL or generic.
- Link attribute β dofollow, nofollow or sponsored.
- Indexed? β yes or no, checked at least 14 days after publishing.
- Site organic traffic β an estimated monthly figure, so the client sees it is a real site, not a link farm.
- Status β live, removed, or changed since last month.
Why does indexing matter so much?
A link on a page that Google has not indexed passes no value. In our experience, a well-placed guest post on a healthy site is usually indexed within 3 to 14 days. If a page is still not indexed after 30 days, flag it in the report and replace or fix it. Hiding unindexed links is the fastest way to lose a client’s trust.
Why should you report the anchor text mix?
Too many exact match anchors can look manipulative. Google’s spam policies list link schemes, including excessive keyword-rich anchor links, as a violation. Show the client a simple anchor mix each month, for example:
- Branded anchors: 40β50%
- Partial match anchors: 20β30%
- URL and generic anchors: 15β25%
- Exact match anchors: under 10%
These ranges are a safe working guide, not a Google rule. Adjust them to the niche and to the competitors that already rank.
Should paid links be marked as sponsored?
Google asks site owners to qualify paid links with rel="sponsored" or rel="nofollow", as explained in its guide to qualifying outbound links. Your report should record the real attribute of each link, so the client always knows exactly what they received.
If a link is not live, not indexed, or not in the report, the client should assume it does not exist.
Expert opinion: Michal PecΓ‘nek, SEO marketer at Ahrefs
In his widely read guide to SEO reporting, Michal PecΓ‘nek warns that “your work doesn’t end with just dumping a bunch of metrics into a document.” He advises reporting backlink growth only when your own work actually earned those links, and highlighting links that came from outreach so the client can tell earned links apart from ones they would have received anyway.
He also points out that the executive summary is often the only page a CEO reads, so the most important wins and next steps must sit right at the top.
Michal has more than 6 years of SEO experience and was previously Head of Marketing at CDN77, one of the fastest-growing European B2B startups. He also consults SaaS companies on SEO and marketing.
His advice fits link building reports perfectly. When link building is your main service, every link in the report should be one you placed, with proof attached. That is exactly what the 10-field link log above provides.
SEO Report Sample: A Filled Monthly Example
Illustrative sample: the business and all numbers below are fictional. They show how each section should be written, not real client data.
Client: an online home furniture store. Period: October 1β31, 2026 (31 days), compared with August 31 to September 30 (31 days, so the comparison is fair). Service: monthly guest posting and on-page SEO.
1. Executive summary
- Verdict: the “wooden dining table” category page moved from position 18 to 9 after 4 new guest post links.
- Up: non-brand clicks 5,400 (September: 4,600, +17%). Organic orders 62 (September: 51, +22%).
- Watch: 1 of 8 new links is not indexed yet (published 9 days ago).
- Decision needed: approve 4 links to the “office chairs” page next month.
2. Search performance (Search Console)
| Metric | October | September | Change |
|---|---|---|---|
| Total clicks | 8,900 | 7,800 | +14.1% |
| Impressions | 412,000 | 355,000 | +16.1% |
| Brand clicks | 2,100 | 2,050 | +2.4% |
| Non-brand clicks | 5,400 | 4,600 | +17.4% |
Comment: growth comes from non-brand searches, which is the part SEO controls. Brand plus non-brand (7,500) is lower than the total (8,900) because Search Console hides rare, anonymized queries whenever a filter is applied. Google explains this in its performance data deep dive.
3. Traffic and conversions (GA4)
| Metric | October | September | Change |
|---|---|---|---|
| Organic sessions | 10,300 | 9,100 | +13.2% |
| Organic orders (key event) | 62 | 51 | +21.6% |
| Organic revenue | $14,880 | $12,240 | +21.6% |
4. Keyword rankings (tracked: 30 keywords)
- Winner: “wooden dining table” β position 18 β 9.
- Winner: “solid wood bed frame” β position 12 β 7.
- Loser: “small sofa for apartment” β position 6 β 10 after a competitor updated its guide.
5. Links built this month
| Site (example) | Traffic/mo | Target page | Anchor | Type | Attribute | Indexed |
|---|---|---|---|---|---|---|
| homedecorblog.example | 38,000 | /dining-tables | BrandName | Branded | Dofollow | Yes |
| interiorideas.example | 22,500 | /dining-tables | wooden dining tables | Partial | Dofollow | Yes |
| livingspaces.example | 51,000 | /dining-tables | this furniture store | Generic | Dofollow | Yes |
| diyhomeguide.example | 17,800 | /dining-tables | brandname.com | URL | Dofollow | Yes |
| smallhomes.example | 29,000 | /bed-frames | solid wood bed frame guide | Partial | Dofollow | Yes |
| cozyrooms.example | 14,200 | /bed-frames | BrandName | Branded | Dofollow | Yes |
| renterhome.example | 21,000 | /sofas | read the full guide | Generic | Dofollow | Yes |
| homemakers.example | 12,600 | /sofas | BrandName | Branded | Dofollow | Not yet |
Comment: 8 links went live, 7 are indexed. The last one was published 9 days ago and will be rechecked on day 14. Anchor mix this month: 3 branded, 2 partial, 2 generic, 1 URL, and 0 exact match.
6. Link health and impact
- Total links delivered since the campaign started: 31. Still live: 31 (100%).
- Indexed: 30 of 31 (97%).
- Impact check (links older than 60 days): the /dining-tables page gained 9 positions and 640 more clicks than in July.
7. AI search visibility
- Sessions from ChatGPT, Perplexity, Gemini and Copilot: 96 (September: 61).
- Prompt check (10 questions Γ 3 AI tools): brand named in 7 of 30 answers (September: 5 of 30). Reported as a trend to watch, because the sample is small.
8. Technical health
- Indexed pages: 412 (September: 398). No Core Web Vitals URL group failing.
9. Next month
- Build 4 links to /office-chairs (owner: outreach team; metric: position for “ergonomic office chair”).
- Refresh the “small sofa for apartment” guide (owner: content writer; metric: back into the top 6).
- Recheck the 1 unindexed link on day 14 and replace it if it is still not indexed by day 30.
Quick win this week: open your last SEO report and add two columns to the backlinks table: “Indexed?” and “Anchor type.” That single change answers the two questions link building clients ask most.
Copyable SEO Report Template
Copy this into Google Docs, Word or a slide deck. Delete any section that is outside your contract instead of leaving it empty.
Period: [start] to [end] ([n] days)
Compared with: [start] to [end] ([same n] days)
Prepared for: [name, role] Prepared by: [name]1. EXECUTIVE SUMMARY
Verdict: [one sentence: is SEO moving toward the goal?]
Up: [metric, value, change, cause]
Watch: [metric, value, why it is not a problem yet]
Down: [metric, value, cause, fix]
Decision needed: [what, by when]2. SEARCH PERFORMANCE (Search Console)
Clicks [n] ([+/-%]) | Impressions [n] ([+/-%])
Brand clicks [n] | Non-brand clicks [n] | Anonymized [n]
Comment:
3. TRAFFIC AND CONVERSIONS (GA4)
Organic sessions [n] | Key events [name: n] | Revenue [n]
Comment:
4. KEYWORD RANKINGS ([n] tracked)
Winners: [keyword, from, to, why]
Losers: [keyword, from, to, why, plan]
5. LINKS BUILT THIS MONTH
[site] | [live URL] | [date] | [target page] | [anchor] | [anchor type] | [attribute] | [indexed] | [site traffic]
Anchor mix: branded [n] | partial [n] | exact [n] | URL [n] | generic [n]
6. LINK HEALTH AND IMPACT
Total links delivered [n] | Still live [n] | Indexed [n]
Target pages checked after 60+ days: [page, position before, position now, clicks change]
7. AI SEARCH VISIBILITY
Sessions from AI tools [n] | Prompt check: brand named [n of N]
8. TECHNICAL HEALTH
Indexed pages [n] | Main issue [type: n] | Core Web Vitals [status]
9. NEXT MONTH
[action] | [owner] | [metric] | [date]
Notes: [launches, campaigns, Google updates or outages that affect the data]
For the link log, create a Google Sheet with these 10 columns: Site, Live URL, Date, Target Page, Anchor, Anchor Type, Attribute, Indexed, Site Traffic, Status. Add one row per link and copy the month’s rows into section 5.
How Do You Build an SEO Report With Free Tools Only?
You do not need a paid tool to produce a professional report. Here is where each number comes from:
- Clicks and impressions: Search Console β Performance β Search results. Set custom dates with an equal number of days.
- Brand vs non-brand: add a Query filter that contains your brand name, then one that does not contain it.
- Organic sessions: GA4 β Reports β Acquisition β Traffic acquisition, then look at the “Organic Search” channel row.
- Conversions: mark purchases, form submits or calls as key events in GA4 Admin, then view them in the same traffic acquisition report.
- Your backlinks: Search Console β Links β Top linking sites. It updates slowly, so keep your own link log as the main record.
- Indexing of a guest post page: search Google for the exact page URL or a unique sentence from the post in quotes.
- Technical health: Search Console β Indexing β Pages, and Experience β Core Web Vitals.
Building the report by hand takes about 60 to 90 minutes the first time. Once your link log and template are ready, most monthly reports take 30 to 45 minutes. If you manage more than 10 clients, a free Looker Studio dashboard connected to Search Console and GA4 can save further time, but always keep the written summary on top.
Expert opinion: Zeyuan Gu, founder of Adzviser
In his guide to free SEO report templates, Zeyuan Gu sums up the real pain of monthly reporting: “The worst part of an SEO report isn’t writing it. It’s rebuilding it.” He explains that SEO data is spread across several tools, so most people export, reformat and rebuild the same charts every 30 days.
His fix is to treat the report as something that is already running: a template with the layout and charts in place, so a build that once took about two hours turns into a read of roughly ten minutes. The saved time then goes into commentary, which he sees as the only part a client truly pays for.
Zeyuan Gu builds marketing data connectors and report templates for agencies, in-house marketers and startups at Adzviser.
For link building teams, the same idea applies to the link log. Keep one master sheet that you update the day each link goes live. At the end of the month, the links table is already finished and you only write the comments.
How Do You Report AI Search Visibility?
Clients now ask whether their brand appears in Google AI Overviews, ChatGPT and Perplexity. Keep this section short and honest:
- AI clicks are already inside Search Console. Google says on its AI features page that traffic from AI features is counted in the overall Performance report, under the Web search type. Mention this so the client does not expect a separate number.
- Track AI referral sessions in GA4. Create a custom channel group that catches chatgpt.com, perplexity.ai, gemini.google.com and copilot.microsoft.com.
- Run a fixed prompt check. Write 10 to 20 questions a buyer would ask, run them in the same AI tools each month, and count how often the brand is named or linked.
Strong links help here too. Pages that earn mentions on trusted, relevant sites are more likely to be seen as credible sources, which is one more reason to report link quality, not just link count.
7 Red Flags in a Link Building Report
If you buy link building, use this list to judge the report you receive. If you sell it, make sure your report has none of these:
- No live URLs. If you cannot click and see the link, you cannot verify it.
- No indexing status. Unindexed links pass no value.
- Only a tool score. DR or DA alone says nothing about traffic or relevance.
- No anchor text column. You cannot spot an unsafe anchor mix.
- No target page results. Links should be tied to a page whose rankings you track.
- Removed links hidden. A good report shows links lost, not just links gained.
- Unequal date ranges. A 31-day month against a 30-day month makes trends unreliable.
Frequently Asked Questions
What is the best SEO report template?
The best SEO report template is one that matches the service you sell. For link building and guest posting, choose a template with a per-link table (live URL, anchor, attribute, indexing) and an impact section that tracks the target pages.
How often should you send an SEO report?
Monthly is the standard. Search data moves slowly, so weekly numbers are mostly noise. A short weekly note listing links that went live is fine during an active campaign.
How long does it take for a backlink to show results?
In most campaigns, a target page starts to move 4 to 12 weeks after its links are indexed. That is why the report should check impact on links that are at least 60 days old.
Can I make an SEO report without Ahrefs or Semrush?
Yes. Google Search Console, Google Analytics 4, Google Sheets and a simple link log cover every section of the template above.
What is a good SEO report sample for clients?
A good SEO report sample has a one-page summary, real comparisons with equal date ranges, a comment under every number and a clear plan for next month. The filled example in this guide follows that format.
Should an SEO report include lost backlinks?
Yes. Showing removed or changed links builds trust and lets you replace them quickly, often within the same month.
What Do SEO Reporting Experts Agree On?
The two experts quoted in this guide come from different sides of SEO. Michal PecΓ‘nek writes for one of the biggest SEO tool companies, while Zeyuan Gu builds reporting connectors for agencies. Yet their advice points in the same direction:
- Commentary beats raw data. Michal stresses interpreting every metric for the client, and Zeyuan argues that commentary is the real value of a report. Both agree that a page of charts with no explanation is not a report.
- Lead with the summary. Michal notes that senior readers often stop after the first page, so the wins, risks and next steps must come first.
- Stop rebuilding from zero. Zeyuan shows that a fixed template turns a two-hour monthly task into a short review, leaving more time for analysis.
- Report only what your work caused. Michal advises separating links you earned through outreach from links that would have arrived anyway.
Our view after 1,000+ guest posting projects
We would add one point that both general guides leave out: in link building, proof matters more than presentation. A simple Google Sheet that lists every live URL, anchor, attribute and indexing status will earn more client trust than a polished slide deck with a single Domain Rating chart. Combine the experts’ advice with a complete link log, and your report will answer every question before the client asks it.
Start Reporting the Right Way Now
Use this checklist before you send your next report:
- Compare two periods with the same number of days.
- Split brand and non-brand clicks in Search Console.
- List every link with its live URL, anchor, attribute and indexing status.
- Show the anchor mix and keep exact match anchors low.
- Check rankings and clicks for every target page with links older than 60 days.
- Add a short AI search visibility section.
- End with 3 to 5 actions, each with an owner and a metric.
A clear SEO report template turns link building from a promise into proof. Copy the template, fill in this month’s numbers and send a report your client can actually trust. Start this week.