top of page
![](https://static.wixstatic.com/media/f3a01e_f0099121432b4392bd8417a587f52395~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/f3a01e_f0099121432b4392bd8417a587f52395~mv2.webp)
![Why Google Analytics data is wrong](https://static.wixstatic.com/media/f3a01e_f0099121432b4392bd8417a587f52395~mv2.jpg/v1/fill/w_305,h_172,fp_0.50_0.50,q_90,enc_auto/f3a01e_f0099121432b4392bd8417a587f52395~mv2.webp)
Robin Rozhon
Nov 1, 20176 min read
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...
![](https://static.wixstatic.com/media/f3a01e_3d0fb6d676fa4d679791f51cfd76d61b~mv2.jpeg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/f3a01e_3d0fb6d676fa4d679791f51cfd76d61b~mv2.webp)
![Forecasting SEO Impacts on Organic Traffic](https://static.wixstatic.com/media/f3a01e_3d0fb6d676fa4d679791f51cfd76d61b~mv2.jpeg/v1/fill/w_306,h_172,fp_0.50_0.50,q_90,enc_auto/f3a01e_3d0fb6d676fa4d679791f51cfd76d61b~mv2.webp)
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...
![The Best Google Sheets Add-ons for Digital Marketing](https://static.wixstatic.com/media/f3a01e_f701795e5d4d4c7f8cab809934794bc2~mv2.png/v1/fill/w_305,h_191,fp_0.50_0.50,q_95,enc_auto/f3a01e_f701795e5d4d4c7f8cab809934794bc2~mv2.webp)
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...
![](https://static.wixstatic.com/media/f3a01e_8580906d8b674c0a95d34aa53d1e53be~mv2.jpeg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/f3a01e_8580906d8b674c0a95d34aa53d1e53be~mv2.webp)
![How to Extract Data from Wikipedia and Wikidata](https://static.wixstatic.com/media/f3a01e_8580906d8b674c0a95d34aa53d1e53be~mv2.jpeg/v1/fill/w_305,h_172,fp_0.50_0.50,q_90,enc_auto/f3a01e_8580906d8b674c0a95d34aa53d1e53be~mv2.webp)
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...
![Download all search queries and landing pages from Google Search Console](https://static.wixstatic.com/media/f3a01e_9c294796caa543c4965cdaf2efca53f0~mv2.png/v1/fill/w_306,h_172,fp_0.50_0.50,q_95,enc_auto/f3a01e_9c294796caa543c4965cdaf2efca53f0~mv2.webp)
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...
![](https://static.wixstatic.com/media/f3a01e_bbf2580ad60f43e7a0e80b05165a33bf~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/f3a01e_bbf2580ad60f43e7a0e80b05165a33bf~mv2.webp)
![Web Scraping Using ImportXML in Google Spreadsheets](https://static.wixstatic.com/media/f3a01e_bbf2580ad60f43e7a0e80b05165a33bf~mv2.jpg/v1/fill/w_305,h_172,fp_0.50_0.50,q_90,enc_auto/f3a01e_bbf2580ad60f43e7a0e80b05165a33bf~mv2.webp)
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