How to generate a Contact Field Completeness by Contact Group Report?
Incomplete data = inaccurate data. Did you know that data completeness is one of the most common challenges for marketers? With Oracle Eloqua's new 22D release, identifying missing data has never been easier. Let's dive into the latest features and explore how you can maintain data integrity effortlessly. However, there are some limitations
within this new functionality, which we want you to be aware of, but no worries, we have an alternative solution for you.
Before we dive into the main topic, let’s find out what are the other features in the Analytics area of Eloqua that have been rolled out recently – from Nov 18, 2022 the release has been made available on all PODs (POD 1 & 2 on Nov 4, POD 3, 4 & 6 on Nov 18, 2022).
22D release highlights – What’s new?
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.
Leveraging the Contact Field Analysis Report
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.
Share It!
Keep on
