Use Data Or Be Used By Data!

The May 29 issue of Seotistics is here for you!

Today we talk about practicing with data, something many of you always ask me.

But Marco, what if I don't have any data? Or even worse, "my client won't give me access".

This is quite normal in practice and can pose a threat to your SEO work.

After all, we can't really do SEO without data. And that's why we are going to create fake data.

P.S. This is only Part 1 of this fascinating topic, next week you'll get to read Part 2!

🔑 Key Concepts

Let's see some basic concepts:

• Synthetic data: data that don't exist in reality. You generate them to emulate actual data (but they are still fake).
• API: what allows you to access the features, functions or data of a software. This isn't the complete definition but let's stick with it.
• Float number: decimal number, e.g. 6.7895
• Integer number: whole number (positive or negative), e.g. 2 or -2

In SEO we don't have much literature or public datasets to work with.

Once again, you don't need to test on actual datasets, you can generate them yourself!

Of course, you also want to have real datasets if possible but reality isn't really a fairy tale.

🧮 Actionable SEO Tip - Do It Your Way

OK, you don't have any website or access to data...

Well, you still need to get them in order to work but if you need to test something, I have a solution.

It's possible to generate synthetic data with coding.

But first, let's see what you can get without any 1st party access:

• Keyword data/Competitor data (Semrush/Ahrefs)
• Crawl data (Screaming Frog/Sitebulb)

Not much, and I don't recommend relying on Semrush/Ahrefs if you have to make important decisions. ❌

As said before, you may want to test your ideas on Google Search Console/Analytics data instead.

What if you are in your free time and can't use any client data?

Well, you generate them! Let's see a quick example.

I want a dataset with the following columns:

• query: a string containing one or more words
• page: a string with a specific format
• date: date format, any is fine
• clicks: integer number (you can't have 1.5 clicks, either 1 or 2)
• impressions: integer number (as above)
• ctr: clicks/impressions, so you get a float number

We have some requirements in place but that's not all!

We know that a page can be tied to multiple queries and dates... with different clicks and impressions.

Page A can rank for query x on a given day and get 50 clicks. The next day (for the same query) you may get 30 clicks.

This fact must be taken into account when generating data.

⚠️ I don't use position except when I need to create pivot tables to count queries over time (check issue #1).

Generating such a metric is a little bit harder but we will see how in the next issues ;)

💡 Using Coding To Solve The Issue

Coding comes to our rescue once more time as many of you were already giving up.

We have some idea on how we want our data to be, so now we should generate it.

What I've just said can be translated into code you can reuse when needed.

For this specific use case, I prefer R over Python because it makes more sense to me but anything goes.

The hardest part is generating queries that actually make sense when read, so for this you need to do some hard work.

You can create a list of words you want to combine to create different fictional combinations.

🔗 Google Colab Link With R Code​

If you have doubts, reply to this email. In any case, don't worry, Part 2 will make a lot of things clearer.

💡 The SEO Insights

I have just showed you don't need any excuse to delay learning or testing data.

You can prepare some scripts or analyses in advance to persuade clients to give you data access.

I think that you shouldn't even accept in such cases but you know, sometimes you just need persuasion.

This practical exercise is also good to understand how data may be generated in practice.

Understanding how metrics work and what could be realistic values for them is a must for troubleshooting.

❓ Are there other methods?

Yes, I have only showed you the tip of the iceberg.

Marketing literature has many examples of generating synthetic data and it's not as straightforward as you imagine.

✅ Probability distributions are the best way to think about metrics... and this is coherent to how many professionals generate data.

But again, this topic will be covered in the next issues!

P.S. Thanks for reading! I recommend you check the resources because I mention one great library to generate fake data!

🧵 My Selection Of Twitter Threads

A quick recap for those who haven't read them all or need a refresher:

• ​Underrated Topics In The Era Of AI Noise​
• ​Underrated Ideas To Manage Content Websites​
• ​Data SEO Tip: Measure Decay The Right Way​
• ​Value Proposition In SEO​
• ​Processes For Content Websites​

👥 Launching a Community (Join The Waitlist)

I and some friends have decided to launch our personal SEO community. It won't be about Analytics only, as we will cover everything about SEO.

For sure, we will preserve the focus on data skills because that's the future of SEO!

🔎 Analytics For SEO Ebook (v2)

This ebook is aimed at SEOs or Business Owners who want to explore the combination of SEO and Analytics.

It will teach you or your employees to:

👉 Avoid common pitfalls that cost you money 💸

👉 Create meaningful analyses that add value 💯

👉 Shorten the learning time of Analytics ⏳

This comes with monthly updates because I want to create the Ultimate Guide out there.

The April update includes the following new information:

✅ Categorize Pages

✅ More on Content Audits

✅ Handling Large Files

v3 (coming out in a few days) will feature:

• Quick And Simple Way Of Detecting Keyword Cannibalization
• Statistical Inference And Statistics (Update)
• Update For Use Cases 2 and 5
• Going Deeper With Analysis (Google Analytics, Screaming Frog, etc.)
• R Approach To Some Problems

📚 Recommended Reads

This week there are some peak recommendations you don't want to sleep on:

• ​How to Measure Anything [Summary]​
• ​How to Measure Anything: Finding the Value of Intangibles in Business​
• ​Synthetic Data Techniques​
• ​Faker Official Docs​

The first 2 reads were recommended by Benjamin Crane and honestly... it's peak quality!

❗️ 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​