Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen
Last active August 29, 2015 14:06
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 PMeinshausen/ffeac15ed5f289a8d387 to your computer and use it in GitHub Desktop.
Save PMeinshausen/ffeac15ed5f289a8d387 to your computer and use it in GitHub Desktop.
--Syntax (Multiple Input version 2.1)
SELECT * FROM Attribution(
ON {input_table | view | query}
PARTITION BY user_id
ORDER BY time_stamp
[ON {input_table_n | view_n | query_n}
PARTITION BY user_id
ORDER BY time_stamp [...]]
ON conversion_event_table AS conversion DIMENSION
ON excluding_event_table AS excluding DIMENSION
ON optional_event_table AS optional DIMENSION
ON model1_table AS model1 DIMENSION
ON model2_table AS model2 DIMENSION
EVENT_COLUMN_NAME('event_column')
TIMESTAMP_COLUMN_NAME('timestamp_column')
WINDOW('rows:K | second:K | rows:K&seconds:K2')
)ORDER BY user_id, time_stamp;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment