Calculate Customer Insights by Using Data Cloud (Managed Package)
Use a calculated insight to define and calculate multidimensional metrics on your entire digital state in Data Cloud. You can create metrics at the profile, segment, and population levels.
Required Editions
Financial Services Cloud is available in Lightning Experience. Available in: Professional, Enterprise, and Unlimited Editions |
This is a Financial Services Cloud managed package feature.
List of Financial Services Cloud calculated insights for Financial Services Cloud Managed Package.
Use these Financial Services Cloud calculated insights to learn more about your clients and identify trends.
| Name | Description |
|---|---|
| Deposits for 3 Months | Total/average deposits for the past 3 months, starting from the last day of the previous month. |
| Deposits for 6 Months | Total/average deposits for the past 6 months, starting from the last day of the previous month. |
| Deposits for 1 year | Total/average deposits for the past 1 year, starting from the last day of the previous month. |
| Expenses for 3 Months | Total/average expenses for the past 3 months, starting from the last day of the previous month. |
| Expenses for 6 Months | Total/average expenses for the past 6 months, starting from the last day of the previous month. |
| Expenses for 1 Year | Total/average expenses for the past 1 year, starting from the last day of the previous month. |
| Average Monthly Expenditure Cover | Number of months that expenses can be paid from available balances. |
| Credit Card Use Ratio | Ratio of credit used to credit available across all cards. |
| Financial Account Balance Net Worth | Sum of financial account balances including both managed and held away, less the total outstanding credit. |
| Financial Account Balance Wallet Share | Ratio of Managed Financial Account Balance to Held Away Financial Account Balance. |
| Goal Status | The status of the user’s financial goal. |
| Goals 1 Month From Target | All active financial goals that are targeted to be completed in one month. |
| Gross Written Prem Policy Renewal Rate | Insurance policy renewal rate that has a renewal date within the past six months. Rate is based on gross written premium. |
| Gross Written Premium New Business | The total value of gross written premium insurance policies with an effective date within the past 30 days. |
| Held Away Financial Account Balance | Sum of all financial account balances of type General, Investment, Savings, and Checking that are held away. |
| Ins Policy Renewal <30 days: Consumer | Insurance policies for the customer that are up for renewal in the next 30 days. |
| Ins Policy Renewal <30 days: Producer | Insurance policies for the producer that are up for renewal in the next 30 days. |
| Insurance Policies Earned Commissions | The total value of commissions for all insurance policies with an effective date within the past six months. |
| Low Feasibility Goals 6 Mo from Target | All active financial goals that are within six months of their target dates and have reached less than 70% feasibility of reaching their targets. |
| Low Feasibility Plans | All active financial plans that have reached less than 70% feasibility of reaching their goals. |
| Large Deposit | Deposit that is 2 standard deviations larger than an average deposit. |
| Large Expense | Expense that is 2 standard deviations larger than an average expense. |
| Managed Financial Account Balance | Sum of all Financial Account balances of type General, Investment, Savings, and Checking under management. |
| Monthly Deposits by Category Last Year | The sum of all monthly outgoing transactions sorted by transaction category for each month in the last year. |
| Monthly Expenses by Category | Sum of all debit transactions broken down by category for the calendar month. |
| Monthly Inflow Transactions | The sum of all monthly inflow transactions. |
| Monthly Deposits by Category | The sum of all monthly inflow transactions sorted by merchant category code. |
| Percentage of Assets to Liabilities | Total assets divided by total liabilities. |
| Percentage of Cash Inflow Spent | The total monthly cash inflow divided by the total cash outflow. |
| Total Allocation Drift | Portfolio allocations that have drifted from the target allocations. |
| Total Annual Expenses | The sum of all outgoing transactions year to date. |
| Total Monthly Deposits | The sum of all monthly deposits. |
| Total Monthly Expenses | The sum of all monthly outgoing transactions. |
| Total Number of Accounts | Number of financial accounts held by the customer. |
| Total Outstanding Credit | Total of all credit and lending product balances. |
| Total Expenses by Month Last 12 Months | The total of each financial account’s outgoing transactions by month for the last 12 months. |
| Total Deposits by Month Last 12 Months | The total of all financial accounts inflow transactions by month for the last 12 months. |
- View Calculated Insight Data in Data Cloud (Managed Package)
In Data Explorer, view the data from your data lake objects (DLOs), data models objects (DMOs), and calculated insight objects (CIOs). Customize your view by editing the columns and use filters to show only the most relevant data for the selected object.
See Also
Did this article solve your issue?
Let us know so we can improve!
