Skip to content

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

Source | Edit

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

Source | Edit

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

Source | Edit

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

Source | Edit

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

Source | Edit

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

Source | Edit