How to generate a Contact Field Completeness by Contact Group Report?

Oracle Cloud’s 22D release brings new functionalities, features, and security enhancements with a good amount of analytics updates including.
Three new standard Insight reports:

1) Database Growth Trend – Monitor and measure your database health with trends in growth rates for total and reachable contacts. Benefit from pre-built graphs and visual indicators to visualize your data effectively.

2) Auto Activity Analysis – Gain insights into monthly contact activities such as email opens and clicks, including those auto-generated by campaigns. Understand the impact of privacy protection*-enabled mail applications and scanning tools.

*If you would like to find out more about how Mail Privacy Protection impacts your existing Insight reports and dashboards, reach out to us.

3) Contact Field Analysis – Focus on field completeness with detailed breakdowns of field population, helping you ensure no data is missing. We would like to focus on this feature a little bit more later on.

Additionally, the update includes:

4) Dashboard Home Option added to navigation menu – Easily return to the Dashboard home page with a new navigation menu option.

5) Eloqua Help Center Link Added to Common Reports – takes users directly to documentation specific to each report.

You can find more about 22D update here.

Data Completeness – are there gaps in your data?

This term – data completeness, refers to the comprehensiveness or wholeness of the data.
Missing information can severely impact your ability to connect with customers and damage your brand's reputation. Low field completeness rates indicate gaps that need addressing to maintain data quality. If you are experiencing any challenges with your data quality, let us know and we can help you develop a strategy to prevent insufficient data from flowing into your system.

Oracle's new Contact Field Analysis report, found under Shared Folders > Contacts, offers a detailed catalog of field completion, including:

• Total Values
• % Populated
• Missing Values
• % Missing Values

There is also a graph included which is a 100% stacked bar chart, that can help visualize the relationship between how many fields are populated vs those that are missing values in your database.

‍
Alternative Solution for Custom Field Reporting - Field completeness chart

Note: This report currently does not support custom fields. However, Oracle will continue to expand on this report and custom field reporting.  

 Fortunately, this problem can be resolved using the solution described below.

To get a report that provides Contact Field completeness (including custom fields):

1. Navigate to Audience > Tools > Shared Lists.
2. In the right-upper corner you will find a>> button. Single-click on it and select Contact Field Completeness Report and then, select New Contact Field Completeness Report.

3.     Eloqua will ask you to provide the following Report Parameters:

• Report parameters
• Contact Group – this is the name of your Shared Lists. Please select a single Shared List name and click OK.
• Contact Group Search view
• Contact View – a set of contact fields that can be customized. Visit Eloqua Help Center to find out more about creating contact views.

4.     Finally, click View Report at the bottom-right of the UI.

This will give you the report for completeness of contact fields for Shared List members.
You can click “View” on the top-left to see other methods of display(including: bar chart column chart, table, line chart, pie chart).

‍

‍

And export report results directly to your desktop.

‍

‍

On top of that you can click on each individual field name to view field population details.

‍

‍

Also – you can click on each contact field value to see contact details.

You will need:

• new Contact Segment
• new Shared List
• new Contact Program Canvas

Where to start?‍

• Create a Contact Segment with all contacts in your database by using following filter criteria

• Create a Shared List for all contacts.
• Create a Contact Program Canvas that will regularly add Segment Members to a Shared List on a set schedule.

Since you already have a Contact Shared List that includes all contacts in your database, you can now generate a Contact Field Completeness report by making sure to select your newly created Shared List.  Need help with data management, system audit, custom reporting or any other marketing automation processes? Contact us and we’ll sort it out for you!