Marco Giordano Profile picture
Data/Web Analyst Freelance consulting I post about Analytics, Content, Processes πŸ€– Background in SEO/Marketing and Content.
9 subscribers
Jan 5 β€’ 25 tweets β€’ 6 min read
The MAXI Thread You Need To Understand The Semrush Report.

Since everyone is going crazy over this study and misinterpreting the data...

let me clarify some things 🧡 Let's start right away with the sampling, the most important thing.

It's true that with this sample, we can't generalize or draw conclusions ...

but this doesn't mean that this study is not informative.

We are talking about conclusions, not usefulness.

N.B. check the quoted tweet and download the full report.
Oct 11, 2023 β€’ 55 tweets β€’ 15 min read
Data Skills and Analytics for #SEO Essentials.

The Most Complete Resources Out There, For Free.

πŸ’― Updated version with new content [October 2023]

My 50 best threads and posts in a single place: Introduction to #nlp to understand how modern search engines work.
Oct 6, 2023 β€’ 25 tweets β€’ 5 min read
HCU didn't only bring traffic losses but broadcasted #SEO misinformation.

So many analyses are based on anecdotal evidence, such as:

- My clients didn't get hit
- My website is fine
- It must be the home page!

Let's poke some holes and see what to do instead 🧡 First of all, even 1000 websites aren't representative.

Mind you, not because it's only 1000 but for the sampling method used.

In plain English, you should have some criteria to select which websites you have to showcase.

1000 travel websites aren't diversified.
Sep 7, 2023 β€’ 14 tweets β€’ 4 min read
#SEO doesn't have to be checklists.

I love recommending how to improve processes based on insights.

This part of my Data Analysis Workflow is important for anyone.

How to get 2x efficiency and $$ with this simple process 🧡 Image Before you start, have a look at my older post where I discuss the entire workflow.

Look at the bottom right to see what I am talking about.
Aug 16, 2023 β€’ 16 tweets β€’ 4 min read
Yesterday I talked about possible tactics in #SEO.

Today I want to analyze flanking:

βœ… ideal for small/niche websites against goliaths
βœ… easier to see results
βœ… hard to counter

Let's see how to execute it in this thread 🧡 Image Flanking consists in exploiting gaps, finding the weak spots of your competitors and abusing them.

If your competitor is weak in a given cluster, you can overspecialize in that one!

The same applies to segments, audiences, formats, etc.

ANYTHING!
Jul 29, 2023 β€’ 22 tweets β€’ 5 min read
Content Decay is the silent πŸ’Έ killer of content websites.

It's a natural phenomenon that happens to anyone.

No website is immune from it.

The Ultimate Thread For Content Decay: Everything You Need To Know 🧡 Image Content Decay simply means that your content will lose performance over time.

Everything in nature degrades as time goes by.

The reasons? Multiple and it's a 100% event.

You can't completely prevent it but you reduce its effect.
Jun 30, 2023 β€’ 15 tweets β€’ 4 min read
How can anyone person level up their Search Console game?

10 Easy Steps for anyone to start with GSC!

N.B. This is a non-technical thread 🧡 1. Use the API.

It gives you more data than the interface.

The easiest way is using Looker Studio to check data.

Once you feel more confident, it's time to write some code.
May 25, 2023 β€’ 24 tweets β€’ 5 min read
Great #SEO requires you to have a solid value proposition.

I have seen too many projects fail for the wrong reasons.

Want some common sense?

Here it is 🧡 Don't start a project without knowing the budget.

It's fine to explore topics and ideas but don't exaggerate.

You can't compete in some niches without the proper resources.

This is why some projects fail. They forgot to estimate costs and revenues...
May 24, 2023 β€’ 16 tweets β€’ 4 min read
Do you know where many content websites struggle?

Processes because neither tools nor the #SEO industry talks about them.

It's all about abstraction and shiny objects, right?

Let's see some practical steps for ROI and πŸ’Έ 🧡 The first recommendation is to always label your data.

If you have a content plan (you should), it needs to contain:

- The cluster(s) an article belongs to

- Additional information like author, date published

You add what you can't scrape or see elsewhere.
May 23, 2023 β€’ 16 tweets β€’ 4 min read
In the midst of AI hype, many #SEO practitioners get lost.

Some underrated topics are much more valuable than others.

Here are my personal recommendations 🧡 NLP concepts aren't that hard and it takes you like 2 weeks to learn most of them.

The basics alone do the trick.

Understanding how can machines process text is a big plus when explaining On-Page SEO.

Again, you only need some theory and that's it.
May 14, 2023 β€’ 23 tweets β€’ 5 min read
5 + 1 Underrated Things Content Websites Should Consider:

