Computed fields
  • 17 Oct 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Computed fields

  • Dark
    Light
  • PDF

Article summary

Computed fields allow aggregating data about your customer and fill their profile in with additional info based on their user behavior.
For example, such fields can help you identify what products, categories, or vendors your customer buys or views most frequently.
Computed fields can be used as any other custom fields, e. g. for segmentation, campaigns, promotions, etc.

Creating a computed field

You can create up to 10 fields 3 of which can be recalculated daily.

  1. Go to the Settings tab → System settings → Custom fields and click "Create computed field":

01_ComputedFields

  1. Fill in the settings:

00_ComputedFields

Currently you are able to calculate your customer's most frequently viewed or purchased product or category.
New functions to be added.

  • General settings
    • Name — the same as displayed in filters or campaigns
    • Brand
    • System name — is used in integrations and the message template engine
  • Recalculating
    • Frequency is daily or just once (per all the time the field exists)
    • Period is the data time frame you want to use in your report.
  • General settings
    • Which events to collect data for: views or orders
    • Which entity to search in processed data: product or product category

Find the most frequently purchased product:
02_ComputedFields

Find the most frequently purchased category of the four selected:

03_ComputedFields

  • Minimum views/orders for this product is the action number threshold for the value to be filled in the field.
  1. Click "Save"

Done:

04_ComputedFields

Filed computing is launched at night.

Customer search

Custom and computed fields are located in the same tab in your customer card:
05_ComputedFields

You can use filters to filter out the customers with the filed value needed:
06_ComputedFields

Display in the campaign

Computed field parameters are listed in Recipient.CustomField

To display products for a customer, use a parameter of this type: Recipient.CustomField.{Filed system name}.

It contains all the product fields:

07_ComputedField