Vincent Malischewski - SEO & stuff

SEO, data, scripts, use-cases

Content Strategy

6

Keyword Clustering for SEO gap analysis How to use SEO Rankings in a data-driven content update strategy How to Cluster / Categorize Keywords with Google Sheets Wizardry

A topical traffic dashboard template for GSheet How to SEO without being an editors' scarecrow How to use SEO Rankings in a data-driven content update strategy

Technical SEO

3

Paginated Headache for SEOs Analyzing Internal Linking Structures with Gephi: A Guide to Cluster Visualization [script] Build a Crawler from a Google Sheet list of URLs

[script] Build a Crawler from a Google Sheet list of URLs Paginated Headache for SEOs Analyzing Internal Linking Structures with Gephi: A Guide to Cluster Visualization

Sheets / Excel

2

Custom Dialog Box for Google Sheets (using Apps Script)My Favorite Charts for Visualizing Traffic

My Favorite Charts for Visualizing Traffic Custom Dialog Box for Google Sheets (using Apps Script)

Python

4

Keyword Clustering for SEO gap analysis CSV Magic: Mastering Basic Operations with Google Colab (Python)Here's what I learned from building a scraper and a (semi) automated website

[script] Build a Crawler from a Google Sheet list of URLs Here's what I learned from building a scraper and a (semi) automated website CSV Magic: Mastering Basic Operations with Google Colab (Python)

Random

3

How to migrate Wordpress to a new host (easy and free)Here's what I learned from building a scraper and a (semi) automated website My Raspberry Pi Projects

Here's what I learned from building a scraper and a (semi) automated website My Raspberry Pi Projects How to migrate Wordpress to a new host (easy and free)