Trading Vertical

Our Vanilla Out-of-the-Box (OOTB) solution delivers a consistent data structure tailored for trading operations, so you can segment and personalize without building attributes from scratch. Below, you will find the input data the Trading vertical requires and the output attributes it creates in your Optimove instance.

What Data Should You Send?

The Trading vertical requires five input tables:

  • Customers: trader profile details, such as age, country, and contact preferences.
  • Transactions: deposits, withdrawals, and bonuses.
  • Assets: the tradable instruments, such as currency pairs or commodities.
  • Trade: trading activity.
  • Positions: open and closed positions.

For the field-level schema, data types, and mandatory fields of each table, see the Trading guide.

What You Will See in Your Instance

Once your data is loaded, the following attributes are available in your Optimove instance, grouped by type.

Demographic Attributes

Profile details about each trader, used to segment and personalize by who the trader is. For example:

  • A trading company uses the AGE attribute to segment traders into age groups and tailor educational content that increases engagement and retention.
Demographic Attributes
Attribute NameDescriptionSource Table
AddressThe trader's address.Customers
AgeThe trader's age, calculated from Date of Birth.Customers
CityThe trader's city.Customers
CountryThe trader's country.Customers
CurrencyThe trader's currency.Customers
Date of BirthThe trader's date of birth.Customers
EmailThe trader's email address.Customers
First NameThe trader's first name.Customers
GenderThe trader's gender (Male, Female, or Unknown).Customers
LanguageThe trader's language.Customers
Last Login DateThe date of the trader's last login.Customers
Last NameThe trader's last name.Customers
Mobile NumberThe trader's mobile number.Customers
Referral TypeHow the trader was referred to your site (for example, SEO, Affiliate, or Advertising).Customers
Registered PlatformThe platform the trader registered on (for example, Web, Android App, or iOS App).Customers
Registration DateThe date the trader registered.Customers
Account CurrenciesThe currencies of the trader's accounts, as a semicolon-separated list (for example, USD;EUR).Customers
Account TypesThe account types associated with the trader, as a semicolon-separated list (for example, CFD;Forex;Crypto).Customers
Brand NameThe brand the trader belongs to, when you run multiple brands.Customers
Customer IDThe trader's unique customer identifier.Customers
KYC StageThe trader's KYC (Know Your Customer) verification stage.Customers
Number of Accounts, LifetimeTotal number of accounts associated with the trader.Customers
Number of Demo Accounts, LifetimeNumber of demo (training) accounts linked to the trader.Customers
Number of Live Accounts, LifetimeNumber of live trading accounts linked to the trader.Customers
Total BalanceTotal aggregated balance across all of the trader's accounts.Customers

Consent Attributes

Channel permissions and eligibility flags for each trader, all sourced from the Customers table. A kickoff meeting is held for each channel to make sure setup matches the channels you use. For example:

  • A company uses the ALLOW_EMAIL attribute to send promotional emails only to traders who have explicitly opted in, supporting compliance with privacy regulations.
Consent Attributes
Attribute NameDescriptionSource Table
Allow EmailWhether promotional email may be sent to the trader (Yes/No).Customers
Allow PushWhether promotional push notifications may be sent to the trader (Yes/No).Customers
Allow SMSWhether promotional SMS messages may be sent to the trader (Yes/No).Customers
Is Blocked*Whether the trader is blocked, for example for fraud (Yes/No).Customers
Is Email VerifiedWhether the trader's email address is verified (Yes/No).Customers
Is OptinWhether the trader has opted in to at least one marketing channel (Yes/No).Customers
Is SMS VerifiedWhether the trader's mobile number is verified (Yes/No).Customers
Is Test*Whether the trader is a test customer (Yes/No).Customers

Please Note: Is_OptIn is a general consent indicator. It shows whether a trader has opted in to at least one channel. For example, a trader who opts in to email but not push has Allow_Push = 'No', Allow_Email = 'Yes', and Is_OptIn = 'Yes'.

Is Blocked and Is Test are not channel consent. Use them to exclude traders who should not receive marketing communications.

