Value Results: Profiled Fields
- brady.kirkland
- Nickolette De Clerck
- Abraham Lloyd
The Profiled Fields tab summarizes field utilization statistics for all profiled fields, including picklist, empty, and default value-influenced fields. Use it to inspect individual field profiling statistics and navigate to detailed field records.
APPLIES TO | CUNEIFORM FOR CRM CUNEIFORM FOR DATA CLOUD
Introducing the Profiled Fields Tab
The Profiled Fields tab displays the utilization details for all profiled fields captured for a given Profiling Summary. It centralizes all fields profiled and displays profiling statistics describing the populated and actual utilization of fields profiled in both the primary and secondary scenarios.
Please note that the secondary profiling scenario is only available to Cuneiform for CRM: Business Data Reliability subscribers. Field and Data Management customers are limited to only one Profiling Scenario.
Fields are available in lists based on their type: standard, custom, picklist, and formula.
Explore Field Utilization for Profiled Fields
View Profiling Details
The Profiling Summary table contains basic information about the profiling summary and value, including record counts, percentages, and net-populated records for both the primary and secondary scenarios.
Analyze the Utilization of Profiled Fields
The Profiled Fields tab, by default, displays the Field Utilization list view beneath the Profiling Summary. This list view displays field utilization insights for all profiled fields associated with a profiling summary. These insights can be used to understand:
How often profiled fields are being populated (vs. empty)
The number of unique values present in a field
If a field has a default value – and if so, how often the default value is populated
The actual (or net) population rate (accounting for the default value population rate)
Based on their net population rate, these insights can identify which fields may appear to be in use vs. being used. Use population rate and net population rate to contrast field utilization perspectives.
Population Rate
Describes the percentage of profiled records populated with a non-null value for a given field. This statistic includes the percentage of records populated with the field’s default value.
Ex. For 100 profiled records, a field with 50 records populated – and 49 of those records are populated with the field’s default value – would have a population rate of 50%.
Net-Population Rate
Describes the percentage of profiled records populated with a non-null value for a given field – excluding the percentage of records populated with the field’s default value.
Ex. For 100 profiled records, a field with 50 records populated – and 49 of those records are populated with the field’s default value – would have a population rate of 1%.
Identifying Hidden Unused Fields
Use the net population calculations to identify fields that may be populated – but the field’s default value influences their overall population. Fields with a high population rate and a high default population rate may not be in use.
The table below demonstrates two contrasting examples of how to measure field population. The first row demonstrates a field that is not in use but is well populated. The second row demonstrates a field that is in use but whose usage is in question. The third row demonstrates a field that is confidently in use.
Field | Distinct | Has Default Value? | Default Value | Net | Is Field In Use? |
|---|---|---|---|---|---|
100% | 1 | Yes | 100% | 0% | No |
100% | 50 | Yes | 75% | 25% | Maybe |
100% | 25 | No | 0% | 100% | Yes |
The following table describes the columns used to represent profiling statistics for Salesforce object fields profiled as part of the current summary.
Column Name | Column Description |
Field Result Key | Provides a link to the record detail page for a profiled field via the field’s label and API Name. |
Profiled Field Display Label | The profiled field’s user-facing label. |
Profiling Status Summary | Describes the profiling status and statistical profiling status for a given field (statistical status is in parenthesis). |
Data Type | Describes the data-type of the profiled field. |
Net Populated Records % (Primary/Secondary) | Indicates a field's true utilization by subtracting the percentage of default values used from the percentage of populated records. |
Populated Records (Primary/Secondary) | Describes the total number of profiled rows populated with a value. |
Populated Records % (Primary/Secondary) | Describes the percentage of profiled rows populated for a given field. |
Distinct Values (Primary/Secondary) | Describes the number of distinct values found for a given field among its profiled rows. |
Has Default Value | Describes if a field is configured to support a default value. |
Defaulted Records (Primary/Secondary) | The count of profiled rows populated with the default value. |
Use the Field Utilization for Profiled Fields list-view to Access Field-Level Details
You can select any profiled fields from this list to navigate to a Profiling Field Result Record Detail page, which provides more detailed information on that field (the field record detail page includes profiling statistics and configuration metadata).
Congratulations! You’ve successfully completed our Value Results: Profiled Fields walkthrough. Please continue exploring the other tab walkthroughs available for the Profiling Summary. You should also review our Cuneiform for CRM Custom Objects documentation to read granular descriptions of the fields that capture profiling insights.
Review the next Profiling Value Results Walkthrough section: Record Details.