This is my first article on how to create dashboards with R and ScreamingFrog. I begin with active pages and a simple methodology to classify URLs. The definition of an active page is : A page that receives at least one organic visit over a given timeframe. In this case study, the timeframe is set
You can use OpenRefine to merge different variants of SEO keywords or urls and compute volume by cluster 1/ Choose the group you want to merge Keywords column menu -> Edit cells -> Cluster and Edit -> Merge Selected & Re-Cluster 2/ Sort and reorder rows permanently Keywords column menu -> Sort -> (text, A-Z)
In my last post Enhance Your Google Analytics Data with R and Shiny , I have exported Annotations from Google Analytics. There is no option to export Annotations in GA. So , I give you a solution. 1/ Install the Chrome Extension “Table Capture” https://chrome.google.com/webstore/detail/table-capture/iebpjdmgckacbodjpijphcplhebcmeop 2/ In Google Analytics, Go “Admin”, “Assets”, “Annotations” and click on “Display
My first english post is about how to generate the internal link graph of any site with R Studio. Process and ToolsYou need RStudio with packages iGraph, SNA and DplyrTo install a package , just type in the console : install.packages(“iGraph”)The process required exporting the URLs crawled with Screaming Frog.When the crawl is finished, you choose “Bulk Export”