Please Note: Consent attributes are provided alongside your other customer data. Optimove reads the values you send, and you are responsible for managing the consent logic, rules, and maintenance.

Calculated Attributes

Calculated attributes track traders' financial and trading behavior from your Transactions, Trade, and Positions data. They are grouped into Frequency, Monetary, and Recency attributes and are calculated daily for Lifetime and, where listed, additional snapshot periods:

  • Lifetime: Daily aggregated data over the trader's entire history.
  • 2 Weeks: Daily aggregated data for the last two weeks.
  • 1 Month: Daily aggregated data for the last month.
  • 3 Months: Daily aggregated data for the last three months.
  • 1 Year: Daily aggregated data for the last year.

For example:

  • A company uses AVERAGE_DEPOSIT_AMOUNT to identify high-value traders who consistently deposit large amounts, and offers them personalized rewards or exclusive services.
Frequency Attributes
Attribute NameDescriptionSource TableSnapshot Periods
Frequency, Last Three MonthsDays between the first and last activity, divided by (number of activity days minus 1), in the last three months.Transactions, Trade3 Months
Number of Bonus Granted, Lifetime*Number of records in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Bonus'.Transactions1 Month
Number of Deposits, Lifetime*Number of records in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Deposit'.Transactions2 Weeks
Number of Deposit Days, Lifetime*Number of distinct TRANSACTION_DATE values in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Deposit'.Transactions2 Weeks
Number of Withdrawals, Lifetime*Number of records in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Withdrawal'.TransactionsLifetime
Number of Withdrawal Days, Lifetime*Number of distinct TRANSACTION_DATE values in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Withdrawal'.TransactionsLifetime
Number of Activity Days, Lifetime*Number of days with any activity (deposits or trades), lifetime.Transactions, TradeLifetime
Number of Buy Trades, Lifetime*Number of trades of type Buy in the Trade table, lifetime.TradeLifetime
Number of Currently Open Live Positions, LifetimeNumber of live positions the trader currently has open.PositionsLifetime
Number of Currently Open Positions, LifetimeNumber of positions the trader currently has open.PositionsLifetime
Number of Demo Trades, Lifetime*Number of demo trades, lifetime.TradeLifetime
Number of Live Trades, Lifetime*Number of live trades, lifetime.TradeLifetime
Number of Mobile Trades, Lifetime*Number of trades made on mobile, lifetime.TradeLifetime
Number of Positions Closed, Lifetime*Number of positions the trader has closed, lifetime.TradeLifetime
Number of Positions Opened, Lifetime*Number of positions the trader has opened, lifetime.TradeLifetime
Number of Position Opening Days, Lifetime*Number of distinct days on which the trader opened a position, lifetime.TradeLifetime
Number of Sell Trades, Lifetime*Number of trades of type Sell in the Trade table, lifetime.TradeLifetime
Number of Trades, Lifetime*Number of trades, lifetime.TradeLifetime
Number of Trade Days, Lifetime*Number of distinct days on which the trader traded, lifetime.Trade2 Weeks
Number of Web Trades, Lifetime*Number of trades made on web, lifetime.TradeLifetime
Favorite Asset CategoryThe asset category the trader trades most.Trade, AssetsLifetime, 3 Months
Frequency Categorical, Last Three MonthsCategorical attribute based on Frequency, Last Three Months ('1 to 2 Days', '2 to 10 Days', 'Over 10 Days').Transactions, Trade3 Months
Deposit Activity Categorical, Last Two WeeksCategorical attribute describing deposit activity in the last two weeks (for example, '2 or More Deposits', 'Up to 1 Deposit').Transactions2 Weeks
Monetary Attributes
Attribute NameDescriptionSource TableSnapshot Periods
Average Deposit Amount, LifetimeTotal Deposit Amount, Lifetime divided by Number of Deposits, Lifetime.TransactionsLifetime
Average Monthly Deposit Amount, LifetimeThe trader's average deposit amount per month, lifetime.TransactionsLifetime
Bonus Deposit Ratio, LifetimeTotal Bonus Granted Amount, Lifetime divided by Total Deposit Amount, Lifetime.TransactionsLifetime
Cashout Ratio, LifetimeTotal Withdrawal Amount, Lifetime divided by Total Deposit Amount, Lifetime.TransactionsLifetime
Average Daily Investment Amount, LifetimeThe trader's average investment amount per trade day.Trade2 Weeks, 3 Months
Net Cash, Lifetime*Total Deposit Amount, Lifetime minus Total Withdrawal Amount, Lifetime.Transactions2 Weeks
Total Bonus Granted Amount, Lifetime*Sum of TRANSACTION_AMOUNT in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Bonus'.TransactionsLifetime
Total Deposit Amount, Lifetime*Sum of TRANSACTION_AMOUNT in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Deposit'.Transactions2 Weeks
Total Withdrawal Amount, Lifetime*Sum of TRANSACTION_AMOUNT in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Withdrawal'.Transactions2 Weeks
Customer Profit, Lifetime*The trader's total profit (positive) or loss (negative), lifetime.TradeLifetime
Net Revenue, Lifetime*Total net revenue generated by the trader, lifetime.Trade2 Weeks
Total Investment Amount, Lifetime*Total amount the trader has invested, lifetime.Trade2 Weeks
Total Investment Amount Mobile, Lifetime*Total amount the trader has invested on mobile, lifetime.TradeLifetime
Total Investment Amount Web, Lifetime*Total amount the trader has invested on web, lifetime.TradeLifetime
Recency Attributes
Attribute NameDescriptionSource TableSnapshot Periods
Days Since First DepositDays since the trader's first deposit.TransactionsLifetime
Days Since Last DepositDays since the trader's last deposit.TransactionsLifetime
Days Since Last LoginDays since the trader's last login.CustomersLifetime
Days Since Last WithdrawalDays since the trader's last withdrawal.TransactionsLifetime
Days Since First ActivityDays since the trader's first activity.Transactions, TradeLifetime
Days Since First Position ClosedDays since the trader first closed a position.TradeLifetime
Days Since First Position OpenedDays since the trader first opened a position.TradeLifetime
Days Since Last ActivityDays since the trader's last activity.Transactions, TradeLifetime
Days Since Last Live TradeDays since the trader's last live trade.TradeLifetime
Days Since Last Position ClosedDays since the trader last closed a position.TradeLifetime
Days Since Last Position OpenedDays since the trader last opened a position.TradeLifetime
Days Since Last TradeDays since the trader's last trade.TradeLifetime
First Deposit Date*First TRANSACTION_DATE in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Deposit'.TransactionsLifetime
Last Deposit Date*Last TRANSACTION_DATE in the Transactions table where STATUS is 'Approved' and TRANSACTION_TYPE is 'Deposit'.TransactionsLifetime
First Activity Date*Date of the trader's first activity.Transactions, TradeLifetime
First Position Close Date*Date the trader first closed a position.TradeLifetime
First Position Open Date*Date the trader first opened a position.TradeLifetime
Last Activity Date*Date of the trader's last activity.Transactions, TradeLifetime
Last Live Trade Date*Date of the trader's last live trade.TradeLifetime
Last Position Close Date*Date the trader last closed a position.TradeLifetime
Last Position Open Date*Date the trader last opened a position.TradeLifetime
Last Trade Date*Date of the trader's last trade.TradeLifetime
Time Since Last ActivityCategorical attribute based on Days Since Last Activity ('1 Day', '2 to 7 Days', 'More than 7 Days').Transactions, TradeLifetime
Time Since First ActivityCategorical attribute based on Days Since First Activity ('1 Day', '2 to 7 Days', 'More than 7 Days').Transactions, TradeLifetime
Time Since RegistrationCategorical attribute based on Days Since Registration ('1 Day', '2 to 7 Days', '1 Week to 1 Month', '1 to 3 Months', 'More than 3 Months').CustomersLifetime

