count_of_loan_declined | Returns the count of flag loan_declined that appeared in the specified time frame |
count_of_loan_defaulted | Returns the count of flag loan_defaulted that appeared in the specified time frame |
count_of_overdraft | Returns the count of flag overdraft that appeared in the specified time frame |
count_of_repayment_warning | Returns the count of flag repayment_warning that appeared in the specified time frame |
count_of_loan_approved | Returns the count of flag loan_approved that appeared in the specified time frame |
count_of_loan_disbursed | Returns the count of flag loan_disbursed that appeared in the specified time frame |
count_of_account_suspended | Returns the count of flag account_suspended that appeared in the specified time frame |
count_of_repayment_reminder | Returns the count of flag repayment_reminder that appeared in the specified time frame |
avg_of_end_of_day_depository_balance | Average of daily total balance held in debit and ewallet accounts |
avg_of_end_of_day_loan_balance | Average of daily total amount when account is credit_limit and event is cash_out |
count_of_airtime_purchase_events | The count of sms where transaction_type is airtime_purchase |
count_of_institutions | Returns the total number of unique financial inistitutions in the specified time frame |
count_of_salary_events | The count of sms where transaction_type is salary and event is cash_in |
count_of_transactions_depository | returns the total number of non-flag sms for debit and ewallet accounts |
avg_of_daily_stacked_loan_alerts | The daily average number of flags received by a user. |
avg_of_daily_stacked_loan_fes | The daily average number of inistitutions that sent a flag sms to the user |
data_density | Ratio of days where user recieved a relevant sms to total number of days in time range |
data_recency_days | The time in days between start_time for user and the most recent financial event or alert for the user, as an indicator of data recency, or freshness. |
count_of_difference_loans_opened_to_loans_delinquent | The difference between the number of alerts indicating loan approved or disbursed and the number of alerts indicating late or missed payment |
median_of_end_of_day_depository_balance | Median of daily total balance held in debit and ewallet accounts |
min_of_end_of_day_depository_balance | The minimum end of day balance for debit and ewallet accounts the user accross the specified time range |
avg_of_ewallet_end_of_day_depository_balance | The mean end of day balance for ewallet accounts the user accross the specified time range |
median_of_ewallet_end_of_day_depository_balance | The median end of day balance for ewallet accounts the user accross the specified time range |
min_of_ewallet_end_of_day_depository_balance | The minimum end of day balance for ewallet accounts the user accross the specified time range |
ewallet_net_cash_flow | Difference in amount between cash_in and cash_out transactions across ewallet accounts |
stdev_of_ewallet_end_of_day_depository_balance | The standard deviation of end of day balance for ewallet accounts the user accross the specified time range |
sum_of_ewallet_cash_in_events | The sum of amount where event is cash_in and account is ewallet |
sum_of_ewallet_cash_out_events | The sum of amount where event is cash_out and account is ewallet |
net_cash_flow | Difference in amount between cash_in and cash_out transactions across debit and ewallet accounts |
currency_percentage | Returns the percentage of each currency that appeared in the users transactions accross the specified time |
slope_of_end_of_day_depository_balance | The rate of change for the end of day balance for debit and ewallet accounts the user accross the specified time range |
slope_of_end_of_day_loan_balance | The rate of change for the end of day balance for crediit_limit accounts the user accross the specified time range |
stdev_of_end_of_day_depository_balance | The standard deviation of end of day balance for debit and ewallet accounts the user accross the specified time range |
sum_of_airtime_cash_in | The sum of amount when transaction_type is airtime_purchace and event is cash_in |
sum_of_cash_in_events | the sum of amount when event is cash_in |
sum_of_cash_out_events | the sum of amount when event is cash_out |
sum_of_depository_balances_latest | the sum of the most recent balance notifcation for all the user's inistitutions |
sum_of_settlements | The sum of amount when transaction_type is settlement and event is cash_in |
sum_of_salary | The sum of amount when transaction_type is salary and event is cash_in |
count_of_settlements | The count of sms where transaction_type is settlement and event is cash_in |
count_of_bill_payment | The count of sms where transaction_type is bill_payment |
sum_of_bill_payment | The sum of amount when transaction_type is bill_payment |
avg_of_salary | The mean of amount when transaction_type is salary and event is cash_in, where amount is summed per month divided by the number of months |
sum_of_traffic_fine | The sum of amount when transaction_type is traffic_fine |
count_of_traffic_fine | The count of sms where transaction_type is traffic_fine |
count_of_ewallet_purchase | The count of sms where transaction_type is purchase and account is ewallet |
sum_of_ewallet_purchase | The sum of amount when transaction_type is purchase and account is ewallet |
sum_of_cash_in_transfer | The sum of amount when transaction_type is transfer and event is cash_in |
count_of_cash_in_transfer | The count of sms where transaction_type is transfer and event is cash_in |
count_of_senders | the count of unique senders found in transfer sms |
sum_of_cash_out_transfer | The sum of amount when transaction_type is transfer and event is cash_out |
count_of_cash_out_transfer | The count of sms where transaction_type is transfer and event is cash_out |
count_of_recepients | the count of unique recepients found in transfer sms |
count_of_cash_in_events | The count of sms event is cash_in |
count_of_cash_out_events | The count of sms event is cash_out |
main_currency | Returns the most used currency by the user |
salary_recency_days | The time in days between start_time for user and the most recent salary sms for the user |
median_of_salary | The median of amount when transaction_type is salary and event is cash_in, where amount is summed per month divided by the number of months |
stdev_of_salary | The rate of change of amount when transaction_type is salary and event is cash_in, where amount is summed per month divided by the number of months |
salary_events_over_period_length | the number of salary related sms over specified time frame |