Test Automation and Monitoring for SEO
The latest website update set “noindex” to the production site, changed Robots.txt file or rewrote canonical tags. Does it sound...
Robin Rozhon
Robin Rozhon
Latest posts
SEO Stories of Two JavaScript-dependent Websites
I’ve heard on numerous occasions that JavaScript is evil, but I’m not sure if I agree with that. Yes, JavaScript makes SEO more...
Blending log files with other data sources for SEO in Power BI
Server logs provide the true view of how search engines crawl your website. Google Search Console or any crawler provide useful data, but...
Log Files: The Overlooked Source of SEO Opportunities
Server logs are a powerful source of information that can help you understand complex SEO problems with crawling and indexing. Every...
Debugging Google Analytics via Log Files
You’ve often heard that log files are great for SEO (Listen to those people. They are right!). But don’t think of them as a simple SEO...
Crawling & Indexing: Technical SEO Basics That Drive Revenue (Case Study)
Getting technical aspects of SEO right can be rewarding and have a significant impact on your bottom line. The bigger the site is, the...
Why Google Analytics data is wrong
Google Analytics is a great tool, and 62% of the top 10K websites have Google Analytics tracking code installed (according to...
Forecasting SEO Impacts on Organic Traffic
Stop guessing! Yes, forecasting SEO is hard but extremely useful. This spreadsheet uses basic statistical methods and historic traffic...
The Best Google Sheets Add-ons for Digital Marketing
Google Sheets are great but a handy add-on may bring this tool to the next level or create a nifty connection to another tool. This page...
How to Extract Data from Wikipedia and Wikidata
Wikipedia is a trusted source of information that ranks for the majority of two-word search queries, so looking at its data can reveal...
Download all search queries and landing pages from Google Search Console
This post shows you how to set up automatic monthly backups of Search Analytics data from Google Search Console. Spoiler alert: No coding...
Web Scraping Using ImportXML in Google Spreadsheets
This tutorial shows you how to scrape web pages by using Google Spreadsheets instead of using web scraping tools. The suggested method is...
Google Analytics Event Tracking Generator
Google Analytics event tracking is a powerful feature that allows you to track visitors’ interactions with your website that would not be...
Simple 301 Redirect Generator for htaccess in Google Spreadsheets
Use 301 redirects to protect hardly gained positions in search results and don’t let visitors find your certainly awesome 404 page. This...
UTM Tagging with Google Spreadsheets
Tracking all your campaigns can be challenging, especially if you do multichannel marketing. Let me show you a simple tool that will...
Educate Google and Create an Entity in the Knowledge Graph
Google is permanently changing rules of the game and trying to serve more relevant answers to search queries. In th past, Google’s search results page (SERP) was answering with links to relevant websites but it wasn’t enough. Currently, it tries to deepen the contextual understanding of query. The result of efforts is the Knowledge Graph (launched in May 2012), and it provides answers, not just…