Note: Attributes marked with * are part of the Activity History feature.

Lifecycle Stage (LCS) Attributes

Attributes describing where each trader is in their lifecycle, how long they have been there, and how they got there. For example:

  • A company uses the Lifecycle Stage Before Churn attribute to find previously valuable traders and target them with reactivation offers.
Lifecycle Stage (LCS) Attributes
Attribute NameDescriptionSource TableSnapshot Periods
Days Since RegistrationDays since the trader registered.CustomersLifetime
Days In Churn, LifetimeNumber of days the trader has spent in Churn.Internal TablesLifetime
Days In Reactivated, LifetimeNumber of days the trader has spent in Reactivated.Internal TablesLifetime
Days Since Last ReactivationDays since the trader was last reactivated.Internal TablesLifetime
Days Since Lifecycle Stage ChangeDays since the trader moved to their current lifecycle stage.Internal TablesLifetime
Lifecycle Stage Before ChurnThe lifecycle stage the trader was in before churning.Internal TablesLifetime
Number of Times Churned, LifetimeNumber of times the trader has churned.Internal TablesLifetime
Previous Lifecycle StageThe lifecycle stage the trader was in before moving to the current one.Internal TablesLifetime
Reactivation ActionThe activity that reactivated the trader after churning.Internal TablesLifetime
Flex Deposit Activity Reactivated, Last Two WeeksCategorical deposit activity for Reactivated traders in the last two weeks ('2 or More Deposits', '1 Deposit', 'No Recent Deposits').Internal Tables2 Weeks
Lifecycle StageThe trader's current lifecycle stage.Internal TablesLifetime
Time Since Last Activity ChurnCategorical attribute for churned traders based on Days Since Last Activity ('Up to 1 Month', '1 to 3 Months', '3 to 6 Months', 'More than 6 Months').Internal TablesLifetime
Dormant TypeCategorical attribute that distinguishes between depositor and non-depositor dormant traders.Internal TablesLifetime
Investment Amount Percentile By LCSCategorical attribute that divides traders into percentiles within their lifecycle stage based on investment amount.Internal TablesLifetime, 2 Weeks, 3 Months
Deposit Percentile By Lifecycle StageCategorical attribute that divides traders into percentiles within their lifecycle stage based on deposit amount.Internal TablesLifetime, 2 Weeks, 3 Months

