pages_trend

Creates, updates, deletes, gets or lists a pages_trend resource.

Overview

Name	pages_trend
Type	Resource
Id	cloudflare.speed.pages_trend

Fields

The following fields are returned by SELECT queries:

list_by_zone

Page trend.

Name	Datatype	Description
cls	array	Cumulative Layout Shift trend.
fcp	array	First Contentful Paint trend.
lcp	array	Largest Contentful Paint trend.
performanceScore	array	The Lighthouse score trend.
si	array	Speed Index trend.
tbt	array	Total Blocking Time trend.
ttfb	array	Time To First Byte trend.
tti	array	Time To Interactive trend.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_zone	select	zone_id, url	region, deviceType, start, end, tz, metrics	Lists the core web vital metrics trend over time for a specific page.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
url	string
zone_id	string	The Cloudflare zone ID.
deviceType	string
end	string (date-time)
metrics	string	A comma-separated list of metrics to include in the results.
region	string
start	string (date-time)
tz	string	The timezone of the start and end timestamps.

SELECT examples

list_by_zone

Lists the core web vital metrics trend over time for a specific page.

SELECT
cls,
fcp,
lcp,
performanceScore,
si,
tbt,
ttfb,
tti
FROM cloudflare.speed.pages_trend
WHERE zone_id = '{{ zone_id }}' -- required
AND url = '{{ url }}' -- required
AND region = '{{ region }}'
AND deviceType = '{{ deviceType }}'
AND start = '{{ start }}'
AND end = '{{ end }}'
AND tz = '{{ tz }}'
AND metrics = '{{ metrics }}'
;