Thoughts on how to improve string search queries

[Bhanu1]

Please see sample code I am running below. What options can I explore to improve speed of query execution in such a scenario? Current full code takes about 4 hrs to run on 1.5 billion rows. Thanks!

SELECT
 fullVisitorId
 ,VisitId
 ,EventDate
 ,PagePath
 ,deviceCategory 
FROM ga360.ga_sessions a
WHERE
(
contains(lower(PagePath) , 'step-one')
OR contains(lower(PagePath) , 'step-two')
OR contains(lower(PagePath) , 'step-three')
)
AND not contains(utm_source,'ads')
AND hitstype = 'PAGE'
and a.EventDateKey >= 20200101