Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/get_conversion_history.sql

Last active June 16, 2016 04:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doryokujin/1704405158d9581ceb0ee1d8c6acc068 to your computer and use it in GitHub Desktop.
Save doryokujin/1704405158d9581ceb0ee1d8c6acc068 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_conversion_history.sql
SELECT
td_client_id,
cv_td_title,
ROW_NUMBER() OVER( PARTITION BY td_client_id ORDER BY time) AS cv_id,
time
FROM
(
SELECT time, td_title, td_client_id, cv_td_title
FROM
(
SELECT time, td_title, td_client_id
FROM treasuredata_homepage
),
(
SELECT td_title AS cv_td_title
FROM master_conversion
)
WHERE td_title = cv_td_title
ORDER BY td_client_id, time
) T
ORDER BY td_client_id, time
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment