Start with your decision.
Then inspect the data.

WITH ordered_events AS (
  SELECT user_id_hash, event_timestamp, target_url,
    LAG(target_url) OVER (
      PARTITION BY user_id_hash ORDER BY event_timestamp
    ) AS previous_target_url
  FROM read_parquet('clickstream-events/*.parquet')
)
SELECT previous_target_url, target_url, COUNT(*) AS transitions
FROM ordered_events
WHERE previous_target_url IS NOT NULL
GROUP BY 1, 2
ORDER BY transitions DESC;

SELECT market, query_topic, destination_domain,
  SUM(referral_visits) AS referral_visits,
  SUM(referral_visits * click_through_rate)
    / SUM(referral_visits) AS weighted_ctr
FROM read_parquet('ai-search-signals/*.parquet')
GROUP BY 1, 2, 3
ORDER BY referral_visits DESC;

SELECT market, category, domain, visits_index,
  week_over_week_change, ai_referral_share, rank_in_category
FROM read_parquet('domain-category-trends/*.parquet')
WHERE period_start = DATE '2026-07-13'
ORDER BY market, category, rank_in_category;