BeyondERP.Newsletter
Menu

Page · Retail and Commerce

RFM analysis

A page where you define a recency, frequency and monetary (RFM) analysis that gives each customer a calculated score based on their purchases.

Used by
Customer service manager, Customer service representative, Sales representative
Business process
Analyze sales performance
Menu item
MCRRFMDefinition
Main table
MCRRFMDefinition
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA page where you define a recency, frequency and monetary (RFM) analysis that gives each customer a calculated score based on their purchases.
What you do hereUse this page to set up RFM definitions (divisions, priority, multiplier and period for each rating) so customers can be scored and segmented by purchase behaviour.
ExampleFor example, with ratings from 1 to 5, a customer scored 535 bought recently, buys moderately often and spends a lot.
RFM analysis page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze sales performance
Menu pathRetail and Commerce › Retail and Commerce IT › RFM analysis
Used next byCustomer service Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Retail and Commerce > Retail and Commerce IT > RFM analysis.
  2. Select New and enter a name in RFM definition.
  3. Enter a start date and end date.
  4. On the General FastTab, set Even distribution, Add scores and Save history as needed.
  5. On the Recency, Frequency and Monetary FastTabs, set Divisions, Priority and Multiplier (and Period or Gross/net).
  6. Save the definition.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Even distributionRequires each section of the score to contain an equal count of customers.Microsoft Learn EvenDistribution
Add scoresAdds the three ratings into one aggregate score.Microsoft Learn AddScores
Save historySaves customer statistics used to calculate the score.Microsoft Learn SaveHistory
DivisionsNumber of groups used to calculate a rating.Microsoft Learn
PriorityWeight of the rating relative to the other ratings.Microsoft Learn
MultiplierValue the rating is multiplied by.Microsoft Learn
Gross/netWhether the monetary rating uses the gross or net invoice amount.Microsoft Learn RFMGrossOrNet
Subtract returnsSubtracts return amounts from the customer's invoice total.Microsoft Learn RFMSubtractReturns

Test checklist

  1. Create an RFM definition with start and end dates, 5 divisions on each of Recency, Frequency and Monetary, and Save history on.
  2. On Monetary, set Gross/net and Subtract returns to match your policy.
  3. Open Call center > Journals > Customer service and search for a customer with invoiced orders.
  4. Check the RFM score shows in the Order history group and matches the Add scores setting (three digits or a sum).

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneReversible: Definitions can be edited. With Save history on, the statistics used for scoring are stored; Clear history on the record removes them, so clear it only when you want scoring to start again. Microsoft Learn
Technical architect

5Technical

Menu itemMCRRFMDefinition Checked in Dynamics 365
FormMCRRFMDefinition Checked in Dynamics 365
TableMCRRFMDefinitionShown as “RFM DEFINITION TABLE” in Record infoKey field: RFMDefinitionNameChecked in Dynamics 365
Who can open itPrivilegesMaintain RFM definitions MCRRFMDefinitionMaintainDutiesMaintain customer service MCRCustomerServiceMaintain
3 security rolesCustomer service manager TradeCustomerServiceManagerCustomer service representative TradeCustomerServiceRepresentativeSales representative TradeSalesRepresentative
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales representative TradeSalesRepresentativeCustomer service representative TradeCustomerServiceRepresentativeCustomer service manager TradeCustomerServiceManagerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageRFM analysis: RFM analysisChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=MCRRFMDefinition
Table definitionMCRRFMDefinition columns and relations Microsoft data model
Everyone

7Sources