Marketing, Analytics, Marketing Analytics, Data Analytics, Digital Marketing.
customer. To do this, add Order Value as a Value to get the total amount spent per customer, and in the Summarize by column, indicate SUM.​ That’s it for analysis preparation. Now we need to copy this pivot table data to a new sheet to calculate RFM values, and rename the columns to Recency,