Aggregate & Automate Performance Reporting With Lighthouse & Google Data Studio

WTF Dan? I can’t even say that title, it’s a mouthful!

Sorry, random internet stranger but it sounds smart!

Anyways, performance reporting is good for SEO right? Speed is a critical ranking factor, it’s good for users, and we all just want to feel the need for it. But enterprise-class performance reporting dashboards are tough. Especially ones that are easy to spin up automatically, low resource and actionable.

Do these look like something you would want to have?

Would surfacing performance opportunities automatically and at scale like this be helpful?

Well, have no fear, because that’s what I’m here to walk you through!

So first, check out the end product. Here is a performance dashboard we created for Target (sorry for outing you Target SEO, but hey free report!):

https://datastudio.google.com/open/17bU954JKOK-7xCeSZuipEdgnTYhRYh2-

This dashboard was created by taking a simple two-column spreadsheet (one column with a URL and another with the label), passing it via-.CSV through our Slackbot Jarvis running it through our process, and then outputting it as a Google Data Studio Report. Yes, we have a bot named Jarvis. Don’t you?

It took me about 15 minutes to classify the URLs and about 10 for the report to be run/created. Isn’t living in the future cool? I guess a human could compile all this, but this seems like a real time-saver to allow the human brain to do what it’s best at –…

Read More…