Skip navigation

We are going to populate the region contact field based on the values we have in the country field. This would be good after we have standardized values in both, but we notice having a considerable group of contacts who have a value in the country field but none in the region field (this will be your audience to bring in the program builder).


We are going to use a program builder. See the below design.

We have 3 decision rules checking country value from a filter, and after them an update rule setting the region for each category. (This could be done in one run too, with some conditional update rules and an country to region update table. )


The filter inside the decision rule is like:

As you see, it checks the country field against a picklist of values.

This means that for each region, you would have to set up eloqua picklists with the corresponding country values. Make them in excel and upload.


The update rules ran in the program are like:

The scenario is that we want to cleanse and standardize the values of a contact field.

In order for this cleanse to be effective, it would be good if in the future the field cannot be filled in by contacts as text input, but selectable from a dropdown, on order to not bring back non standard values. Our production scenario is that we had contact fields as text input and switched to values to be selected from dropdowns. In this case, we wanted to cleanse all values present in the database.


Navigate to Contacts/Data tools. In the upped left Data Tools menu button select new update rule. Add name and then add individual update rules. See below.

In the above case, we want to standardize Estimated Budget field values to the above limits. As you can see below, we set up a series of threshold values and implemented.

We can also use more flexible rules, like using "*" to cleanse values that are starting or ending in a known string. See below.


In this case we are changing the value in the Job Seniority field, for example, to Consultant for all those who have values that are like  "Consultant,.......". The * keeps place for whatever else would be the continuation of that value.


Now in order to do the actual cleansing, create a program builder to run the update rule against the desired audience.

In the first step add the contacts with either a filter or feeder. The second step is running the update rule set. The last step is an exit.


Note: for the field you want to cleanse, you could make an eloqua picklist with the standard values, let's say the new 6 standard values for the estimated budget field. Then create a compare contact fields filter, asking for the contacts having Estimated Budget field values NOT in that picklist nor blanks. And that's your audience to cleanse.

The scenario is that in your links you custom add query strings past "?". We add a different query string per links, which gets submitted to a hidden form and then a datacard.

In order to create a report in Insight so you have visibility over this, you can use the below attributes and metrics

The attributes are campaign and clickthrough query string value and the metrics are total clockthroughs and unique clickthroughs.

running the report will provide something like below:

Make sure to have emails and pages added to the campaign canvas for reporting purposes.

The problem was that when running a "Campaign By Segment By Region" (and other reports using Region contact field) custom report, in the region rows we had several rows of the value "0", though our regions are EMEA, AMS, APJ. Of course, 0 would correspond to those contacts who don't have a value in the Region field, but problem was that for one segment, we were seeing several rows of 0 instead of just one.


The report itself, in the original version, using the contact field Region is this.

See below a run

As you see above, instead of having one row for all contacts not having a region, we have several.


What you can to is create a Custom Group, as below. Besides the standard regions, I have added a rule that would "catch" all other cases.


Remove the Region contact field from the report. Add the Region Custom Group to the report (simply search its name in All Objects and drag it as an usual attribute).

Now when we run the report we will obtain a single row for all contacts that don't have a region, row called "Null". See below. This is applicable to other fields too, depending of your report breakdown.

The context is when you tag your campaign with the query string tracking feature of Eloqua.

You also send an individual query string parameter in the link, per link.

When running reports in Insight on this tagging,the available parameter to obtain numbers by is "query string parameter value count", per "query string parameter value".

This metric, the value count, is not an "unique" metric. If the same contact clicks several times, it will register every time.


In order to obtain an unique count add Eloqua Contact ID to your report and insert a new metric based on in, that is COUNT(eloqua contact id).

It will provide the unique count for that query string parameter value.

The working scenario is the following:

- we have a direct mail campaign where we want to make a short link

- we want to associate the short link address with the salesperson that the recipient will be seeing contact info for:

- we want to make one single page for all recipients to get to;


We can achieve this by sending all contacts to a redirect page. The page will redirect based on a # reference in the link.

Fist off, get the PURL NAMES for all your sales people. They are available at the contacts section of eloqua, view all fields, purl name.

Create a landing page with the info you want the receiver to see. You can have contact field merges on the page in order to display contact info dynamically.

Let's say this page is ""


Create a routing page named "". We will use this page to redirect people to the "sale" page.

