Namespaces | Fields | Unpopulated

Namespaces | Fields | Unpopulated

Table of Contents

About This Report

The Namespaces | Fields | Unpopulated report provides visibility into empty fields across all profiled namespaces, helping to identify unused or missing data within the system. By analyzing these unpopulated fields, users can assess data completeness and pinpoint areas where information may be missing or inconsistently recorded.

Create a copy of this report and customize it as a starting point for profiling field reporting.

mainreport1.png

The Namespaces | Fields | Unpopulated report helps organizations with identifying unpopulated fields which is crucial for ensuring data completeness and integrity as missing data can lead to inaccurate reporting, flawed analytics, and inefficiencies in system workflows. By addressing these gaps, organizations can improve data reliability, enhance decision-making, and optimize overall system performance.

Customizing This Report

The Namespaces | Fields | Unpopulated report uses a set of specific filters to refine and target the profiling results displayed. These filters are critical in isolating the most relevant data fields across different Salesforce objects such as Account, Case, and Lead. For example, you can change the Profiling Field Results records based on their Created Date field.

Editing Filter Criteria

You can change the filters by clicking the Filter icon in the report. The opened menu shows which filters are locked that come with each report. You can change these unlocked filters according to your needs and can also add additional filters by clicking the Edit button.

filters2.png

Here’s an overview of the filters applied to this report by default:

  • Show Me: Displays all profiling field results, ensuring a comprehensive analysis across all profiled fields.

  • Created Date (Fields): Set to "All Time," meaning fields from any time period are included in the report.

  • Is Latest Summary: Set to "True," ensuring that only the most recent profiling summary is included for accuracy.

  • Record Type: Set to "Profiling Field," limiting the report to data fields that have been specifically profiled.

  • Profiling Definition Category: Set to "Baseline," focusing on standard profiling scenarios rather than custom or ad-hoc profiles.

  • Profiling Definition Record Type: Set to "CRM," restricting the analysis to fields within Salesforce CRM objects.

  • Is System Field: Set to "False," excluding system fields to focus only on custom or user-created fields.

  • Field Has Namespace: Set to "True," ensuring that only fields with an assigned namespace are included in the report.

  • Is Field Empty (Primary): Set to "True," displaying only fields that have no populated data, helping to identify gaps in data completeness.

Adding Fields to the Report

This section guides how to customize the Namespaces | Fields | Unpopulated report by editing and adding fields, enhancing the report’s relevance and detail for specific organizational requirements.

  1. Open the Namespaces | Fields | Unpopulated report in your Salesforce environment and click the Edit button.

edit2.png
  1. Select Fields on the left to open the list of all fields available on the object.

    fields.png

  2. Use the Search all fields… option at the top of the Select Fields on the left to open the list of all fields available on the object panel to find specific fields you want to include in the report.

  3. Double-click fields to add them to the list of columns appearing in the report, and drag and drop fields within the Columns list to change their order. You can also drag and drop fields from the list of fields to the Columns list.

addfields2.png

Once you have finished editing and adding fields:

  1. Click the Save button to preserve your changes.

  2. To update the report contents based on any changes you made, click Run. This will generate the report based on the current set of filters and fields you’ve configured.

This approach allows users to tailor the Namespaces | Fields | Unpopulated report to meet specific data assessment needs, ensuring that the report serves as an effective tool for data management and governance within Salesforce.