Technical SEO Consultant in Barcelona
In February 2023, Google announced the bulk data export allowing companies to export their raw GSC data to their cloud warehouse, BigQuery. This change had two main objectives: In this article, I ll explain what you can expect from this integration and what are the best practices you should follow to leverage this data. If you ve [ ] The post How to use your GSC data in BigQuery like a pro?…
In an era where digital privacy is key, marketers are often caught in a dilemma between respecting user preferences and gathering valuable data to make informed decisions. For this exact reason, the Consent Mode has been created to help marketers respect privacy regulations like GDPR in the European Union, while collecting useful data. While this [ ] The post Consent Mode 101 for Marketers…
In a previous article, I explained what you re not told about the GSC data. Despite what I mentioned, I still believe that GSC is the best dataset you can use for SEO. In this article, I want to explain in-depth how you can download data from the API from scratch. Indeed, the official documentation can [ ] The post How to leverage your GSC data through the API? appeared first on Antoine Eripret .
If you re working in digital marketing, you must be well aware that Google decided to sunset one of their most used analytical tools: Universal Google Analytics (GA3). Even if you have a 360 account, you should have ended your migration some months ago and stopped using this product. The new version (GA4) does not consist [ ] The post How to improve your GA4 experience with BigQuery and DBT?…
Google was founded in 1998, and the web has evolved quite a lot since then. One of the main changes is the increase in websites that rely on JavaScript frameworks. You are very likely to have heard of them already, but they really started to appear in the mid-2010 s (source). These frameworks are obviously great [ ] The post Google s cache: how can it trick you? appeared first on Antoine Eripret .
If you ve already opened a website including numerous listings, such as an E-commerce or a classified, you already know what faceted navigation is. Just as a brief reminder: Faceted navigation is a UX pattern that helps users find specific listings on category/archive pages by allowing them to filter based on various attributes that the listings [ ] The post How to find SEO potential for your…
Internal linking is a goldmine to beat your competitors if you use it right, there is countless evidence to back that up. Nevertheless, it s often underused. Imagine a situation that shouldn t be too difficult to picture if you re not new in our field: a client with a high revenue-dependency on key strategic commercial keywords and [ ] The post How to find and implement internal linking…
Unless you ve been living under a rock for a couple of months already, you know that Google has replaced Universal Analytics by its new measurement solution, Google Analytics 4. While I believe this change is a step back for small businesses that don t have the time or money to understand how the tool works, the [ ] The post How to connect Google Analytics 4 with BigQuery? appeared first on…
Some days ago, Google announced a major improvement for Google Search Console: a simple data export to BigQuery. To be honest, I haven t tried it yet but no matter what, it is good news. This means several things: I ve been using SQL for almost 3 years now, and the objective of this post is to [ ] The post SQL for SEO appeared first on Antoine Eripret .
For quite some time, the SEO industry has been arguing over what is commonly referred to as zero-volume keywords. You can read these two articles (one and two) and make up your mind on this topic. I actually have countless examples where writing on zero-volume topics yielded remarkable results, as the one shown below. There [ ] The post How to retrieve search volume at scale? appeared first on…