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
desktop_states_v1 (UDF)
LTV states for Desktop. Results in strings like: "0_1_1_1_1" Where each component is 1. the age in days of the client 2. the day of week of first_seen_date 3. the day of week of submission_date 4. the activity level, possible values are 0-3, plus "00" for "dead" 5. whether the client is active on submission_date
Parameters
INPUTS
days_since_first_seen INT64, days_since_active INT64, submission_date DATE, first_seen_date DATE, death_time INT64, pattern INT64, active INT64, max_days INT64, lookback INT64
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