Ltv
android_states_v1 (UDF)
LTV states for Android. Results in strings like: "1_dow3_2_1" and "0_dow1_1_1"
Parameters
INPUTS
adjust_network STRING, days_since_first_seen INT64, submission_date DATE, first_seen_date DATE, pattern INT64, active INT64, max_weeks INT64, country STRING
android_states_v2 (UDF)
LTV states for Android. Results in strings like: "1_dow3_2_1" and "0_dow1_1_1"
Parameters
INPUTS
adjust_network STRING, days_since_first_seen INT64, days_since_seen INT64, death_time INT64, submission_date DATE, first_seen_date DATE, pattern INT64, active INT64, max_weeks INT64, country STRING
OUTPUTS
STRING
android_states_with_paid_v1 (UDF)
LTV states for Android. Results in strings like: "1_dow3_organic_2_1" and "0_dow1_paid_1_1"
These states include whether a client was paid or organic.
Parameters
INPUTS
adjust_network STRING, days_since_first_seen INT64, submission_date DATE, first_seen_date DATE, pattern INT64, active INT64, max_weeks INT64, country STRING
OUTPUTS
STRING
android_states_with_paid_v2 (UDF)
Get the state of a user on a day, with paid/organic cohorts included. Compared to V1, these states have a "dead" state, determined by "dead_time". The model can use this state as a sink, where the client will never return if they are dead.
Parameters
INPUTS
adjust_network STRING, days_since_first_seen INT64, days_since_seen INT64, death_time INT64, submission_date DATE, first_seen_date DATE, pattern INT64, active INT64, max_weeks INT64, country STRING
OUTPUTS
STRING
get_state_ios_v2 (UDF)
LTV states for iOS.
Parameters
INPUTS
days_since_first_seen INT64, days_since_seen INT64, submission_date DATE, death_time INT64, pattern INT64, active INT64, max_weeks INT64
OUTPUTS
STRING