DIEGO MELENDEZ
Back to Projects

CrUX Dashboard

2025
Context

For an international industrial manufacturer with a presence across many countries and domains.

Problem

Manually monitoring Core Web Vitals (Google's web-performance metrics) across dozens of URLs per country was slow and inconsistent.

Solution

An automated system that pulls Core Web Vitals (LCP, INP, CLS) weekly from Google's CrUX API, stores them historically in Google Sheets without overwriting, enriches them with Jira tickets, and visualizes them in an interactive Looker Studio dashboard. Fully automated with GitHub Actions.

Result

Fully automated web-performance reporting, with a consolidated view by country and page type.

Role

End-to-end development.

Tech stack
  • Python
  • CrUX API
  • Google Sheets API
  • Looker Studio
  • GitHub Actions
  • Jira