An Example SEO Report Template for Agencies

Published January 19, 2017
One of the constantly changing questions for SEO agencies is what belongs in your SEO report template?
When building reports for clients, you want to show data that’s customized to their business goals and objectives. You know this; it’s the number one rule of reporting. For SEO reporting you need to take it a step further to present both a big picture view of traffic over time, as well as specific details about engagement, conversions, landing pages and queries.
Starting from scratch for each report can take a lot of time. Thankfully, Megalytic offers an easy-to-use interface for creating SEO report templates. Building an SEO report template will provide you with a starting point for future reports. This baseline becomes a customizable SEO report you can adapt for multiple clients.
Start by establishing the data you need to include and think about what metrics you’ll need to show from Google Analytics, Search Console, and other sources to prove your work’s value.
Whether you use the Megalytic platform or not, here are some ideas for the key data points your SEO report template should include.

image of seo template


Key Performance Indicators

At the top of your report, highlight KPIs (key performance indicators) that summarize organic search performance at a glance. Megalytic’s Multi-KPI Widget allows you to easily show multiple metrics in a concise format, comparing data to previous periods. Providing context against past months and years will help to show whether the numbers have increased or decreased over time.


KPIs for Organic Search


To customize this widget specifically for organic search, go to the Segment section of the widget options and select the Organic Traffic section. Once you’ve applied to the widget, the numbers will update to include only organic search metrics.

Overall Organic Traffic

The first thing to add to your SEO report template is an overview of organic search performance. Megalytic’s Rolling Average Comparison can compare weekly traffic to a “rolling average” of how traffic has fared over a longer period of time.


setup Megalytic organic rolling average widget


To set up this widget to show only organic sessions, click the top gear to customize the data. Next, select “Organic Traffic” from the Segment dropdown. You’ll then see the final report showing average organic traffic over your chosen time period.


Megalytic Organic Traffic Widget with Rolling Average


From this data, we see that while organic traffic has fluctuated week to week, it has remained relatively steady, with a slight upward trend heading toward the end of the year. Showing the big picture, we can encourage the client to avoid focusing on brief spikes or decreases in traffic but to look at performance over a longer period of time.

Specific Organic Metrics

Once we’ve taken in a broad overview, it’s time to dig deeper, looking at a breakdown of sessions, engagement and conversions from organic traffic for the last month. Depending on the nature of the client, it typically makes sense to compare performance to the previous month and the previous year. We’ll add the Period Comparison Table widget and customize it to display only organic traffic with select metrics.

First, use the date selector at the top of the widget to choose the target date range, along with a previous period for comparison. Next, filter to show just organic traffic. After clicking the gear symbol in the upper left of the widget to see options, select “Organic Traffic” from the Segment dropdown.


Megalytic how to select organic traffic segment


Next, use the Rows dropdown to add Completions and Conversion rate. This will allow you to look at Goals along with the default sessions, users and engagement statistics.


Megalytic how to add conversions to a Widget


After selecting these metrics, click “Apply Selection” to finalize the widget.


Megalytic compare date ranges for Organic Traffic


From this data, we can see that while total users and sessions from organic search have increased, the quality of these visits appears to have decreased. Users are spending less time on the site and looking at fewer pages. In addition, while the number of Goal completions has remained steady, conversion rate has decreased slightly.

To explain why changes have occurred in organic traffic, an SEO report template should include details on the pages accessed via organic search, along with engagement metrics for each.

Top Organic Landing Pages

To show this data, we’ll add the Traffic by Landing Page widget. After selecting a date range, we once again click the gear symbol to customize the widget. We can choose to filter with the segment dropdown to show only organic traffic, just as with the previous example.


Megalytic table of top organic search landing pages


Here, we can flag specific landing pages based on performance to see how they may be contributing to lower engagement. For example, note that people are landing directly on the /faqs/ page in search and spending much less time on the site than people who arrive via other pages. In order to address this concern, your client should consider revising the FAQs page to include calls-to-action to browse products elsewhere in the site, taking into account that people land on this page both as their first contact with the brand, but also as returning visitors looking to answer a question. To add observations like this for your client, include Notes Widgets throughout the report. This will allow you to comment on data being presented and offer suggestions for improvement.

Top Search Queries

Next, we should show the client the top queries leading people to visit the site from Google’s search results. Search Console will allow us to see how many times a site showed up for a particular search query (impressions), how many clicks from that query led people to the site, the resulting average clickthrough rate and the average position in search results.

To show this information, add the Top Queries widget and select your client’s Search Console account. You may want to exclude searches for your client’s brand name. To do this, click the gear to customize the widget and select “Show Filter” in the top of the edit area. Set up the filter to exclude mentions of the brand name. You may also need to include variant spellings depending on the volume of searches. Click “Apply” to save the filter and you’ll see a list of your top non-branded search queries.


