Onur Guler developed two analytics features for the HTTPArchive/almanac.httparchive.org repository, focusing on data-driven insights for 2025. He designed and implemented SQL-based pipelines to analyze Progressive Web Apps usage, including asset utilization, manifest properties, and service worker adoption, enabling actionable reporting on user engagement. Additionally, he delivered analytics for CMS adoption trends, covering metrics such as page performance and technology distribution across platforms. Onur’s work leveraged SQL, data analysis, and data visualization skills to create ready-to-dashboard outputs. While no bugs were addressed during this period, the features demonstrated depth in extracting and structuring complex web ecosystem data.