Description
The Sessionize function maps each click in a session to a unique session identifier. A session is defined as a sequence of clicks by one user that are separated by at most n seconds.
Usage
td_sessionize_sqle ( data = NULL, time.column = NULL, time.out = NULL, click.lag = NULL, emit.null = FALSE, data.partition.column = NULL, data.order.column = NULL )
Arguments
data |
Required Argument. |
data.partition.column |
Required Argument. |
data.order.column |
Required Argument. |
time.column |
Required Argument. |
time.out |
Required Argument. |
click.lag |
Optional Argument. |
emit.null |
Optional Argument. |
Value
Function returns an object of class "td_sessionize_sqle" which is a
named list containing object of class "tbl_teradata".
Named list member can be referenced directly with the "$" operator
using the name: result.
Examples
# Get the current context/connection con <- td_get_context()$connection # Load example data. loadExampleData("sessionize_example", "sessionize_table") # Create object(s) of class "tbl_teradata". sessionize_table <- tbl(con, "sessionize_table") # Example 1 - # This example maps each click in a session to a unique session identifer, # which uses input table web clickstream data recorded as user navigates through a web site # based on events — view, click, and so on which are recorded with a timestamp. td_sessionize_out <- td_sessionize_sqle(data = sessionize_table, data.partition.column = c("partition_id"), data.order.column = c("clicktime"), time.column = "clicktime", time.out = 60, click.lag = 0.2 )