Product Attributes – Purchase History

Attributes of the assets a trader has traded, available for segmentation by product. For example:

  • A brokerage uses the ASSET_CATEGORY attribute to identify traders who prefer cryptocurrencies and sends them targeted market analysis and news.
Product Attributes – Purchase History
Attribute NameDescriptionSource Table
Asset CategoryAsset category from the Assets table.Product History
Asset NameAsset name from the Assets table.Product History

Out-of-the-box Campaign KPIs

Out-of-the-box (OOTB) Campaign KPIs measure the impact of your campaigns by comparing targeted trader groups against a control group:

  • Number of Deposits: Tracks deposit frequency, showing whether a campaign encourages financial commitment.
  • Deposit Amount: Sums the deposits made by traders, showing a campaign's effect on financial activity.
  • Number of Trades: Counts trades, showing a campaign's impact on trading engagement.
  • Total Investment Amount: Measures the total amount invested, showing a campaign's influence on trading volume.
  • Net Revenue: Calculates net revenue from trading activity, showing campaign profitability.

Understanding Your Traders: Grouping and Predicting Behavior (Segmentation Model)

To help you connect with your traders in the best way, Optimove organizes them into groups based on their actions, such as how long it's been since they last traded, how much they deposit, or how much they invest. This is called Segmentation. Optimove also uses these groups to predict what traders might do next, such as whether they'll keep trading or become inactive.

Trader Groups: Organizing Traders by Their Journey

Optimove groups your traders by where they are in their journey with your platform. These stages are called Lifecycle Stages (LCS), and each stage is broken down by different segmentation layers.


Here's how traders are grouped at each stage:

1. Non-Depositors: Traders Who Registered but Haven't Deposited

These traders have signed up for your platform but haven't added money to their account yet. We group them by how long it's been since they joined.

Segmentation LayerDetails
Time Since Registration1 Day, 2 to 7 Days, 1 Week to 1 Month, 1 to 3 Months, More than 3 Months

