Marek Prokop
@marekprokop.bsky.social
Digital marketer & data analyst | Data-driven SEO specialist 📈 | R enthusiast 💻
UX designers, can we talk? Still designing websites and services for humans? Doesn't that feel a bit... outdated? Time to start optimizing for AI agents. UX is dead, long live AX! 😉
#AX #AgentExperience #UX
#AX #AgentExperience #UX
July 28, 2025 at 6:20 AM
UX designers, can we talk? Still designing websites and services for humans? Doesn't that feel a bit... outdated? Time to start optimizing for AI agents. UX is dead, long live AX! 😉
#AX #AgentExperience #UX
#AX #AgentExperience #UX
SEO news of the year is here: the Google Search Console has a new logo ;-)
July 22, 2025 at 7:55 AM
SEO news of the year is here: the Google Search Console has a new logo ;-)
🎉 My R package 'urlexplorer' is now on CRAN!
Tools for parsing & analyzing URL datasets - perfect for SEO analysis and understanding website architecture.
📦 install.packages("urlexplorer")
🔗 cran.r-project.org/package=urle...
#RStats #DataScience #SEO
Tools for parsing & analyzing URL datasets - perfect for SEO analysis and understanding website architecture.
📦 install.packages("urlexplorer")
🔗 cran.r-project.org/package=urle...
#RStats #DataScience #SEO
urlexplorer: Structural Analysis and Pattern Discovery in URL Datasets
Offers tools for parsing and analyzing URL datasets, extracting key components and identifying common patterns. It aids in examining website architecture and identifying SEO issues, helping users opti...
cran.r-project.org
July 14, 2025 at 6:03 PM
🎉 My R package 'urlexplorer' is now on CRAN!
Tools for parsing & analyzing URL datasets - perfect for SEO analysis and understanding website architecture.
📦 install.packages("urlexplorer")
🔗 cran.r-project.org/package=urle...
#RStats #DataScience #SEO
Tools for parsing & analyzing URL datasets - perfect for SEO analysis and understanding website architecture.
📦 install.packages("urlexplorer")
🔗 cran.r-project.org/package=urle...
#RStats #DataScience #SEO
AI Overviews officially in the Czech Republic.
May 21, 2025 at 6:45 AM
AI Overviews officially in the Czech Republic.
Everyone's talking about #AI for #SEO content & automation, but I'm surprised how few discuss AI for #linkbuilding.
For 2 years, AI tools have been among the most linked-to pages online.
See the opportunity?
Almost any industry can benefit from a useful/fun AI tool. Easy win for natural backlinks.
For 2 years, AI tools have been among the most linked-to pages online.
See the opportunity?
Almost any industry can benefit from a useful/fun AI tool. Easy win for natural backlinks.
March 19, 2025 at 11:26 AM
Everyone's talking about #AI for #SEO content & automation, but I'm surprised how few discuss AI for #linkbuilding.
For 2 years, AI tools have been among the most linked-to pages online.
See the opportunity?
Almost any industry can benefit from a useful/fun AI tool. Easy win for natural backlinks.
For 2 years, AI tools have been among the most linked-to pages online.
See the opportunity?
Almost any industry can benefit from a useful/fun AI tool. Easy win for natural backlinks.
📣 The GSheets community extension for @duckdb.org is here: duckdb.org/2025/02/26/g...
This is great news for my #SEO workflow: @screamingfrog.co.uk → DuckDB → Analysis with SQL → Google Sheets
No more CSV exports :-)
This is great news for my #SEO workflow: @screamingfrog.co.uk → DuckDB → Analysis with SQL → Google Sheets
No more CSV exports :-)
Reading and Writing Google Sheets in DuckDB
Securely read from and write to Google Sheets directly in DuckDB using the GSheets community extension! For ad hoc querying, authentication is as easy as logging into Google from a browser. Scheduled ...
duckdb.org
March 12, 2025 at 6:11 PM
📣 The GSheets community extension for @duckdb.org is here: duckdb.org/2025/02/26/g...
This is great news for my #SEO workflow: @screamingfrog.co.uk → DuckDB → Analysis with SQL → Google Sheets
No more CSV exports :-)
This is great news for my #SEO workflow: @screamingfrog.co.uk → DuckDB → Analysis with SQL → Google Sheets
No more CSV exports :-)
Just created a small R function to get the most recent date available in Google Search Console data. With the current API delays, this helps you quickly check if your data is up-to-date without manual checking. gist.github.com/MarekProkop/... #rstats #seo #searchconsole
An R function to retrieve the most recent date available in Google Search Console API for a specified site URL. Requires the searchConsoleR package.
An R function to retrieve the most recent date available in Google Search Console API for a specified site URL. Requires the searchConsoleR package. - sc_most_recent_date.R
gist.github.com
February 26, 2025 at 7:36 AM
Just created a small R function to get the most recent date available in Google Search Console data. With the current API delays, this helps you quickly check if your data is up-to-date without manual checking. gist.github.com/MarekProkop/... #rstats #seo #searchconsole
Search Console API is currently only returning performance data up to February 19, 2025. Three days missing! Be careful - this affects all your totals and calculations as well. #SEO #GoogleSearchConsole
February 25, 2025 at 7:38 AM
Search Console API is currently only returning performance data up to February 19, 2025. Three days missing! Be careful - this affects all your totals and calculations as well. #SEO #GoogleSearchConsole
I have added a live demo to my Outlinks Explorer.
Outlinks Explorer is an open source application written in R+Shiny. I use it in SEO when I need to find out which addresses a particular page links to.
github.com/MarekProkop/...
#seo #rstats
Outlinks Explorer is an open source application written in R+Shiny. I use it in SEO when I need to find out which addresses a particular page links to.
github.com/MarekProkop/...
#seo #rstats
GitHub - MarekProkop/outlinks-explorer: Outlink Explorer is a Shiny app designed to help SEO professionals explore and analyze outbound links on any web page. Easily navigate through links and underst...
Outlink Explorer is a Shiny app designed to help SEO professionals explore and analyze outbound links on any web page. Easily navigate through links and understand linking structures to improve you...
github.com
February 8, 2025 at 9:49 AM
I have added a live demo to my Outlinks Explorer.
Outlinks Explorer is an open source application written in R+Shiny. I use it in SEO when I need to find out which addresses a particular page links to.
github.com/MarekProkop/...
#seo #rstats
Outlinks Explorer is an open source application written in R+Shiny. I use it in SEO when I need to find out which addresses a particular page links to.
github.com/MarekProkop/...
#seo #rstats
I'm improving my R script for detecting keyword cannibalization from Search Console data. While researching this topic, I was surprised to find that most articles describe completely unusable or flat-out wrong detection methods. Has anyone seen a guide with a reliable approach? #SEO
January 19, 2025 at 8:34 AM
I'm improving my R script for detecting keyword cannibalization from Search Console data. While researching this topic, I was surprised to find that most articles describe completely unusable or flat-out wrong detection methods. Has anyone seen a guide with a reliable approach? #SEO