You can use similar routing to the one below:


<script type="text/javascript">

             var redirectURL = '';

             var hash = window.location.hash.substring(1);


            // hashtag : PURL name

            var purlNames = {





            for (var key in purlNames) {

                if (key == hash) {

                    redirectURL = redirectURL + purlNames[key];







What will happen here is that in the direct mail campaign you will send them addresses like

- "" to all the people who you want to see Codrin as their sales rep;

- "" to all the people who you want to see Jim as their sales rep;

- and so on for as many sales reps you have;

Once the page loads, for example having Codrin as sales rep, the page will redirect to "" where CodrinTeiuLRFZ00 is a PURL thus the page will display Codrin's contact info if you made contact field merges and added them on the page.

Teiu Codrin

Dynamic links using PURL's

Posted by Teiu Codrin Oct 14, 2015

The working scenarios is the following:

- let's say you have 5 salespersons (this works for a small number of salespeople);

- you plan to send a few thousand email and the recipients are all split between the 5 salespeople;

- basically, there are groups of contacts that should be seeing contact information of their salesperson on a page (like contacts from List1 see as a contact person salesperson Nick, whilr contacts from List2 see Jim)

- you want to do a single landing page for all contacts;

- you added to your eloqua database all needed info to be displayed for the salesperson;


1. For starters, what everybody knows and is the easiest thing to do is to put on the landing page field merges made on the contact field . Straightforward, make the fields you need, drag the fields to the page, like Fname, Lname, Title, Company, Phone (what you would need to display the contact info of the salesperson).

The page will be like

<span class="eloquaemail">PURL_First_Name_Sales1</span>


2. Go to the contacts section of eloqua, search each of your salesperson, and write down their PURL Name. Click to see all fields, copy the name. It will be like FnameLnameA1B2C3.

Create an excel file with 2 columns. Left one is email address, right is destination link. Add in it all destinataries and the destination page+purl.  For e.g, paste all addresses from list 1, and since you want all those people to see salesperson's Nick contact info, for all of them, in the column on the right place the link "", where "FnameLnameA1B2C3" is Nick's PURL Name.


NOTE: you could make the second column be just the PURL Name if you want to send all of them to the same page. If you add a full link as I suggested you could make recipient not only arrive to different PURL destination on the same page, but to also different destination links.


3. Create a new datacard with unique key email address having 2 fields.

One is email address, the other is Destintion link. Upload in it the excel made at point 2. Remember to tick the "map" contacts in the last dialogue window.


4. Create a new field merge on the destination link field in the datacard from point three. Add the span of this field merge as a link in the email you send to you recipient. What will do is to change the link based on the mapping you established in the dacard and link will be the one with the PURL corresponding to the person they want to see.


<a href="<span class="eloquaemail" >Purl_PurlLink1</span>" style="color: #333333 ;">LINK</a>.

When using PURL's the first step is to send the PURL from the email to the page.

For that you would have to go to the component library and create a new field merge. Merge from the contact field called "PURL Name".


In order to be able to use this field merge you would need the <span> for it. To get the span go to a blank HTML email, click field merge on the left menu, select yours, and drag it in the code.


Now, after you have your email content done, simply add the span past the destination address. Remove the quotes from the span class.

Eg. <a href="http://testdomain/testingpage/<span class=eloquaemail>PURLName1</span">buton</a>


This link will direct to the page http://testdomain/testingpage/FnameLnameA1B2C3

As you may know, all contacts existing in eloqua are created a PURL Name, of the format FnameLnameA1B2C3.

The bold over there, "FnameLnameA1B2C3" is the PURL and not an extra page. It is the same as the contact would arrive to that page with an ELQ ID.


Most common use to get to a page having a PURL would be to populate that page with ADC's or contact field merges (like company, address, phone, etc.) of the contacts that the PURL belongs to.

Updates and enhancements are great, but it's even better to KNOW about them! To stay up-to-date with Oracle Content Marketing releases, make sure to bookmark the Oracle Content Marketing Release Center page.


Step 1: Join the Oracle Content Marketing Insiders group.

Step 2: Once you are a member, click Release Center in the upper left (in the Key Resources section).

Step 3: Bookmark it!


If you're already a member of the Oracle Content Marketing Insiders group, here's a direct path to the Release Center.

Filter Blog

By date: By tag: