Oracle Eloqua Segmentation: Merge, Intersect, Trim

Do you ever get tired of exporting data to Excel when segments don’t quite seem to get at the data you really want? Fortunately, there are 3 powerful features available with Oracle Eloqua segments that allow you to merge, intersect or trim two different filters or lists. For those of you familiar with SQL, this is very similar to using a JOIN.

Let’s assume that we have been provided 2 separate lists from recent events at your organization. We have already gone ahead and uploaded the lists to Eloqua and named them as Attended Event – A and Attended Event – B.

Below is what we currently have in our segment.

Using merge, intersect, and trim, we can easily pull in new insights with our Eloqua instance. Let’s take a look at each:

Merge

A contact list containing all of the contacts from 2 filters or shared lists.

We have now been asked to pull a few different results from the 2 events. The first request is to create a new contact list in Eloqua with all of the attendees for both events. To do this simply select both lists in the segment and right click. From the context window choose the option to “Merge”.

Eloqua will create a new Merged List as shown below.

Intersect

A contact list containing the contacts that were common in 2 filters or shared lists.

The next request was to see how many contacts attended both events. To do this you will again select both shared lists and then right-click and choose Intersect from the context window.

The result is a contact list that shows 5 records common in both shared lists.

Trim

Use this option to compare 2 filters or lists and trim/remove all the records from a chosen filter that don’t have any matches in the other filter.

The last request is to provide a list of contacts that attended Event – B, but did not attend Event – A. To do this you will again select both shared lists and then right-click and choose Trim from the context window.

For this option you will also need to choose which filter/list you are going to trim from. We will choose to trim from Event – B.

We already know that that there were 151 people that attended Event – B, and we learned from the intersect that 5 of those attended Event – A. The result for the trim is therefore 146, and we now have a list that we can use for an email follow up targeted for that specific group.

There are many different ways to utilize the merge, intersect, and trim features. We could have taken this example one step further and created an additional filter with people that have submitted a form or opened an email and then used an intersect to see how many of these people have recently engaged. Try and do a few tests on your own and you will quickly see how much time this will save you and prevent having to export lists into Excel for doing additional analysis.

Good luck!

Want More Eloqua?

You May Also Like…

Digital Transformation

Turn Strategy Into Action

Lead Management

Accelerate Leads to Revenue

Managed Services

Long-Term Support

Customer Experience

Wow Your Customers

Marketing ROI

Prove Your Power

Experts On Demand

Stop Troubleshooting

Inbound Marketing

Right Channel, Right Message

Account-Based Marketing

Accelerate ABM Success

Custom Training

Tailored Learning Solution

REVENUE
MARKETING
UNIVERSITY

Get the skills you need to drive more revenue with On Demand and live, virtual classrooms

Marketo Engage

Marketo Platinum Partner

Pardot

Accelerate Leads to Revenue

Microsoft Dynamics

Optimize Your Instance

Salesforce Marketing Cloud

Salesforce Certified Silver Partner

Salesforce CRM

12 Years of Integration Experience

Partners

Additional Technology Platforms

Oracle Eloqua

Oracle Platinum Partner

Adobe Marketing Cloud

Adobe Bronze Partner

Stop
Trouble-shooting

 

The help you need, when you need it with Experts On Demand

About TPG

Learn about TPG and meet the team.

Careers

Discover career openings with TPG.

Newsroom

Our latest thought leadership.

History

Explore our award-winning history.

Partners

Learn more about TPG’s Partners.

Ready to transform into a digital revenue machine?

 

Learn how TPG empowers digital revenue delivery through a blend of strategy, technology and execution.