Core Web Vitals Tracker (Optimization Theory, v3.0, November 2026)
=============================================================

Log p75 LCP, INP and CLS by URL and device, test against Google's good thresholds and see what fails.

What it decides
  Which pages and devices pass all three Core Web Vitals at the 75th percentile, and which metrics are failing where.

Files
  Core Web Vitals Tracker.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Core Web Vitals Tracker - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO On-Page API
  Fills automatically: Page URL
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Pick representative URLs: Choose top templates: home, category, product, article, landing pages.
  2. Pull field data: Use the CrUX API or PageSpeed Insights field data for p75 LCP, INP and CLS, by device, with the window length.
  3. Record evidence: Note the source and date so later rows are comparable.
  4. Fix mobile first: Most failures are mobile. Group fails by template and send them to the fix prioritizer.

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/core-web-vitals-tracker/
Part of the Technical SEO Toolkit: https://optimizationtheory.com/download-view/technical-seo-toolkit-6-audit-and-validation-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
