some-planet-44104
08/17/2023, 11:38 AMSELECT
user_pseudo_id,
created_at AS timestamp,
time_millis / 1000 AS value
FROM
sendpulse_normalized.events
WHERE
event_name = “FCP”
AND DATE(created_at) >= “2023-08-10”
AND (page_location = “https://somewebsite.com/some-page”)
The part in the brackets is the filter applied in the metric overrides.late-dentist-52023
08/17/2023, 2:39 PMexperiment_id | target_page_location
-------------------------------------
1234 | <https://somewebsite.com/some-page>
then your metric becomes:
SELECT
user_pseudo_id,
created_at AS timestamp,
time_millis / 1000 AS value
FROM
`sendpulse_normalized.events`
WHERE
event_name = "FCP"
AND DATE(created_at) >= "2023-08-10"
AND (page_location in (select target_page_location from experiment_target_map where experiment_id = '{{ experimentId }}'))
helpful-application-7107
08/17/2023, 3:46 PMsome-planet-44104
08/17/2023, 7:33 PMhelpful-application-7107
08/17/2023, 7:59 PM'{{ experimentId }}'
some-planet-44104
08/18/2023, 9:55 AMlate-dentist-52023
08/18/2023, 3:38 PM