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...
Robin Rozhon
Oct 10, 20164 min read
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...
Robin Rozhon
Sep 1, 20163 min read
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...
Robin Rozhon
Aug 17, 20162 min read
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...
bottom of page