Bulk Checking Blog Article Analytics

Are there any tools/spreadsheets where I could input fixed URLs and periodically check their traffic metrics, ranking and whatnot?

I think ahrefs will work for that you’ll be able to see which page is getting traffic and all

Mr Positive said:

I think ahrefs will work for that you’ll be able to see which page is getting traffic and all

Click to expand...

Thanks, but I was thinking of something more homebrew. I´d like to create a monthly report for 150 Blog articles with stuff like PageSpeed, Ranking, etc. In an ideal world, someone around here would share a Google Sheets script or a DataStudio template. Ahrefs is my current solution but I´d love to find a more automated fix.