Advanced Ways to Run Segmentation

Advanced Ways to Run Segmentation

Building segments in Oracle Eloqua is similar to stacking blocks to complete an architectural masterpiece. Leveraging multiple filters within a segment helps marketers hone in on the who associated to the target audience for their marketing campaigns. Segments are also a great way to pull data together for analysis. While segment building itself may seem straight forward (check out this great read for a breakdown) like most things within the Eloqua platform, there are varying levels of complexity. In this blog post, we’re going to cover a few advanced ways to run segmentation within Eloqua to hopefully help reduce the amount of time spent manipulating data outside of the Eloqua platform.

In terms of advanced ways to run segmentation in Eloqua, we’re focusing on three specific functions available within the segmentation area; merge, intersect and trim.


Definition – To combine or cause to combine to form a single entity.

True to the definition, the merge function does just that by allowing Eloqua users to combine two separate segment elements into one merged contact list. Eloqua will handle any de-duplication necessary, so the final result will be unique to the contact. Let’s look at an example:

In contact list “List A” we have three contacts, Joe Jones, Betty Smith and Lucy Who.

Advanced Segmentation - Contacts

In a separate filter looking for Eloqua contacts with a last name field matching ‘Smith’ we have two contacts, Betty Smith and Pete Smith.

Advanced Segmentation - Display Contacts

By selecting both lists (holding shift, selecting both lists and right clicking) we’ll be presented with a dropdown menu with an option to merge.

Advanced Segmentation - Merge Option

When we merge the two lists, we will be left with only unique values as shown below (Betty Smith is listed once, despite existing in both of our selected criteria). 

Advanced Segmentation - Merged List


Using the intersect function between two segment criteria filters will result in only showing the contacts that exist in both of our selected lists/filters. Let’s take a look:

“List A” contains the same values it did in our merge example- Joe Jones, Betty Smith and Lucy Who.

Advanced Segmentation - Contacts

Keeping our second filter criteria the same in this example, we will be looking for any Eloqua contact with the last name field value equal to ‘Smith’ and perform our selection + intersect action.

Advanced Segmentation - Intersect

This results in showing only contacts in “List A” that match our last name Smith filter criteria (in this case only Betty Smith matches both).

Advanced Segmentation - Merged List Minus


The trim action creates a new merged list minus any contacts existing in both selections.

“List A”

Advanced Segmentation - Contacts

Last Name Smith filter

Advanced Segmentation - Display Contacts

Following the right click method and selecting Trim, we’ll be presented with a dialogue box to select the target to trim from.

Advanced Segmentation - Trim

In this example, if we select “List A” as a target, we’ll see two names in our trimmed list – Lucy Who and Joe Jones.

Advanced Segmentation - Trimmed List

If we select “Last Name Smith” as a target, we’ll see one name in our trimmed list – Peter Smith.

Advanced Segmentation - Trimmed List 2

These three methods can be used to help eliminate exporting segment data and having to manually manipulate it in a spreadsheet. There are plenty of other methods to run segmentation. Some methods involve list management through form processing steps and advanced filtering to drill down to prospect engagement levels, but diving into those would be too complex for this post. Maybe that’ll be an upcoming blog topic – stay tuned!

By | 2019-08-23T15:28:12+00:00 August 28th, 2019|Build, Eloqua, MarTech|0 Comments

About the Author:

At Relationship One, we empower organizations to modernize their marketing through strategy, technology and data. With a core staff of experienced marketing consultants, integration specialists, data analysts and development gurus, we have a well-respected track record for delivering solutions that meet our customers’ unique business needs.

Thank you for subscribing!
Subscribe to our Thought Leadership Today