Calculated Segment Fields

Create your own custom calculations by combining segment fields together. Use these Calculated Segment Fields inside your segments.

Essentially a calculated segment field is a combination of multiple segment fields, or pieces of data, combined together to make a custom calculation. For example, Net Gaming Revenue or Return to Player.
Historically custom segments fields are something that is set up by FT specifically for each individual operator. They are custom-made by request. It is now possible to create and set up these segment fields by yourself inside FT CRM.
Calculated Segment Fields, once set up, will be displayed as segment fields when creating a new segment or smart segment. In the image below, you can see the calculated segments fields available from the segment field dropdown menu.
Calculated Segment Fields
Calculated Segment Fields
These Calculated Segment Fields can then be used to target specific player groups such as ‘Net Deposits greater than X’ in an Activity or Lifecycle.
Let's take a look at a couple of examples:
Net Gaming Revenue:
If we consider NGR to be; all bets minus all wins minus bonus costs then we can create a calculated segment field by combining the following segment fields:
Total Bets - Total Wins - Bonus Amount
​
Return to Player:
If we consider RTP to be; total amount of wins divided by the total number of bets then we can create a calculated segment field by combining the following segment fields:
Total Wins / Total Bets

Create a Calculated Segment Field

You can find Calculated Segment Fields inside Manage Segment Fields from the Setting Menu inside FT CRM.
Settings Menu -> Manage Segment Fields -> Calculated Segment Fields tab
Select New Calculated Segment Field CTA from the top-right corner of the page.
Create a new calculated segment field
Create a new calculated segment field

⚙️ General Details

The Name, Label and Description are the general details that you will use to identify your Calculated Segment Field:
  1. Name / Database Name - a descriptive name for your Calculated Segment Field. The name should consist of only numbers and/or letters and be separated by an underscore(_). This name cannot be changed once it has been saved. For example; Return_to_player
  2. Label / Segment Field Name- this will be the name of the Calculated Segment Field as it will appear in the dropdown menu when creating a new segment or smart segment.
Tip💡 : The label should be as accurate as possible to make sure you and your team can identify it from the list of segment fields when inside an activity or lifecycle.
  1. Description - use this space to add a detailed description with more information about how the calculated segment field has been created.
  2. Field Type - this refers to the way the end value of the segment field will be displayed. e.g. numerical, text etc. The type should match what the system is expecting for this particular field. For example, Birth Date should be a Date. Read more below.
  3. Sensitive Data - select "Is Sensitive Data?" to make your calculated segment field only visible to users with the right permissions in Users & Permissions.
  4. Enabled - select "Is Enabled?" to make your calculated segment field visible from the dropdown menu when creating segments from inside activities, lifecycles and smart segments.
General Details
General Details

Understanding Field Types

Let's take a deeper look at each available field type from the general settings. We can see what they mean and some real-life examples.
  1. Integer - a number that can be written without a fraction
    1. e.g. Deposit Count
Deposit Count
Deposit Count
  1. String - any sequence of characters (text, numbers and/or special characters)
    1. e.g. User Email
Email
Email
  1. Boolean - data that can only have the value true or false
    1. e.g. Blocked Players
Blocked Players
Blocked Players
  1. Double - number with a fraction (most commonly associated with currency amount)
    1. e.g. First Deposit Amount
First Deposit Amount
First Deposit Amount
  1. Datetime - date and time formatted as; YYYY-MM-DD HH:MM:SS
    1. e.g. Last Deposit Date
Last Deposit Date
Last Deposit Date
  1. Array - a collection of elements (strings)
    1. User Roles
Roles
Roles

🏗️ Calculated Fields Builder

Here you can enter your own formulas into the segment field builder.
Use Add Segment Field to add an existing segment field and use the calculator tools (+ - x / etc.) to connect the fields in the formula. We can see an example of how to calculate Return to Player.
Calculated Fields Builder - Return to Player
Calculated Fields Builder - Return to Player
Add as many segment fields as you need until you are satisfied with your calculation.
Aggregate Field Rounding - this setting allows you to identify how the result of the aggregated field should be rounded. In the above example, we can see this is set to 1. That means the value will be rounded to 1 decimal place. For example, the value will be displayed as 25.0.
The Aggregate Rounding will only work when the Segment Fields are set up with the input type: Double (decimal).

💻 Advanced SQL Editor

Here you can enter your own SQL queries to create new Calculated Segment Fields.
This selection is the type of query that you want the computation to run. As you can see from our example and the image below, the query is using the exact slug name that is set up and specified for each Segment Field.
Advanced SQL Editor
Advanced SQL Editor

🧪 Test Calculated Field

Run a test of your calculation using a player from the database to ensure it works as expected. Simply enter the User ID of the desired player and select Test.
Test calculated field
Test calculated field

✔️ Query Builder Settings

Input Type - this is related to the Field Type that is set in the General Settings of the Calculated Segment Field and defines what type of value you would enter for your segment field. Which in turn also determines what set of controls will be displayed for entering the value.
For example, a date picker to be displayed when entering a date value or a numerical text box to be displayed when entering an integer value.

⛹️‍♀️ Player Profile

The Calculated Segment Fields will also be displayed on the player profile to give you a customised player overview that is geared towards your business needs.