Skip to content

Instantly share code, notes, and snippets.

@RedaAffane

RedaAffane/macro_session_1.sql

Created February 21, 2018 14:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save RedaAffane/a43444eee78805a7e2f87eeeadfd7417 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save RedaAffane/a43444eee78805a7e2f87eeeadfd7417 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
macro_session_1.sql
SELECT "conversions".user_id,
"conversions".conversion_timestamp,
"touchpoints".channel,
"touchpoints".timestamp,
"conversions".user_id || extract(epoch from "conversions"."conversion_timestamp") AS "macro_user_session"
FROM "conversions" "conversions"
LEFT JOIN "user_touchpoints" "touchpoints"
ON "conversions"."user_id" = "touchpoints"."user_id"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment