SQL文（クエリ）

SELECT
  user_id
  , SUM(cv) cv_by_user
FROM
  (
    SELECT
      user_id
      , CONCAT(cid, session_count) AS session
      , MAX(IF(page = "/thank_you/", 1, 0)) AS cv
    FROM
      sample.web_log
    GROUP BY
      user_id
      , session
  )
GROUP BY
  user_id
HAVING user_id IS NOT NULL
AND cv_by_user > 1
ORDER BY
  1

結果テーブル

サポートページに戻る