How we measure our Core Web Vitals — Google Sheets

At this point we’ve got the data into Google Analytics (via the dataLayer and Google Tag Manager).

So we’ve got lots of data in Google Analytics this is great!

However we now need to pull this data into Google Sheets in a number of reports to avoid sampling issues so we can bring the data into DataStudio to see our p75 values.

We use the Google Sheets Google Analtyics Addon to build our reports.

Your first report

Click Add-ons > Google Analytics > Create new report

Configuration options

Metrics: Event Value

Dimensions: Event Label, Date, Event Action

Click Create Report

Running the report

Click Add-ons > Google Analytics > Run reports

I’ve found running these reports incredibly slow so be patient with them.

Also be sure when they’ve come together to check if they’ve been sampled. If they have keep reading and see how we get around that.

Our slightly messier collection of data to avoid sampling

Due to sampling based on the number of sessions involved and to avoid going over Google Sheets 5million row limit we have 3 different Google Sheets documents with 4 GA reports in each.

They all look incredibly similar.

This is to avoid the sampling issues discussed here.