All tech opportunities

[rviscomi]

• Reset timeframe to June 2021-2022
• Add ALL technologies
• Add ALL ranks
• Add all audits with additional score/category/group metadata
• Add CrUX INP and TTFB
• Permanent functions
• CREATE TABLE for every query
• Permanent tables in httparchive.core_web_vitals dataset

[thibaudcolas]

@rviscomi 👋 I find this dashboard / fascinating. The only things I went looking for and couldn’t find were:

• Audit-by-audit scores within the performance category (for example uses-text-compression scores by technology)
• Scores for other Lighthouse categories – Accessibility / SEO / PWA / Best Practices

It looks like your work in this PR might cover one or the two? "Add all audits with additional score/category/group metadata" If not, do you think either of the above could be valid feature requests for this report?

[rviscomi]

Hey @thibaudcolas. Yes this PR should include all audits from all categories. Category-level scores are less useful for this analysis but they're already included in the CWV Tech Report table (httparchive.core_web_vitals.technologies).

[thibaudcolas]

Amazing 😌