Marketing, Analytics, Marketing Analytics, Data Analytics, Digital Marketing.
calculates the total spent by each customer, thus representing the ‘Monetary’ part of RFM. By applying ‘COUNT(*)’, the query counts the number of rows for each customer, thus representing the ‘Frequency’ part of RFM. You can run this SQL query in typical SQL environments like Google BigQuery,