Small scripts and recipes to run PageSpeed Insights via the API, save results, summarise and export to tsv.

• PageSpeed Insights scripts
  • Setup
    • Dependencies
    • Get an API key and set PSI_API_KEY
    • Save your URLs to test in urls.tsv
  • Usage
    • Capture a snapshot
    • Capture snapshots every 5 mins
    • Show lab data report
    • Save lab data report as tsv
  • Caveats

• bash
• node>12
• no node modules or anything else to install

See https://developers.google.com/speed/docs/insights/v5/get-started

export PSI_API_KEY=<api-key>

• the expected format is url\tname, e.g. https://web.dev/ homepage
• name is optional, the default name is the URL path

cat > urls.tsv <<EOF
https://web.dev/	homepage
https://web.dev/fast/
EOF

./captute-snapshot [snapshotsDirectory] [urlsTsvFile]

Save PageSpeed Insights API results

• in snapshotsDirectory (default: snapshots)
• for all URLs in urlsTsvFile (default: urls.tsv)
• then show PageSpeed Insights lab data summary for current snapshot

Example:

./capture-snapshot

Output:

created snapshots/2021-03-19_21-34-27/
running pagespeed insights for https://web.dev/...
running pagespeed insights for https://web.dev/fast/...
Score	FCP	LCP	TBT	CLS	Timestamp			URL
95	1.1 s	2.8 s	70 ms	0	2021年03月19日T21:34:28.785Z	/fast/
99	1.1 s	1.6 s	30 ms	0	2021年03月19日T21:34:29.159Z	homepage

Files created:

snapshots/2021-03-19_21-34-27/homepage.json
snapshots/2021-03-19_21-34-27/fast.json

Example:

watch -c -n 300 ./capture-snapshot

Output:

Every 300.0s: ./capture-snapshot
created snapshots/2021-03-20_00-28-01/
running pagespeed insights for https://web.dev/...
running pagespeed insights for https://web.dev/fast/...
Timestamp FCP LCP CLS TBT Score URL
2021年03月20日 00:28:02 1.8 s 2.1 s 0.001 30 ms 98 /fast/
2021年03月20日 00:28:02 1.8 s 2.6 s 0 40 ms 96 homepage

Files created:

• Every 5 minutes a timestamp directory is created with the latest results

./lab-report [snapshotsDirectory] [filter]

Show PageSpeed Insights lab data summary:

• for all results in snapshotsDirectory recursively (default: current directory)
• if filter is set then only show results where URL or path or name matches filter (default: show all URLs)

The summary shows:

• Timestamp: human readable timestamp
• FCP, LCP, CLS and TBT formatted (and colored) lab data values
• Score 0-100 colored performance score
• URL the requested URL path (or name), or in case of a redirect <requestPathOrName> -> <finalPath>

Example:

./lab-report snapshots/ /fast/

Output:

Timestamp 	FCP 	LCP 	CLS 	TBT 	Score 	URL
2021年03月19日 21:48:49	 1.8 s	 2.0 s	 0	 60 ms	 98	/fast/
2021年03月19日 21:49:00	 1.8 s	 2.1 s	 0	 70 ms	 98	/fast/

NO_FORMAT=1 NO_COLOR=1 ./summarize-reports [snapshotsDirectory] [filter] > tsvFileName

Save PageSpeed Insights lab data report into tsvFileName:

• without colors or formatting
• ready to be imported into e.g. Google Sheets

The tsv rows will have the following fields:

• Timestamp: ISO date time value
• FCP, LCP, CLS and TBT lab data raw numeric values
• Score 0-100 performance score
• URL the requested URL path (or name), or in case of a redirect <requestPathOrName> -> <finalPath>

Example:

NO_FORMAT=1 NO_COLOR=1 ./lab-report snapshots/ > data.csv

Files created:

data.tsv

• few nights hack
• no tests
• not originally intended for public consumption