Sign in Subscribe

Alice Roussel

Alice Roussel

Regex in Search Console

As Google Search Console now allow to use regex to filter both queries and pages, the time has come to get an in-depth introduction to RE2 (the library used in Search Console). 01. A short introduction to regular expressions 02. Google RE2 regex 03. Search Console regex cheatsheet A little

Learning SEO: 15 advice

The following advices are based on my own experience: failures as well as success that made me rethink the way I approach my everyday job. Plus, these advices are not listed in a specific order. 01. Never rely on assumptions: use relevant data That’s so easy and tempting to

How to fix things after a drop of organic traffic

Curated ideas from my proven experience to fix organic search after a failed migration on an ecommerce website. The story that follow comes from my experience as an SEO in a web agency back in 2016. This is certainly the most valuable proven experience I had the chance to live

Predict your break-even point with Google Data Studio

How to predict the day when you will be break-even: the moment where your revenue covers your total costs. The moment where you have no loss neither no profit. In this article, I will guide you through the steps of visualizing both your costs and revenue on a daily basis

Learnings from log analysis

Almost two years ago, I joined OnCrawl and the opportunity to access millions of log data: the feeling of entering a tiny Google with access to lots of crawl data, logs and third party connectors. In this new article, I would like to share my learning about log data. There

Create a traffic heatmap from Google Analytics with R Studio

Without any objectivity, I state that SEO is certainly one of the most exciting jobs because the ways to approach it are so different. However, there is one common denominator to all the experiences that consultants and other cool job names ending with ” SEO ” could tell us: relationships with other

Keyword tracking with Google Sheets

Today, there are a lot of tools to help you track your rankings. Without going into detail between those who offer a Desktop / Mobile split, tracking positions 0, etc. I propose you to track your rankings the old-fashioned way. Not out of phlegm but simply because some cases still require

Scrape product features on Google Shopping to structure SEO content

Google as a tool is an excellent way to organize specific SEO tasks. Google Shopping is even more so because it gives us access to unparalleled granularity of information when it comes to consumer products. I’m not going to hide it any longer, this article (and tool which results

Automate content at scale: get insights from trusted sources

Many methods exist to generate content, including natural language generation from numerical data. Despite all the attractiveness of computational linguistics, our work will lead us to generate content through summarization algorithms. Before anything, it should be understood that this tool was not designed to replace the editorial work itself. The

Create your own crawler to use the Google Cloud NLP API

Offered by Google Cloud’s Natural Language APIs, entity and sentiment analyses classify terms and extract a general feeling. Dated 2015, a Google patent entitled Rankings of search results based on entity metrics demonstrates the value of using it in our SEO actions. Officially launched in September 2017, the Google