ga4_count_specific_event_parameters.sql

SELECT
  event_date,
  COUNT(DISTINCT(session_id)) AS sessions,
  SUM(ga4_resource_page_views) AS ga4_resource_page_views
FROM (
  SELECT
    CONCAT(user_pseudo_id,(SELECT value.int_value FROM UNNEST(event_params) WHERE KEY = 'ga_session_id')) AS session_id,
    COUNT((SELECT value.string_value FROM UNNEST(event_params) WHERE KEY = 'page_location'
      AND value.string_value LIKE 'https://twooctobers.com/blog/ga4-resources/%')) AS ga4_resource_page_views,
    PARSE_DATE('%Y%m%d',event_date) AS event_date
  FROM
    `[your project].[your GA4 table].events_*`
  WHERE
    _table_suffix BETWEEN '20230201' AND '20230228'
    AND event_name = 'page_view'
  GROUP BY
    user_pseudo_id,
    session_id,
    event_date
)
GROUP BY event_date
ORDER BY event_date