rfm_table_order: RFM table (transaction data)

In rsquaredacademy/segmentr: Recency, Frequency and Monetary Value Analysis

RFM table (transaction data)

Description

Recency, frequency, monetary and RFM score.

Usage

rfm_table_order(
  data = NULL,
  customer_id = NULL,
  order_date = NULL,
  revenue = NULL,
  analysis_date = NULL,
  recency_bins = 5,
  frequency_bins = 5,
  monetary_bins = 5,
  ...
)

Arguments

data	A data.frame or tibble.
customer_id	Unique id of the customer.
order_date	Date of the transaction.
revenue	Revenue from the customer.
analysis_date	Date of analysis.
recency_bins	Number of bins for recency or custom threshold.
frequency_bins	Number of bins for frequency or custom threshold.
monetary_bins	Number of bins for monetary or custom threshold.
...	Other arguments.

Value

rfm_table_order returns a list with the following:

rfm	RFM table.
analysis_date	Date of analysis.
frequency_bins	Number of bins used for frequency score.
recency_bins	Number of bins used for recency score.
monetary_bins	Number of bins used for monetary score.
threshold	thresholds used for generating RFM scores.

Examples

analysis_date <- as.Date("2006-12-31")
rfm_table_order(
  rfm_data_orders, customer_id, order_date, revenue,
  analysis_date
)

# access rfm table
result <- rfm_table_order(
  rfm_data_orders, customer_id, order_date,
  revenue, analysis_date
)
result$rfm

# using custom threshold
rfm_table_order(rfm_data_orders, customer_id, order_date, revenue,
  analysis_date,
  recency_bins = c(115, 181, 297, 482), frequency_bins = c(4, 5, 6, 8),
  monetary_bins = c(256, 382, 506, 666)
)

rsquaredacademy/segmentr documentation built on March 16, 2024, 2:07 a.m.