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...

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...

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...

Top
Divi WordPress Themes