From raw data to a certified, interactive data product — six governed steps, no code required.
Browse the role-filtered Data Catalog and select the source table. Row counts, descriptions, and sensitivity flags are visible before any query is written.
Select exactly which columns the AI will work with. Only schema metadata is used — no raw data is ever sent to the AI.
Describe what you need in plain English. The AI validates the request for clarity and SQL suitability.
The AI produces a validated SELECT query tailored to the use case. The query is tested against live data before proceeding — only SELECT statements are permitted.
Query results are previewed before any visualization is created. A named approver signs off on data quality — this gate is required and tracked.
The AI recommends the best visualization type and generates the raw program code required for an interactive rendering. Each refinement is a natural language instruction — no code editing required. Every iteration is stored and reusable.
| Column | Definition | Domain | Examples | Synonyms |
|---|---|---|---|---|
| ACCOUNTOPENDATE | The specific date when the client first opened their account with the brokerage firm. This marks the beginning of the client relationship and is used to calculate tenure. | Customer | 2020-01-15, 2019-03-22, 2021-07-10, 2018-11-05, 2022-02-28 | Account Start Date, Relationship Start, Opening Date, Onboarding Date, Account Creation Date |
| ACCOUNTTYPE | The category of investment account that defines the structure, tax treatment, and permitted investments. Different account types have specific rules and benefits for clients. | Finance | Individual, Joint, IRA, 401k, Trust | Account Category, Investment Type, Account Class, Portfolio Type, Account Structure |
| ACTIVITY_DEPOSITSLASTYEAR | The total dollar amount of money deposited into the client's account during the past 12 months. This includes cash deposits, transfers from external accounts, and any other funds added to increase the account balance, excluding investment gains. | Finance | 25000, 8500, 45000, 12750, 67500 | Annual Deposits, Yearly Contributions, 12-Month Inflows, Annual Funding, Yearly Additions |
| ACTIVITY_LEVEL | A measure of how frequently the client engages in trading and account activities. This helps determine service needs and commission revenue potential from the client relationship. | Operations | High, Medium, Low, Very High, Inactive | Trading Activity, Engagement Level, Transaction Frequency, Activity Rating, Usage Level |
| ACTIVITY_MONTHLYDEPOSITAVERAGE | The average amount of money a client deposits into their brokerage account each month, calculated over a specific time period. This metric helps assess client cash flow patterns and their commitment to investing. It provides insights into client behavior and can be used to identify high-value clients or those who may need additional engagement. | Customer | $1,250.75, $3,480.20, $750.00, $4,125.50, $2,890.35 | Monthly Deposit Average, Average Monthly Contributions, Monthly Funding Average, Average Monthly Deposits, Monthly Cash Inflow Average |
| ACTIVITY_TRADESLASTMONTH | The total number of individual trades executed by the client during the most recent completed month. This includes both buy and sell transactions across all securities and provides insight into the client's trading frequency and activity level. | Sales | 8, 15, 3, 25, 0 | Monthly Trade Count, Recent Trading Activity, Last Month Transactions, Monthly Trade Volume, Recent Trade Frequency |
| ACTIVITY_WITHDRAWALSLASTYEAR | The total dollar amount withdrawn from the client's account over the past 12 months. This includes cash withdrawals, transfers to external accounts, and any other funds removed from the account, excluding investment losses or fees. | Finance | 15000, 3200, 28000, 9500, 41000 | Annual Withdrawals, Yearly Distributions, 12-Month Outflows, Annual Redemptions, Yearly Withdrawals |
| AGE_GROUP | A categorized age range that the client falls into, used for demographic analysis and tailoring investment products and services to different life stages and financial needs. | Customer | 25-34, 35-44, 45-54, 55-64, 65+ | Age Range, Age Category, Age Bracket, Life Stage, Age Cohort |
| ALLOCATION_ALTERNATIVES | The percentage of the client's portfolio invested in alternative investments such as real estate investment trusts, commodities, private equity, hedge funds, or other non-traditional assets. These investments often provide diversification benefits and may have different risk-return profiles than stocks and bonds. | Finance | 15.3, 8.7, 25.1, 0.0, 12.9 | Alternative Investments, Non-Traditional Assets, Alt Allocation, Specialty Investments, Alternative Holdings |
| ALLOCATION_BONDS | The percentage of the client's portfolio allocated to fixed-income securities such as government bonds, corporate bonds, and bond funds. This allocation represents the conservative, income-generating portion of the portfolio that typically provides stability and regular interest payments. | Finance | 30.5, 45.8, 20.3, 55.2, 15.7 | Fixed Income Allocation, Bond Percentage, Fixed Income Exposure, Bond Weight, Debt Securities Allocation |
| ALLOCATION_CASH | The percentage of the client's portfolio held in cash equivalents, including money market funds, savings accounts, and short-term liquid instruments. This allocation represents the most liquid and conservative portion of the portfolio, available for immediate use or future investment opportunities. | Finance | 10.2, 25.6, 5.8, 35.4, 8.9 | Cash Position, Liquid Assets Percentage, Cash Weight, Money Market Allocation, Cash Holdings |
| ALLOCATION_STOCKS | The percentage of the client's total portfolio value invested in stock securities, including individual stocks and equity-based funds. This allocation percentage represents the equity exposure within the overall investment mix and indicates the client's risk appetite and growth orientation. | Finance | 65.0, 45.3, 80.2, 25.7, 55.8 | Equity Allocation, Stock Percentage, Equity Exposure, Stock Weight, Equity Holdings Percentage |
| CLIENTID | A unique identifier assigned to each customer who has an account with the brokerage. This code allows the firm to track and distinguish between different clients across all systems and transactions. | Customer | CLI-789456, CU-001234, BRK-456789, ID-987654, C-112233 | Customer ID, Client Number, Account Holder ID, Customer Code, Client Reference |
| CLIENTSTATUS | The current standing of the client's relationship with the brokerage, indicating whether the account is active, inactive, or has other special conditions that affect service delivery. | Customer | Active, Inactive, Suspended, Closed, Pending | Account Status, Customer Status, Relationship Status, Client Standing, Account State |
| CLIENT_TIER | A classification system that segments clients based on factors like account value, trading activity, or relationship depth. Higher tiers typically receive enhanced services and benefits. | Customer | Platinum, Gold, Silver, Bronze, Premium | Service Level, Client Segment, Relationship Tier, Customer Level, Priority Status |
| DAYS_SINCE_INTERACTION | The number of days that have passed since the client last had any form of contact or interaction with the brokerage firm. This includes phone calls, emails, website logins, or any other touchpoint. Negative values may indicate future scheduled interactions or data processing anomalies. | Customer | 15, 45, 120, 250, 365 | Days Since Last Contact, Time Since Engagement, Last Touch Days, Contact Recency, Interaction Gap |
| DAYS_SINCE_TRADE | The number of days elapsed since the client's most recent trading activity or transaction execution. This metric helps identify active versus dormant trading accounts and is crucial for understanding client engagement patterns and potential churn risk. | Sales | 7, 30, 90, 180, 400 | Days Since Last Trade, Trading Recency, Last Transaction Days, Trade Inactivity Period, Time Since Last Order |
| ENGAGEMENT_SCORE | A calculated metric that quantifies the client's overall level of engagement with the brokerage across various touchpoints like trading, communications, and service usage. Higher scores indicate more active clients. | Customer | 85, 72, 94, 61, 78 | Client Engagement Rating, Activity Score, Involvement Index, Participation Score, Interaction Rating |
| GENDER | The gender identity of the client as provided during account opening. This demographic information may be used for diversity reporting and understanding client base composition. | Customer | Male, Female, Non-binary, Prefer not to say, Other | Sex, Gender Identity, Demographic Gender, Client Gender, Personal Gender |
| LASTINTERACTIONDATE | The most recent date when the client had any form of contact or engagement with the brokerage, including trades, calls, emails, or online activity. This indicates client engagement recency. | Operations | 2023-12-15, 2023-11-28, 2023-10-30, 2023-12-05, 2023-09-20 | Last Contact Date, Most Recent Activity, Last Engagement, Final Interaction, Latest Touch Point |
| LOCATION | The geographic location or region where the client resides or is based. This may be used for regulatory compliance, tax purposes, or regional analysis of the client base. | Customer | New York, California, Texas, Florida, Illinois | Region, State, Geography, Residence, Address |
| NAME | The full legal name of the client as registered with the brokerage firm. This is typically the name that appears on official documents and account statements. | Customer | John Smith, Sarah Johnson, Michael Brown, Lisa Davis, Robert Wilson | Client Name, Account Holder Name, Customer Name, Full Name, Legal Name |
| NET_FLOW_LASTYEAR | The net dollar amount of money flow into or out of the client's account over the past 12 months, calculated as total deposits minus total withdrawals. Positive values indicate net money coming in, while negative values show net outflows from the account. | Finance | 10000, -5500, 32000, -8200, 15750 | Annual Net Flow, Yearly Net Movement, Net Cash Flow, 12-Month Net Activity, Annual Net Funding |
| PERF_FIVEYEARRETURN | The annualized percentage return of the client's portfolio over the past five years. This long-term performance metric helps evaluate the sustained success of investment strategies and provides context for assessing portfolio management effectiveness over market cycles. | Finance | 7.8, 3.2, 11.4, -1.5, 9.6 | Five Year Return, 5Y Annualized Return, Long-term Performance, Five Year CAGR, 5-Year Track Record |
| PERF_ONEYEARRETURN | The total percentage return on the client's portfolio over the past 12 months, calculated from the current date backward. This metric provides insight into the portfolio's recent performance and helps assess investment strategy effectiveness over a full year cycle. | Finance | 12.3, -5.8, 22.1, 4.6, -15.2 | One Year Return, 12-Month Return, Annual Return, Trailing Year Performance, 1Y Return |
| PERF_YTDRETURN | The percentage return on the client's portfolio from the beginning of the current calendar year to the present date. This performance metric shows how well the portfolio has performed relative to its starting value at January 1st of the current year. | Finance | 8.5, -3.2, 15.7, 0.9, -12.4 | Year-to-Date Return, YTD Performance, Current Year Return, Annual Return to Date, YTD Gain/Loss |
| PORTFOLIO_HEALTH | An assessment of the overall condition and performance of the client's investment portfolio, considering factors like diversification, risk alignment, and performance relative to benchmarks. | Finance | Excellent, Good, Fair, Poor, Needs Attention | Portfolio Score, Investment Health, Portfolio Rating, Portfolio Quality, Investment Status |
| RISKTOLERANCE | A classification that indicates the client's willingness and ability to accept investment losses in pursuit of potential gains. This guides investment recommendations and portfolio construction. | Finance | Conservative, Moderate, Aggressive, Very Conservative, Growth | Risk Profile, Investment Appetite, Risk Level, Investment Style, Risk Preference |
| TENURE_YEARS | The number of complete years that the client has maintained an active relationship with the brokerage firm, calculated from the account opening date to the current date. | Customer | 3, 7, 12, 2, 5 | Years of Service, Relationship Duration, Account Age, Client Longevity, Membership Years |
| TOTALPORTFOLIOVALUE | The current market value of all securities and cash holdings in a client's investment portfolio. This represents the total worth of their account at a specific point in time, including stocks, bonds, mutual funds, ETFs, and cash positions. It serves as a key indicator of client wealth and account size for segmentation and service delivery purposes. | Finance | $125,750.50, $845,320.75, $1,250,480.25, $67,890.00, $2,150,675.80 | Portfolio Market Value, Total Account Value, Portfolio Worth, Account Balance, Total Holdings Value |
| TOTAL_BUY_AMOUNT | The total dollar value of all securities purchased by a client through buy transactions within a specified period. This represents the aggregate amount spent on acquiring stocks, bonds, ETFs, and other investment instruments. It helps measure client investment activity and purchasing power in the market. | Finance | $15,750.00, $48,920.50, $7,300.25, $125,680.75, $89,450.00 | Total Purchase Amount, Total Buy Value, Aggregate Purchase Volume, Total Investment Purchases, Total Acquisition Amount |
| TOTAL_SELL_AMOUNT | The total dollar value of all securities sold by a client through sell transactions within a specified period. This represents the aggregate amount received from liquidating stocks, bonds, ETFs, and other investment instruments. It indicates client divestment activity and capital realization patterns. | Finance | $22,450.80, $65,300.00, $12,750.45, $98,620.25, $156,780.90 | Total Sale Amount, Total Sell Value, Aggregate Sale Volume, Total Liquidation Amount, Total Divestment Value |
| TOTAL_TRANSACTIONS | The cumulative number of all transactions executed in the client's account since account opening. This comprehensive count includes all buy orders, sell orders, and other trading activities, providing a complete picture of the client's historical trading behavior. | Sales | 156, 342, 89, 578, 23 | Lifetime Trades, Total Trade Count, Cumulative Transactions, All-Time Trading Activity, Historical Transaction Count |
| TOTAL_TX_AMOUNT | The combined total dollar value of all transactions (both buy and sell) executed by a client within a specified period. This comprehensive metric represents the overall trading volume and activity level, providing a complete picture of client engagement with their investment portfolio regardless of transaction direction. | Finance | $134,750.25, $89,420.80, $245,680.50, $67,320.15, $178,950.75 | Total Transaction Value, Aggregate Transaction Amount, Total Trading Volume, Combined Transaction Value, Total Deal Amount |
| UNIQUE_SYMBOLS_TRADED | The count of distinct securities, stocks, funds, or other financial instruments that the client has traded throughout their relationship with the brokerage. This metric indicates portfolio diversification and the breadth of the client's investment interests. | Sales | 25, 48, 12, 67, 8 | Distinct Securities, Different Instruments Traded, Unique Holdings, Security Diversity, Investment Breadth |