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 the new 22D release, Eloqua comes with an additional report that can help you identify missing data in a simple way. 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:

  • Database Growth Trend – which will help you better understand and measure your database health and growth by showing trends in growth rate for total contacts and reachable contacts. It also comes with some pre-built graphs and visual indicators
  • Auto Activity Analysis – which provides a monthly breakdown of contact activities such as email opens and clicks, including auto-generated ones, by campaign. This particular analysis will provide you with insights on the impact of *privacy protection-enabled mail applications and scanning tools. *If you would like to find out more about how does Mail Privacy Protection impact your existing Insight reports and dashboards, reach out to us.
  • Contact Field Analysis – which we would like to focus on a little bit more, individually. 

And also:

  • Dashboard Home Option added to navigation menu – ‘Dashboard Home’ is now available as a navigation option within the Change Dashboard drop down menu.  Users can now easily navigate back to the Dashboard home page. 
  • Eloqua Help Center Link Added to Common Reports – which will take 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. There should be no missing information for data as it can actually cause a lot of damage to your brand. With the incorrect information, you can miss opportunities to connect with customers. If your field completeness rates are low or you are experiencing any other challenges with your data quality let us know and we can help you develop a strategy to prevent incomplete data from flowing into your system.

The new Oracle Insight out-of-the-box Contact Field Analysis report that can be found under Shared Folders > Contacts in the report catalog will give you a breakdown of field completion. In this analysis you can check field population details including the following calculated measures:

  • Total Values 
  • % Populated 
  • Missing Values 
  • % Missing Values
Contact Field Analysis report view

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. 

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), navigate to Audience > Tools > Shared Lists. On the right-upper corner you will find a >> button. Single-click on it and select Contact Field Completeness Report.

Contact Field Completeness Report
New Contact Field Completeness Report

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 – this is a set of contact fields that can be customized. Visit Eloqua Help Center to find out more about creating contact views: https://docs.oracle.com/en/cloud/saas/marketing/eloqua-user/Help/ContactViews/Tasks/CreatingContactViews.htm 

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

View Report button

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). 

Report for completeness of contact fields for Shared List members

And export report results directly to your desktop. 

Export To Excel

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

Field Population Details

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


Ok, but how can I add all contacts in my database to a Shared List so I can run Field Completeness report on whole database?

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: 
Segment filtering criteria: Email address field having a value that contains "@"
  • 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 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!  

Author

  • Piotr Sito

    I'm a Marketing Automation Specialist with a passion for digital marketing and technology. Outside of work, I love to stay active and enjoy cycling, reading books, making music, and exploring new genres. Also, I'm a big fan of the NBA.

View other posts in related categories:

 Eloqua  Marketing Automation  Marketing Operations  Tips & Tricks