Spot issues in your crawl data with a Venn diagram on Looker Studio

Sometimes, it is hard to get the big picture of your crawl at first glance. The idea here is to benefit from the use of a specific visualisation to easily diagnose crawl data. Introduction to Venn diagrams Logical relation diagrams existed way before John Venn popularised the concept in the

Buying an expired domain: generating content at scale with GPT-3

Before going deep into this topic; make sure to read the first two parts of my series about building an MVP. Part One: Buying an expired domain Part Two: Buying an expired domain: learnings on ranking capabilities ‌ ‌ TL;DR 1. We know our target revenue to spark our “this is

Visualising crawl data from Screaming frog

Looker Studio template to analyze your crawl data from Screaming Frog in a very actionable way.

Use Google Sheets as a CMS with Next JS

This is the third part of the series “buying an expired domain”. Part One: Buying an expired domain Part Two: Buying an expired domain: learnings on ranking capabilities If this article is the first of the series you are about to read, here’s a little bit of context. Back

A year into growth and the culture that empowers it

Last year, I resigned from Oncrawl to embrace new challenges outside the SEO world. I started my career in 2014 as a Traffic Manager in a web agency, dealing with both organic and paid acquisition. Soon enough, I decided to specialized in SEO mostly because I loved (and still do)

Buying an expired domain: learnings on ranking capabilities

Last month, I published a first article as part of a series dedicated to building an MVP. Part One: Buying an expired domain Today, I would like to share my learnings on the ranking capabilities: * Does buying an expired domain with years of semantic history helps with the rankings? * Does

Building a redirect generator on Google Sheets

Recently, I’ve been dealing with Next JS so the free Google Sheets template that comes with this article to help you manage your redirects at scale, is using the Next JS redirect format. In case you need another redirect formatting, let me know and I will update the generator

Forecasting methods for Google Sheets

Forecast and marketing data are sometimes difficult to match up. Forecast can be scary as we are never that comfortable to rely solely on it. I’m sharing with you some valuable techniques based on my proven experience; ran on Google Sheets. No hard skills needed. At first, when I

Buying an expired domain

First of all, let’s give some context about having bought an expired domain. At Pictarine, we aim to test a lot of things and to build MVPs to confirm or disconfirm our hypothesis. To test a new photo product and possibly new markets (in addition to the US), we

Get high-end insights from Ahrefs' organic keywords

Here’s a brand new Google Looker Studio template to help you get the most valuable insights from Ahrefs’ organic keywords. This template is also designed to backup your decisions with data when it comes to prioritizing your content roadmap. Below are the steps to extract the data and then