🙌 Thanks for the awesome templates! The first one is my favorite so far. It helps me to see everything on one screen. On GSC, I need to click through three-five different reports to understand what's going on with my website. BTW, how do you calculate the "Lost clicks" metric on the first template?
As for your question about the new ideas, I'd like to see a template about backlinks. Would be amazing to check all trends and stats about backlinks on one screen.
@nikolaev Thank you, Nick, for good questions. Here is a formula for lost clicks. Lost clicks = (Impressions * 0.2) – Url Clicks. It shows how many clicks you lose on a keyword, page, site, while not standing in the top-1. It is clear that each search query has its own CTR and it can vary greatly. But I specifically took the lowered CTR of the first position so as not to overdo it.
@nikolaev The report by backlinks is also available here - https://ivanhoe.pro/google-data-.... It's based on Google Analytics data. So only backlinks that generate traffic are included to this report.
Hi, there!
I have created three Google Data Studio templates for SEO that can save you tons of time.
I researched the web. There are many useful templates across the internet and maybe you even use some of them. But there are no such templates as I've created.
The first template helps to visualize Google Search Console data. This template saves a lot of time during everyday work with Google Search Console data. There are 3 elements that make this template unique: better filtering; daily keyword rankings charts and pivot tables; custom metrics that help get more insights from GSC data.
The second template helps to merge Google Search Console and Google Analytics data to be able to quickly prioritize pages and keywords for SEO based on their profitability, not just the number of clicks. To get value from the report you should set up an e-commerce tracking or goal value tracking in Google Analytics.
The third template helps to measure referral links performance (based on Google Analytics data) faster and more flexibly. You can visit backlinks in one click, identify trends in traffic drop from the most valuable backlinks, or detect new valuable links to your site. Google Analytics' standard report by referral links is too limited. With my template, you can get more insights from the same data and save time when analyzing backlinks.
This is not a finished list of templates. I will create new ones.
So, please share your feedback. Do you like these reports? What new templates would you like to see on the list?
Waiting for your comments!
Report
Thanks for sharing! I'm not a seo guru, but a friend of mine told that it's really cool for the first glance. He will look closer.
Sitechecker
Sitechecker
Sitechecker
Sitechecker
Sitechecker
Sitechecker
Sitechecker