Megalytic table of search keywords excluding branded keywords


This data can help a client see how users think when searching for a product like theirs by examining the wording of their queries. In addition, we can flag high impression keywords with low clickthrough rates, where titles and meta descriptions could be revised to better grab the attention of searchers. Finally, high impressions combined with low rankings show opportunity to optimize around these keywords to show up higher for relevant searches.

Top Pages (Search Console)

As online marketing moves increasingly toward audience-based targeting over keyword-based targeting, you should also show top organic pages. Integrating Search Console data will allow you to include pages correlated with data.

Showing this widget in addition to the Google Analytics widget (Traffic by Landing Pages) will provide additional metrics and context around how many times pages appeared in search results, helping to determine clickthrough rate. Clickthrough rate, the percentage of people who saw a search result and then clicked it, helps to demonstrate how well a page’s title and description communicate to a user searching for a relevant query and whether they’re compelling enough to get the click.

Use the Top Pages widget and select your Search Console account to include this list in you report. Note that any data from Search Console will only include a date range of up to the previous 90 days. However, if you have been maintaining a record, you can use the notes widget to provide insight on quarterly changes.


Top Search Pages Widget in Megalytic


Including External Data

Perhaps you want to show data that’s not already in Google Analytics or Search Console. Ultimately, what sets your SEO reports apart is the amount of custom data you include that can provide the client with the best possible picture of actions and performance.

For instance, you may be tracking keyword ranking data in a platform such as SEMrush. You can easily export a spreadsheet of keywords, weed through the list to include the ones most relevant to a client’s business, and upload the resulting file into a CSV widget. A simple CSV import from SEMrush for keyword position and search volume looks like this.


Keyword Position and Search Volume


For more details, see our article on spreadsheet integration with Megalytic

Finalizing Your Template

Once you’ve added all the widgets you’d like to include, taking into account showing stats for both a big picture perspective and granular details where necessary, save your template for future use. To do this, simply click the “Save as Template” button right above your report in Megalytic.


Megalytic saving a report as a template


Give your report a name, a description (optional), save it, and you’re ready to access it whenever you build your next SEO report.

To use an existing template, create a new report and select the My Templates tab. You’ll then see a list of your custom-built templates where you can choose the one you wish to use. Once you’ve created a report with a template, you can modify the widgets to reflect your desired date range and also include notes about the current stats.


Megalytic creating a report from a template



Building a template for an agency SEO report will provide you with a starting point to show results from organic search. While you should not rely solely on the same template for every client, save time by creating a template with stats that you know you will need, and move forward to customize the report to communicate the most important information to each individual client.


When the client first came to you, you talked up the value of Google Analytics. You emphasized the importance of seeing where your traffic was coming from. You went on and on about how Google Analytics can show traffic sources to pinpoint whether people came from search, social media or a specific site referral, and how valuable this data was. You sold them on it, so much so that your client looked forward to receiving that first report, the magical day when they would finally understand where visitors were coming from.
But then the report came, and it looked like this:



It showed that 10% of your client’s traffic came from “(direct)/(none)”. What does this label mean? How do you explain Direct traffic to your client? Better yet, how do you explain “none”?
Let’s take a closer look at understanding Direct traffic in Google Analytics and how we can address it with clients.
Digital marketers spend a lot of time focused on PPC and SEO campaigns in order to drive desirable traffic to a website. The phrases we’re ranking for and bidding on get meticulous attention, so much so that we often forget about some of the other ways that visitors find us.

We put a tremendous amount of the effort we put into reviewing organic search data and PPC campaign performance in analytics. But how closely do we monitor referral reports?

If that’s not a channel you review regularly, you may be missing out on seeing traffic that is coming directly from links you’ve obtained around the web, local business listings, news mentions, and more. Many times, links are only considered as a means to an end, a metric that Google uses in determining how to rank sites in the SERPs (search engine results pages). But the fact is, many of a site’s links may be directly contributing to its traffic.

In this article, we’ll review how to look at referral reports in Google Analytics, and some of the many ways to use that data to better inform your web marketing decisions.


Remember how your mom told you not to stand too close to the television because it might hurt your eyes?

The same rules can apply to data. If you’re too close, you may miss the patterns and trends that are crucial to understanding your website’s performance. You can’t judge a site’s performance looking at data in the bubble of a single day, you must consider any day’s traffic compared to the days before and after.

Google Analytics makes it fairly easy to analyze trends over long periods of time. But it also allows you to stand right in front of that TV, to look at more granular levels of time, right down to the hour.
There’s a better way to get that close to the data, without burning your retinas. We’ll cover how to analyze traffic effectively in today’s post.