No code solution: Create a comprehensive SEO report in a matter of minutes using the Authoritas to Big Query and Looker Studio integration
UPDATED: New AI Overview SEO Report (More details below).
We've put together a range of comprehensive Looker Data Studio reports for monthly SEO reporting, as well as more advanced ad-hoc diagnosic reports to helps SEOs solve key challenges.
You are more than welcome to copy them, re-brand them, edit them and modify them in any way you see fit.😀
Although, if you do blog about it - we'd appreciate a link. 😉
Prerequisites
1. A paid Authoritas platform account.
2. Google Big Query integration activated for your package with the integration completed (see our guide to integrating with Google Big Query). Check with support@authoritas.com if you do not see this on the Settings > Integrations screen (see below).
3. You must have selected to sync 'All projects' or 'Selected Projects' so that data has flowed into Big Query. Please allow a few hours for the data to sync across for the first time.
4. You need view access to your SEO data stored in Google Big Query, so please check with your administrator.
5. You also need view access to the Looker Studio Report to be able to copy it and populate it with your project data. But, we've made all our reports public, so no need to worry about that.
Setup the SEO Platform to Google Big Query Integration
The Looker Studio report templates all talk to tables or views in Google Big Query. This has many advantages over a native Data Studio connector from other SEO tools - the main ones being; you have access to summary, aggregated data as well as granular data and the reports can load more data faster.
1. Login to your Authoritas account and go to Settings > Integrations to check that you have completed the integration with Google Big Query for the project(s) you want to report on in Looker Studio.
2. Click 'Select Projects' to check the project you desire is synced.
Now you have your SEO data flowing to Big Query, you can easily select one of our pre-built SEO reports, clone it and connect it to your Big Query project data.
Choose from 10 different SEO templates.
There is a single standard Authoritas Monthly SEO report which has 4 variations to choose from.
It contains all the essential SEO data an agency might want to report on, to demonstrate the progress of its SEO campaign to its client on a month-on-month basis.
It has sections covering:
* Cover Page
* SEO Visibility
* Google Search Console
* Keyword Ranking
* Crawl
* Backlinks
* Analytics (Google Analytics 4)
There are 4 versions to choose from, so if you do not have access to Google Analytics then you can choose a pre-built one without this section.
New: AI Overview & SEO Performance Dashboard
Our latest report allows you to report on the threat and opportunity caused by the rollout of AI Overviews in your market. This report will eventually be rolled into our standard monthly SEO reports as AIOs become the norm worldwide.
Choose from 5 Advanced Diagnostic SEO Reports
And there are 5 different diagnostic reports, which are not necessarily designed to be client facing reports, but have been built to tackle common challenges that SEO teams face whether in-house or agency side.
Preview the reports and clone them now, or read on to get a brief overview of each.
You can preview these reports by clicking the links above. If you like the report, simply click the 3 vertical dot menu on the top right-hand side of the report and click 'Make a copy'. All you need do is change the tables to the tables in the Big Query DataSet for the project you want.
The standard Authoritas Monthly SEO report
Let's look at the standard monthly SEO report first to see what you get: Authoritas Monthly Reporting Template v1.2 (With GA4 & GSC)
As mentioned above, it covers all the essential areas of SEO from share of search%, to keyword rankings, crawl errors, backlinks and website analytics. Here are just a few highlights:
You can track SEO Visibility by keyword tag group
Click on SEO Visibility (By Tag).
What's nice about this is that it shows performance for all keyword tag groups over the past week, 4 weeks, 13 weeks, 26 weeks and 52 weeks.
If you see a group trending upwards or downwards you can click on it and see the performance of the underlying keywords to see where you are gaining or losing ground on the competition.
Reporting on Google Search Console data in an actionable way
This page will show you:
1. New pages which are gaining traction (clicks or impressions);
2. Existing pages which have lost all clicks or impressions;
3. Existing pages that have lost some clicks or impressions; and,
4. Existing pages that have gained clicks or impressions.
Tip: A page should only appear in one of these 4 segments, so filter by month and device to ensure you get the required view.
Keyword Ranking reports including in-depth Universal SERP feature reporting.
It also does an in-depth analysis of your keyword ranking performance, including a specific report showing who is winning the battle for the Universal SERP Features that appear in your market.
See a summary of SEO crawl issues
This shows month-on-month changes and progress made a SEO issues are resolved.
Backlink profile and competitor analysis
You can also report on your site's backlink profile compared to its selected competitors.
Summarising your organic performance
Finally, if you have Google Analytics 4 integrated into the Authoritas platform, then you can automatically include 4 pages that summarise your website's organic performance.
Let's now take a look at a few of the more advanced, ad-hoc SEO reports. These reports have been designed to help SEO teams dive into the data to resolve common issues and challenges.
This is a simple report that joins your ranking and SERP data over time to allow you to see how the first page of the SERP is changing over time.
Filter by Search Engine and Keyword and/or Date to hone-in on the keyword that most interests you.
The table highlights the number 1 ranking organic page. You can see how the top spot has changed over time and also whether the top results is just a plain organic link or an organic featured snippet.
If you have gained or lost traffic to a page and you believe it may be down to one or two critical keywords, then this is an easy always-on method of diagnosing and tracking your fixes.
As SEOs we're all well aware of Google's recent updates focused on site health and helpful content.
Sometimes SEO is like gardening. To achieve better results you need to prune every now and then. The key to maintaining good site health is to remove poor or underperforming pages periodically.
The trouble is, until now, for most SEO teams this has always been a manual process.
But, now it's available as an always-on SEO report and will be there when you need it.
It automatically summarises your site's performance using data from Google Analytics 4, Google Search Console, Keyword Rankings and Backlinks.
Integrating key SEO data automatically saves hours of manual data wrangling! By joining this data together and having it updated all the time means you can dip in to your Content Audit report at any time and identify pages that you might want to cull or redirect.
Tip: Exercise your discretion when deleting poor performing pages. Some pages may be relatively new and may have not yet had time to establish themselves and you may see a few important pages (e.g. Privacy policy or terms and conditions) whose metrics look poor but you need anyway.
This is an enhanced version of the SERP Evolution report as it also reports on the 'Page Type' of the ranking pages.
N/B: Important Prerequisite:
You also need to have 'Page Structure' enabled on your Authoritas package, as this checks the top 10 organic ranking pages for your keywords, visits the pages and downloads and analyses their content. This is an advanced feature and is only available on enterprise agency or in-house packages. It is however ideal for eCommerce sites and marketplaces. Speak to the Authoritas support team to add this to your package.
The 'Smell of the SERP' helps you understand if you have the right type of content to rank.
For example, if you are an ecommerce site wanting to rank your category landing page for 'best \[insert product range\]' you may well find that Google is favouring articles rather than PLPs or PDPs on page 1 of the SERP. So the way to rank your site better will be to produce a quality article targeting this term which links to your category and product page(s) helping them rank for more transactional terms.
It is also useful to see whether Google has changed its view over time of the type of content it ranks first for a given term.
You can also filter by tag group to see what type of content is dominating the SERP for a cluster of related terms.
Updated 21/02/24 - v1.2 now includes Competitor Rankings table
This is the simplest of our reports as it uses ranking data to see which domains compete with you in the SERP most often for your chosen keywords.
It is particularly useful for setting up an SEO campaign for smaller local sites that won't feature in global or national SEO Visibility databases and tools.
It produces a league table ordered by Weighted Rank (this takes into account top rankings and the search volume for each keyword), the number of ranking pages and how many keywords ranked on page 1 of Google.
Remember to filter by search engine if you have multipe search engines configured on your project.
This is definitely not a report you will use every day.
But if you are about to embark on a website migration project then it could help you plan the migration and monitor your success.
N/B: Important Prerequisites
1. This requires you to setup 2 different projects on the Authoritas platform.
2. Ideally, you will be tracking an identical set of keywords in each project. e.g. Take all the Google Search Console keywords you can get for both sites and upload to both projects (we automatically dedupe the keywords).
3. You need to manually connect the 2 projects to the report where indicated when you clone our report. The relevant tables are referred to as Site 1 and Site 2 (Site 2 is the new destination site).
Click on 'Keyword Ranking and Page Mapping Site 1 to Site 2'.
You will see where both sites rank for the same keywords.
This should be helpful in planning your redirect strategy for the new site.
Anyone want more Looker Studio Reports for SEO?
We are open to creating more automated Looker Studio reports for SEO teams eveywhere. So, if you have an idea or an existing report you want to copy then please get in touch.
We can even create custom queries in Google Big Query to transform the data into the specific views you need. 💙
Comments
0 comments
Article is closed for comments.