Example: A trader who registered yesterday but hasn't deposited could receive a "Get Started Trading" email with a platform guide to encourage their first deposit.

2. New: Just Started Depositing and Trading

These traders recently made their first deposit and started trading. We group them by investment amount, deposit activity, and time since their first and last activity.

Segmentation LayerDetails
Investment Amount Percentile Last 2 WeeksTop 10 Percent Trade Amount, 10 to 50 Percent Trade Amount, Bottom 50 Percent Trade Amount
Deposit Activity Last 2 Weeks2 or More Deposits, Up to 1 Deposit
Time Since First Activity1 Day, 2 to 7 Days, More than 7 Days
Time Since Last Activity1 Day, 2 to 7 Days, More than 7 Days

Example: A new trader in the bottom 50% for investment amount might receive a push notification linking to a webinar on basic trading strategies.

3. Active: Regular Traders

These traders regularly log in and trade. We group them by recent activity, deposit and investment amount in the last 3 months, and how often they trade.

Segmentation LayerDetails
Time Since Last Activity1 Day, 2 to 7 Days, 8 to 14 Days, More than 14 Days
Deposit Percentile Last 3 MonthsTop 10 Percent Total Deposit Amount, 10 to 50 Percent Total Deposit Amount, Bottom 50 Percent Total Deposit Amount
Frequency Categorical Last 3 Months1 to 2 Days, 2 to 10 Days, Over 10 Days
Investment Amount Percentile Last 3 MonthsTop 10 Percent Trade Amount, 10 to 50 Percent Trade Amount, Bottom 50 Percent Trade Amount

Example: An active trader in the top 10% for deposits might get an email inviting them to an exclusive Q&A with a market analyst.

4. Churn: Stopped Trading

These traders haven't logged in or traded in a while. We group them by time since their last activity, past deposit and investment amounts, and the stage they were in before they stopped.

Segmentation LayerDetails
Time Since Last ActivityUp to 1 Month, 1 to 3 Months, 3 to 6 Months, More than 6 Months
Deposit PercentileTop 10 Percent Total Deposit Amount, 10 to 50 Percent Total Deposit Amount, Bottom 50 Percent Total Deposit Amount
Investment Amount PercentileTop 10 Percent Trade Amount, 10 to 50 Percent Trade Amount, Bottom 50 Percent Trade Amount
LCS Before ChurnNew, Active, Reactivated

Example: A churned trader who was previously a top depositor and hasn't been active in two months might receive a "Market Opportunities You're Missing" email with a bonus on their next deposit.

5. Reactivated: Came Back After a Break

These traders stopped trading for a while but recently returned. We group them by recent activity, deposits, and investment amount since coming back.

Segmentation LayerDetails
Time Since Last Activity1 Day, 2 to 7 Days, More than 7 Days
Deposit Percentile By LCSTop 10 Percent Total Deposit Amount, 10 to 50 Percent Total Deposit Amount, Bottom 50 Percent Total Deposit Amount
Investment Amount Percentile Last 2 WeeksTop 10 Percent Trade Amount, 10 to 50 Percent Trade Amount, Bottom 50 Percent Trade Amount
Deposit Activity Last 2 Weeks2 or More Deposits, 1 Deposit, No Recent Deposits

Example: A reactivated trader who deposited three days ago might get a push notification with a "Welcome Back" bonus to encourage their next trade.

6. Dormant: Inactive for a Long Time

These traders haven't been active in a very long time, whether they've deposited before or only signed up. We group them by whether they have ever deposited.

Segmentation LayerDetails
Dormant TypeDepositor, Non-Depositor

Example: A dormant trader who previously deposited might get an email about a major market event, such as an interest rate decision, with a special offer to start trading again.

Please note that the out-of-the-box customer model excludes traders who haven't been active or registered for over 3 years.

Why This Matters for the Trading Vertical

By grouping your traders and predicting their behavior, you can create personalized experiences, whether that means offering a trading guide to a new trader, rewarding a loyal trader with exclusive market insights, or winning back someone who has been inactive.

Want to learn more? Check out this guide: The Optimove Model.


Did this page help you?