Accessing data for Recency, Frequency and Monetary models

After Running training and scoring jobs that calculate values for output attributes, you can do one of the following to access the data.

  • Create an export job and select the Customer_RFMScore data object to export. You can then review the values in the output attributes.
  • Sample data for the model outputs can be viewed using the Data viewer page. You can view a maximum of 200 records from a data object.

    • An image of the Data viewer

To verify and review with an export job:

  1. Follow the steps for Creating export jobs.
  2. When you get to Step 2: Data payload, for Payload type, select Data object.
  3. In the field for Data object, select Customer_RFMScore.

When the data object is exported, review the following output attributes.

Attribute Description
SourceCustomer_RFMScoreID The unique identifier for the data object.
SourceID The unique identifier for the source.
SourceContactID The unique identifier for the contact.
RFM_Timestamp The date and time when the values were last generated.
R_Score The recency score between one and five.
F_Score The frequency score between one and five.
M_Score The monetary score between one and five.
RF_Persona The persona generated for the user.

To verify and review using the Data viewer page:

  1. Click the Oracle icon Image of the application navigation button. Use it to access the different parts of Oracle Unity. in the bottom-right corner to open the navigation menu.
  2. Select Data viewer.
  3. Use the drop-down menu for Select or search for data object and select Customer_RFMScore.

    4. An image of the object selector

  4. Click Filters An image of the filters icon. The Filters dialog displays.

    5. An image of the filters button

  5. Use the drop-down menu to select or search for the following attributes:
    6. Attribute Description
    SourceCustomer_RFMScoreID The unique identifier for the data object.
    SourceID The unique identifier for the source.
    SourceContactID The unique identifier for the contact.
    RFM_Timestamp The date and time when the values were last generated.
    R_Score The recency score between one and five.
    F_Score The frequency score between one and five.
    M_Score The monetary score between one and five.
    RF_Persona The persona generated for the user.
  6. Click AddAn image of the Add button.

    7. An image of the data viewer filters

  7. Use the drop-down menu for the output attributes and select the Is not empty operator.

    8. An image of the operator drop-down lists

  8. Click Apply.
  9. Click Column settingsAn image of the column settings button.

    10. An image of the column settings icon

  10. Click the checkbox for the output attributes to display them.

    11. An image of the column visibility settings

  11. Click Apply.

You can review values for up to 200 records.

Learn more

Viewing data object records

Viewing data object records

Creating export jobs

data science, data science model, analyze data, create data science model, how to create a data science model, recency, frequency, monetary, rfm, rfm model