Version
2.3
SELECT * FROM attribution (
ON { input_table | view | (query) }
PARTITION BY expression [,...]
ORDER BY order_by_columns
EventColumn ('event_column')
ConversionEvents ('conversion_event' [,...])
[ ExcludeEvents ('exclude_event') ]
[ OptionalEvents ('optional_event' [,...]) ]
TimestampColumn ('timestamp_column')
WindowSize ('rows:K | seconds:K | rows:K&seconds:K')
Model1 ('type', { 'K' | 'EVENT:WEIGHT:MODEL:PARAMETERS' } [,...])
[ Model2 ('type', { 'K' | 'EVENT:WEIGHT:MODEL:PARAMETERS' } [,...]) ]
);
In the Model1 and
Model2 arguments, colons are parameter delimiters. If a parameter contains colons,
enclose it in double quotation marks. For
example:
Model1 ('EVENT_REGULAR', '"email:":0.19:LAST_CLICK:NA')