Add column with domain name to CSV file with Python

A script to add a column containing only the domain name to an existing CSV file. It extract it from a column containing an URL. It works with .co.uk and other country code top-level domain. Just change “5” by the column containing the URL. Also don’t forget to adjust. Here is it setup for semi-colon for […]

Extract domain name with Python

tldextract is the best library to extract the domain name with Python. Here is how it looks in action: import tldextractext = tldextract.extract(‘http://forums.bbc.com’)print(ext.registered_domain) Which would output: bbc.co.uk

Deep diving in Search Console data

Bellow a list of interesting ressources to play with Search Console data. I’ve put in bold what makes the dashboard somehow different. Feel free to comment to complete this list. DataStudio How to use the official Search Console Connector with DataStudio – (no dashboard) – by Ruben Vezzoli Calculate the accurate amount of Impressions Branded […]

Ecommerce Conversion Rate with Google Analytics API

To get the ecommerce conversion rate with Google Analytics API, you can use the metric ga:transactionsPerVisit or ga:transactionsPerSession depending of API version you are using. Enjoy ! 🙂

Finding the LCP node with Chrome DevTools

Official documentation about Largest Contentful Paint is super interesting and explicit. But it misses one thing: How to identify the largest node / block / image /text ? Chrome DevTools allows you to find which node you should optimize. Simply follow the steps below. Open Chrome Open the page you want to find the LCP […]

Test of Indexation of images in background by Google

In this post, there is a background image. It is the picture of my 3 years old Macbook Pro 2016 which is already dying… The screen is sometimes not usable, and most of the time there is just one line, vertical. The idea is to check if either of not Google will index an image […]

Who knows this rare fish ?

If you’ve read my last blog post, you will see that it didn’t help to use the title of an image to rank in the SERPs. So I decided to push the test a little bit further, until I manage to get the image indexed. So here is the picture of a very rare – […]

Does the Title of picture help to rank in Google in 2020 ?

I recently read that Google uses the title of the images to rank them in Google Images. It would be kind of a little revolution, since it has never been considered as useful. I decided to make my own test, just to make sure it works also for me. So here is the picture, it’s […]

What are the best SEO Crawler for Huge Website ?

You want to crawl millions of URL and make a super SEO Audit ? Here are the best crawler for SEO on a large to very large website: Desktop SEO Crawler (starts at more or less 200$ / year / unlimited crawl) Screaming Frog (Linux / Windows / Mac OS) -> The big plus: native […]

Screaming Frog v9.0 / Docker / Debian 8 / Ubuntu Remote Desktop

You would like to setup a remote desktop with Screaming Frog to crawl huge websites (+1 million pages) ? You only need your crawler to run once a month ? (few hours or days) You have some basic technical skills and want to discover the power of the Cloud ? An Ubuntu Remote Desktop in […]