Google Spreadsheets for Digital Marketers
Sheets for SEO and Web Analytics (formerly known as Linktosheets.com)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 data to reveal the direction the website is heading to. Having a solid forecast is a great way to close a deal, to justify a...
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 collects the best add-ons for digital marketers. Google Analytics Big Analytics Data Search Analytics for Sheets Twitter Archiver...
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 trends and popularity. With this post, you are a few clicks away from creating a simple data mining tool. This handy add-on gives you...
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 skills required. Google Search Console (formerly Google Webmaster Tools) is a powerful tool that provides insights into how Google...
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 very useful for a smaller set of URLs. What is Web Scraping? Web Scraping is a process of extracting specific information from web...
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 tracked normally. It’s important to mention that Google Analytics is only as good as the setup. If you only insert the JavaScript...
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 straightforward 301 generator helps you manage simple redirect rules in one spreadsheet. What is a redirect? Redirection is...
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 increase your efficiency in campaign management and provide better data in Google Analytics. UTM tagging is a great tool that Google...