Use Data Or Be Used By Data!

The February 26 issue of Seotistics is here for you!

I asked some of you how they use SEO data daily.

Yes, people who have read my content and practiced it!

Let's hear some first-hand experiences from SEOs who started from scratch.

P.S. You'll get a free Content Handbook this week, use this time to catch up with Seotistics!

We have a Discord server in case you want to join our family.

​Read this in your browser​

Arturs Cavniss - Automation & Reporting

I recently read Marco's book on Analytics and I have to say that I learned a lot from it.

It helps you understand the core concepts of analytics and provides great code snippets that you can use to automate your tasks.

Thanks to this book, I no longer use the GSC UI, which has saved me a lot of time and hassle.

Tasks that used to take me a week to complete can now be done in a single day!

I highly recommend the ebook to anyone who wants to improve their analytics skills.
In the beginning, I was frustrated with the GSC UI for data analysis, it was taking too long.

It's never been easier to find the keywords and pages that need optimisation to perform better.

Caitlin Hathaway - Monitoring & Reporting

Since joining the Seotistics community, saying I’ve learned so much still feels like an understatement.

From new ways of approaching and prioritising my work, using data efficiently as an SEO, Marco distils it easily and has a roadmap for everything.

Not only that, but I feel like I’m genuinely levelling up as a professional.

I highly recommend joining Marco’s awesome community and investing in his resources.

Recently reading the Analytics ebook and newsletters opened my eyes to how much more can be done to improve our content monitoring across a portfolio of sites.

This is currently a manual and time-consuming process which causes a lot of headaches throughout the year.

Now, we are building systems to efficiently monitor all the content across our portfolio.

Particularly in regards to content decay, which will help us safeguard our rankings and revenue.

While we’re building out the content monitoring system, being able to do this within BigQuery across all our sites at ease has been hugely helpful.

Thanks to the handbook and its SQL:

Simone De Palma - Tech SEO & Content Pruning

Marco's ebook eased me into learning about Graph Theory and how to identify flaws in the Information Architecture (IA) of a website.

And that's just it, in just 10 minutes (+ time left for crawling), I could map out the architecture of several websites.

But the best part of it was discovering Gephi as a data visualization tool.

Despite apparently daunting at first sight, it covers everything you need to know to navigate through the settings.

For example, adjusting Page Rank scores to build up the clusters.

Here's just an example of a simple website grounded on 3 main levels:

Take a subset of top pages by clicks and how they vary over time to discern between:

• Pages that are exposed to traffic noise and fluctuations
• Pages resilient to traffic shake-ups: the Evergreens

The lower the CV, the more robust and traffic-steady a page.

This is my favourite example of a SQL query I usually perform to inform decisions over potential content pruning.

Myriam Jessier - Understanding Data

Marco's ebook is the blueprint for data clarity.

If you don't understand something, take the time to learn it, understand it and apply it until you do.

Take charge and start handling some of your frustrations tied to data analysis.

Marco gives you everything you need to do so:

• a continuously updated guide
• access to a thriving community you can rely on to learn and ask questions
• solid advice to tackle day-to-day data problems right in your inbox with the newsletter.

Charles Meaden - Content Decay Framework

One thing that especially piqued my interest was around content decay.

We've built the framework to extract, the impressions, clicks, CTR and Avg position on a monthly basis over a 12 month period for selected URLs.

We calculate not just totals, but the % of impressions and more importantly clicks that each piece of content brought in.

We then create 4 tables to show this data in Excel and use the handly sparklines to illustrate how each one performs.

Ebere Jonathan - A Lesson In Methodology

I was once analyzing an enterprise website with countless pages to figure out the group of pages responsible for a traffic drop.

Drowning in data, I felt paralyzed, as I wasn't sure how to dig such a mountain of data and translate it into actionable insights.

I felt really excited when Marco announced the release of his book "Analytics for SEO ".

It took me 2 weeks of reading to improve my data analytics confidence.

The first biggest lesson I learned from his ebook is to always define the goals before diving into tactics.

This simple shift has helped me to improve the quality of my questions, prioritize effectively, strategize better, and deliver impactful results quickly.

Beyond the valuable information and practical examples contained in the book, Marco's ongoing commitment to answering questions in Seotistics community is truly inspiring.

He's always available and ready to share his expertise on social media and the Seotistics platform.

If you're struggling with navigating data analytics in SEO, consider "Analytics for SEO " your buddy and join the Seotistics community.

Giulia Panozzo - Confidence In Reporting

Marco's insights take you on a comprehensive journey through the intricate intersections of data analytics for SEO, delivering substance without unnecessary "fluff."

While covering the fundamentals of statistics, Marco's approach offers a step-by-step progression that ensures you can get the most out of the guide.

It's really the most exhaustive one available in the realm of SEO data analytics.

I personally used the guide to revise some of the statistical concepts I learnt before I started working in SEO.

So that led me to be more comfortable and confident in my reporting when I talk to stakeholders about the impact of my team’s work.

In particular, in one of my articles, I have recommended Marco’s guide to creating synthetic data for learning to test without having to rely on proprietary data.

This approach opens up the opportunity for exploration that would otherwise be hindered by the limitations of insufficient, low-quality or private data.

🔎 Analytics For SEO Ebook (v7)

If you want to learn about Analytics for SEO and get the best resource out there, this is for you.

It will teach you or your employees to:

👉 Prepare audits that make sense and are actionable 🔥

👉 Avoid common pitfalls that cost you money 💸

👉 Create analyses that add value and money💯

👉 Move the needle faster with efficient SEO systems ⏳

This comes with periodical updates to keep the content fresh.

📚 Recommended Reads - Peak Content 🗻

This week has been rich with cool AI stuff:

• ​Beyond RAG: Network Analysis through LLMs for Knowledge Extraction​
• ​How to use LLMs to power your entire content strategy​

You know... I am not a big fan of AI but this is how you should use it!

And you can also read my LinkedIn content:

• ​Speeding Up SEO​
• ​Explainability of data in SEO​
• ​Classifying SEO Automations & Solutions with a Matrix​
• ​How to start using SEO data​
• ​Siloed SEO? Don't make this mistake​
• ​Always measure THESE for a content website​

Stay tuned because I will launch a full Analytics for SEO course next!

📞 One-Hour Call

If you have doubts about SEO or Analytics, you can book a call with me.

Have doubts about your content website or with your data?

Look no further, I can help you:

❗️ Feedback and Recommendations

If you have ideas/recommendations for the next issues of Seotistics, you can simply reply to this email.

Marco Giordano
​SEO Specialist & Data Analyst

Follow me on 🔽🔽🔽:

​​​

Bernerstrasse Süd 169, Zurich, Switzerland
​Unsubscribe · Preferences​