Attribution
Description
The Attribution function is used in web page analysis, where it allows companies to assign weights to pages before certain events, such as buying a product.
Usage
td_attribution_sqle (
data = NULL,
data.optional = NULL,
conversion.data = NULL,
excluding.data = NULL,
optional.data = NULL,
model1.type = NULL,
model2.type = NULL,
event.column = NULL,
timestamp.column = NULL,
window.size = NULL,
data.partition.column = NULL,
data.optional.partition.column = NULL,
data.order.column = NULL,
data.optional.order.column = NULL,
conversion.data.order.column = NULL,
excluding.data.order.column = NULL,
optional.data.order.column = NULL,
model1.type.order.column = NULL,
model2.type.order.column = NULL
)
Arguments
data |
Required Argument. |
data.partition.column |
Required Argument. |
data.order.column |
Required Argument. |
data.optional |
Optional Argument. |
data.optional.partition.column |
Optional Argument. Required if "data.optional" is specified. |
data.optional.order.column |
Optional Argument. Required if "data.optional" is specified. |
conversion.data |
Required Argument. |
conversion.data.order.column |
Optional Argument. |
excluding.data |
Optional Argument. |
excluding.data.order.column |
Optional Argument. |
optional.data |
Optional Argument. |
optional.data.order.column |
Optional Argument. |
model1.type |
Required Argument. |
model1.type.order.column |
Optional Argument. |
model2.type |
Optional Argument. |
model2.type.order.column |
Optional Argument. |
event.column |
Required Argument. |
timestamp.column |
Required Argument. |
window.size |
Required Argument.
Types: character |
Value
Function returns an object of class "td_attribution_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 the data to run the example
loadExampleData("attribution_example", "attribution_sample_table1",
"attribution_sample_table2" , "conversion_event_table",
"optional_event_table", "model1_table", "model2_table")
# Create object(s) of class "tbl_teradata".
attribution_sample_table1 <- tbl(con, "attribution_sample_table1")
attribution_sample_table2 <- tbl(con, "attribution_sample_table2")
conversion_event_table <- tbl(con, "conversion_event_table")
optional_event_table <- tbl(con, "optional_event_table")
model1_table <- tbl(con, "model1_table")
model2_table <- tbl(con, "model2_table")
# This example uses models to assign attribution weights to events (conversion,
# optional and excluding).
td_attribution_out <- td_attribution_sqle(data=attribution_sample_table1,
data.partition.column="user_id",
data.order.column="time_stamp",
data.optional=attribution_sample_table2,
data.optional.partition.column='user_id',
data.optional.order.column='time_stamp',
event.column="event",
conversion.data=conversion_event_table,
optional.data=optional_event_table,
timestamp.column = "time_stamp",
window.size = "rows:10&seconds:20",
model1.type=model1_table,
model2.type=model2_table
)