SEO Reporting: How to Build Meaningful Analytics Reports

If you are interested in a custom dashboard or an Analytics audit, and would like our help, please don’t hesitate to contact us.

—

The SEO report. It is a calling card for some agencies. Smart companies use APIs to compile reports without spending manual hours. Some rely on automatic SEO reporting tools. For other companies, it’s a time-intensive and considerably low-value exercise.

The SEO report should be a tool by which you can gain insights and build powerful campaigns for organic search. You might think of this as a client deliverable, or a monthly expectation to appease your boss, but an effective SEO report is much more than that. It will give you an at-a-glance overview of your performance and will allow you to spot problems and opportunities. It can cover everything from organic traffic, external and internal link building, social media, and more.

What is an SEO Report and What Should it Cover?

For those entering the field, an SEO report is a common name given to any type of document meant to inform the viewer of their SEO status. But there’s no value in creating any kind of report if the data can’t help you answer questions.

Here are some important questions that should be answered quickly and effectively by your SEO report:

1. What does the data tell me about our visitors?
2. What direction should I take based on the data?
3. Why is “X” happening?
4. What dubious claims and theories can we correct?
5. What campaigns should we renounce, and how can I change direction for the better?
6. What data can I use to sell back the SEO investment?

What Metrics Should Be Included in Your SEO Report?

At Greenlane, we develop reports with a data-first philosophy, to which the KPIs that move your business are primary. Sure, we include the obligatory ranking, traffic, and conversion data, but we want to benchmark against the particulars that your business is based on. If our client hasn’t developed a KPI set or set goals for our SEO engagement, we will help them come up with a realistic plan. We do everything in our power to make sure keyword rankings aren’t the main KPI.

Although SEO ranking reports are traditional, rankings are an imperfect metric. Expect flux in search engine rankings. Keywords that typically perform for a business can appear lower in the results on any given day. It’s important that a report doesn’t capture a snapshot of rankings (like a monthly report). If a keyword is down on the day you compile the report, but high on other days, you’re going to get a faulty signal.

Some metrics that I focus on in addition to keyword rankings:

• Organic traffic
• Conversions
• Time on page
• Bounce rate
• Revenue

Below is a ranking trend for a keyword that has much competition. If this report was made around 5/15/2018, it would look like a victory with a top 10 ranking. In truth, this is a keyword that is not performing well.

Instead, you should make sure to reflect the average position. The average position for the keyword above is position 48. This represents organic visibility in a clear and digestible way.

It’s important to group keywords to appropriate landing pages. Instead of thinking of each keyword on its own, I prefer an organic visibility score for a page. This allows the target keywords and your non-target keywords to represent the traffic to the website. Identify the pages you are working on and average the ranks for all the keywords that are driving organic. Repeat each month for a trend. SEMrush now gives page level data so you can easily extract the keywords with a download or API call. That’s a very helpful addition.

Different SEO tools offer visibility scores of their own, using their own preferred formula. More than just averages, sometimes traffic and impression data is calculated. Here is a visibility score from Rank Ranger that’s telling me how well one of my important pages is performing (check out their calculation description). I’d rather learn from this report and drill into each keyword only as needed. It’s a perfect chart for any SEO reporting dashboard.

Separate Qualified Traffic within Reports

Qualified traffic is the most important data in any Google Analytics report. We are looking to attract traffic that does something – make a purchase, become aware of a brand, inquire about a service, read content, and so on. The key to receiving qualified organic traffic starts with understanding your best visitors’ wants and needs. Every query done in search engines represents a need by a user. Your website data discloses what this need is, and it gives you the ability to update your website accordingly. As long as you take the time to dig into your organic search data.

High click-through rates and engagement signals two things – you’re on the right track with your visitors, and you’ve convinced Google that you’re worth the traffic. Using the keyword groupings we discussed earlier helps paint an even clearer picture. A good SEO report should allow you to see this, and help you consider a need for improving the page or moving onto another SEO campaign. Alternatively, if your reports are not showing webpage success, it should report on the reasons why and suggest the efforts that should be made.

Automate as Much of Your Reporting as Possible

In a past life, I was part of an agency that spent too much time – by hand – downloading Omniture reports (remember them?). I was copying and pasting cells, customizing charts, running formulas, and beautifying spreadsheets. I could make a spreadsheet look like a work of art, but it wasn’t the work I should have been doing. This exercise took 10+ hours a month. Clients would receive these reports in the middle of the month. In summary, my clients were paying me to be a report monkey. I was spending far too much time building spreadsheets, and not enough time analyzing. That’s a problem.

Improved technology has given SEOs various methods in which data collection can accelerate. APIs from Google Analytics and Search Console can plug into Google Data Studio or Google Sheets (with a plugin like Supermetrics). No longer do we have an excuse for being a report monkey. Instead, we can use this extra time wisely. We can use this available time to find the stories in the data. We can use this time to provide actionable insights pulled from the data.

SEO Report Example [with Free Template!]

I’ve talked a bit about quality reporting, but I haven’t shown any examples of what we do at Greenlane. This is a default report designed in Google Data Studio. It’s our most current “out of the box” version (as of this writing). It has not been customized for client KPIs. But it’s clean and clear. If you’d like to download this to use as an SEO report template, you can download it here.

So far, pretty standard stuff. So what happens when a client has their own SEO metric requests? You simply build them in (as you’re about to see).

Additionally, in this next example, you’ll see where insights tell the story of the data. The benefit to API driven reports, you don’t need to spend the time pulling data. They essentially become automated SEO reports. You can use this saved time to really understand what is going on with the site.

There’s no limit to how much customization you can do to your report template. (If you’re using Excel or Google Sheets for your report design, here’s a helpful bunch of resources for organizing your data.) As long as the data is relevant, and the insights are valuable, you’re on your way to creating the best SEO reports you can possibly deliver. Developing the template is certainly a bit of upfront work, but it pays off in the long run.