Robin Rozhon
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...
top of page
Robin Rozhon
Oct 12, 20176 min read
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...
Robin Rozhon
Sep 9, 20173 min read
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...
Robin Rozhon
Mar 26, 20175 min read
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...
Robin Rozhon
Jan 15, 20175 min read
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...
Robin Rozhon
Nov 19, 20164 min read
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...
bottom of page