1. Custom images
2. Newsletter
3. A decent design just for branding
4. Internal Linking (in the body)
5. Informative About Us page
6. ???

Let's see how and why 🧡 Custom images are necessary to differentiate yourself and steal some spots for Images.

This is even more pressing in niches such as travel.

Canva is often enough unless you want to do professional infographics.
May 12, 2023 β€’ 18 tweets β€’ 4 min read
Websites of any kind should leverage:

πŸ‘‰ BigQuery
πŸ‘‰ Search Console API
πŸ‘‰ GA API
πŸ‘‰Tag Manager
πŸ‘‰ Any non-SEO data they can gather

Decision-making becomes so simple once you actually have good data.

Let's see how 🧡 BigQuery is not the only option but allows you to store data easily and stay within Google's ecosystem.

This is great news for integration with Google APIs and also for learning.

A lot of SEOs talk about BQ, so it's way easier for you!
Mar 27, 2023 β€’ 14 tweets β€’ 4 min read
The 10 Most Common Errors in Content Audits.

Many can fall for cheap #SEO advice and get nothing.

I've audited small and large content websites to develop profitable processes.

This thread is for you 🧡 1. Only using one data source to delete articles.

If your website is using multiple channels, you should have other data than GSC.

Wait if one article has 0 clicks but high engagement on Facebook?

Guru advice says to delete it, I would never do that.
Mar 26, 2023 β€’ 20 tweets β€’ 4 min read
Evergreen content is one of my favorite #SEO topics.

It's super crucial for publishers and especially for niche websites.

And yet, there are many ideas you can use 🧡 Evergreen refers to content that is not time-sensitive and is not particularly subject to seasonality or timeframes.

Search demand is constant through the years. They usually tackle recurring problems or super generic topics.
Mar 25, 2023 β€’ 14 tweets β€’ 3 min read
The 10 Underrated Mistakes For Content Websites And Publishers 🧡 1. Not internalizing.

Yeah outsourcing is cool but some things you should have.

This includes internal tools, hiring people and learning new skills.

Outsourcing is a double-edged sword and can destroy your profitability.
Mar 24, 2023 β€’ 22 tweets β€’ 5 min read
Many ask me where to start with coding/data or #Python for #SEO.

I've already covered this topic but...

understanding some concepts is still hard for many.

Let's see why and how 🧡 Excel/Google Sheets are completely fine for smaller projects.

Pivot tables and basic data cleaning operations do the work.

They are the best solutions for quick work and for fast formatting.
Mar 19, 2023 β€’ 16 tweets β€’ 4 min read
What's the actual impact of tools on #SEO work?

Many claim that *some* tools are mandatory to execute a strategy.

I think this is often misleading.

Let's see how to differentiate between planning and execution 🧡 Cause-effect and correlation are different concepts that are often interchanged.

Testimonials and case studies can be tweaked to show a certain outcome.

You don't get rich because you used a keyword research tool.

This is one of the most common tricks used by sales teams.
Mar 17, 2023 β€’ 4 tweets β€’ 1 min read
#SEO tools can't replace insights, strategy, and business acumen.

Analytics is the same, as tools are mere instruments.

Then what's the difference between a good analysis and a bad one?

This is how you generate πŸ’Έ and create tons of value 🧡 SEO and Analytics share too many things in common.

Both have professionals obsessed with tools.

And they require having a strong acumen and intuition about business.

It's unthinkable to do excellent SEO in an industry where you have no expertise.
Feb 28, 2023 β€’ 33 tweets β€’ 7 min read
How can you apply #Python for #SEO to get outstanding results?

I will show you some examples of what you can do without spending money.

This thread is all about Python and quick wins and insights 🧡 Disclaimer: I am not listing source codes here, I will make separate threads later.

The goal of this thread is to give you the footprint and the direction.

Feb 27, 2023 β€’ 17 tweets β€’ 4 min read
Tired of the usual boring content website advice?

"Publish more, wait some time"

I give you some tips to actually future-proof your business.

No fluff, only cold facts from an #SEO and Data Analyst 🧡 The generic advice "publish more" isn't wrong per se.

But it's subpar advice and many savvy entrepreneurs already know that.

Just publishing is not enough because you need to maintain your content.

It costs a lot of money and time to update 1K+ articles.
Feb 26, 2023 β€’ 13 tweets β€’ 4 min read
You've probably asked yourself what these 5 terms mean...

Analytics, AI, SaaS, Big Data, NLP.

If you work inΒ #SEO, this thread is for you.

Let's explain them like we are 5 years old 🧡 Analytics is the discovery and communication of patterns and insights in data.

Analyzing Google Search Console data is such an example.

This is where many SEOs fall short, as this discipline isn't just filtering data!