0 / 0
rfmaggregatenode properties

rfmaggregatenode properties

RFM Aggregate node icon The Recency, Frequency, Monetary (RFM) Aggregate node enables you to take customers' historical transactional data, strip away any unused data, and combine all of their remaining transaction data into a single row that lists when they last dealt with you, how many transactions they have made, and the total monetary value of those transactions.

Example

node = stream.create("rfmaggregate", "My node")
node.setPropertyValue("relative_to", "Fixed")
node.setPropertyValue("reference_date", "2007-10-12")
node.setPropertyValue("id_field", "CardID")
node.setPropertyValue("date_field", "Date")
node.setPropertyValue("value_field", "Amount")
node.setPropertyValue("only_recent_transactions", True)
node.setPropertyValue("transaction_date_after", "2000-10-01")
Table 1. rfmaggregatenode properties
rfmaggregatenode properties Data type Property description
relative_to Fixed Today Specify the date from which the recency of transactions will be calculated.
reference_date date Only available if Fixed is chosen in relative_to.
contiguous flag If your data is presorted so that all records with the same ID appear together in the data stream, selecting this option speeds up processing.
id_field field Specify the field to be used to identify the customer and their transactions.
date_field field Specify the date field to be used to calculate recency against.
value_field field Specify the field to be used to calculate the monetary value.
extension string Specify a prefix or suffix for duplicate aggregated fields.
add_as Suffix Prefix Specify if the extension should be added as a suffix or a prefix.
discard_low_value_records flag Enable use of the discard_records_below setting.
discard_records_below number Specify a minimum value below which any transaction details are not used when calculating the RFM totals. The units of value relate to the value field selected.
only_recent_transactions flag Enable use of either the specify_transaction_date or transaction_within_last settings.
specify_transaction_date flag  
transaction_date_after date Only available if specify_transaction_date is selected. Specify the transaction date after which records will be included in your analysis.
transaction_within_last number Only available if transaction_within_last is selected. Specify the number and type of periods (days, weeks, months, or years) back from the Calculate Recency relative to date after which records will be included in your analysis.
transaction_scale Days Weeks Months Years Only available if transaction_within_last is selected. Specify the number and type of periods (days, weeks, months, or years) back from the Calculate Recency relative to date after which records will be included in your analysis.
save_r2 flag Displays the date of the second most recent transaction for each customer.
save_r3 flag Only available if save_r2 is selected. Displays the date of the third most recent transaction for each customer.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more