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.
Pivot tables and basic data cleaning operations do the work.
They are the best solutions for quick work and for fast formatting.
The problem is that what you do there can't be replicated easily.
Documented code solves that problem.
If you document everything and list everything, it will be much more useful.
Programming languages also help you to scale processes.
Documented code solves that problem.
If you document everything and list everything, it will be much more useful.
Programming languages also help you to scale processes.
For medium/large websites you feel the difference when using Python/R/SQL compared to Excel.
Excluding the huge number of libraries and tricks, the performance is something else.
It's not just a whim, creating scripts or apps has clear benefits.
Excluding the huge number of libraries and tricks, the performance is something else.
It's not just a whim, creating scripts or apps has clear benefits.
Many newcomers fall into full elitism and think that Excel is unusable and trash.
Of course, it's not the case, you need all the tools.
Excel/GSheets reign supreme for quick or basic stuff.
Of course, it's not the case, you need all the tools.
Excel/GSheets reign supreme for quick or basic stuff.
A tool for internal use is light years ahead of your spreadsheet.
The same goes for dashboards or anything that supports decision-making.
Spreadsheets are good as outputs but not optimal to automate processes or even worse, storing data.
The same goes for dashboards or anything that supports decision-making.
Spreadsheets are good as outputs but not optimal to automate processes or even worse, storing data.
I've made some examples that involve coding.
In practice, you don't need to be a developer.
Knowing basic data operations is more than enough to get more out of data.
And here comes the fun part...
In practice, you don't need to be a developer.
Knowing basic data operations is more than enough to get more out of data.
And here comes the fun part...
There is a stark difference between Scripting and Analytics.
The first involves Automation and producing scripts, pretty much where @LeeFootSEO excels.
It's all about increasing efficiency and if possible, building tools.
The first involves Automation and producing scripts, pretty much where @LeeFootSEO excels.
It's all about increasing efficiency and if possible, building tools.
Analytics is about improving the quality of questions.
Investigating, finding patterns, and observing what's going on without drawing conclusions.
This is what I do, so it's ideal if you are more of a business/analytical SEO.
Investigating, finding patterns, and observing what's going on without drawing conclusions.
This is what I do, so it's ideal if you are more of a business/analytical SEO.
For both of them, you need to know to code.
I don't see any reason to delay learning some basic code in the era of ChatGPT.
Python is the best choice because it's popular and easy to understand.
Other alternatives are also cool but I will always recommend the most popular.
I don't see any reason to delay learning some basic code in the era of ChatGPT.
Python is the best choice because it's popular and easy to understand.
Other alternatives are also cool but I will always recommend the most popular.
The tool is only a way to achieve something.
You should spend more time solving problems rather than learning a tool.
And this is where practice comes into play.
You should spend more time solving problems rather than learning a tool.
And this is where practice comes into play.
Basic Math/Statistics always help because they omnipresent with data.
Even though coding doesn't require you to know Calculus, it's beneficial to grasp the basics.
High School Math is already good for most use cases, the ones you will often encounter.
Even though coding doesn't require you to know Calculus, it's beneficial to grasp the basics.
High School Math is already good for most use cases, the ones you will often encounter.
In all the other cases, the concepts are slightly more complex but still feasible.
Most of the SEO problems are honestly stupid compared to other industries.
This means you can get away with simple data operations and add crazy value.
Most of the SEO problems are honestly stupid compared to other industries.
This means you can get away with simple data operations and add crazy value.
If you have a STEM background, this will be much easier.
You can pretty much study these subjects from ANY background but the mathematical part will be harder.
Fortunately, it's quite simple to tackle and not as complex as you imagine.
You can pretty much study these subjects from ANY background but the mathematical part will be harder.
Fortunately, it's quite simple to tackle and not as complex as you imagine.
Creating scripts for broken links or copying what's already there (pretty common now) doesn't make any sense.
It's only for clout and doesn't contribute to business value.
Why should I use a simple script when Screaming Frog costs nothing and offers a superior experience?
It's only for clout and doesn't contribute to business value.
Why should I use a simple script when Screaming Frog costs nothing and offers a superior experience?
You see, go all in or stay home.
Real value doesn't go through cheap knock-offs or clones.
That's why you should find your unique blend and offer viable solutions.
What works for Ecommerce will hardly work for a publisher.
Real value doesn't go through cheap knock-offs or clones.
That's why you should find your unique blend and offer viable solutions.
What works for Ecommerce will hardly work for a publisher.
Studying pandas or tidyverse is already enough to solve most problems.
You can also go further and expand your knowledge, super fair.
The issue is that there is no guarantee you'll see any immediate value.
You can also go further and expand your knowledge, super fair.
The issue is that there is no guarantee you'll see any immediate value.
Really, all you need is to practice coding while solving SEO-related issues.
There is no need to reinvent the wheel but you don't need to create basic scripts either.
As I said before, checking broken links isn't going to make you rich.
There is no need to reinvent the wheel but you don't need to create basic scripts either.
As I said before, checking broken links isn't going to make you rich.
It's normal to feel overwhelmed at first.
But the crucial thing is developing the right mindset and inspiring decision-makers.
Remember, it's all about other people, code and data are only some of your means.
But the crucial thing is developing the right mindset and inspiring decision-makers.
Remember, it's all about other people, code and data are only some of your means.
If you already know some of these topics, my ebook covers much more.
I am going to release the 1st content update on the 2nd of April to add even more.
marcogiordano96.gumroad.com
I am going to release the 1st content update on the 2nd of April to add even more.
marcogiordano96.gumroad.com
Follow me for threads, tips, and case studies (coming soon) about SEO, content, and Python/data.
If you liked this thread, consider liking and retweeting it!๐งต
If you liked this thread, consider liking and retweeting it!๐งต
Loading suggestions...