Topliners Theme
1 3 4 5 6 7 Previous Next

Do It

487 posts

When adding custom fields to a form, there can be some confusion regarding what values are saved when a form is submitted. The custom field that often inspires the most debate is arguably the single checkbox. Here's an inside peak into what IS saved, and what isn't.


If someone selects or 'checks' a single checkbox, the value that is saved to Eloqua is "on". This can be found by navigating to the submitted form and then clicking on the action gear drop-down and selecting View Submission Data:


Single Checkbox selected.JPG.jpg arrow.JPG.jpg   on.JPG.jpg


If someone does NOT select a single checkbox, or leaves the checkbox 'unchecked', there is no value saved to Eloqua:

Single Checkbox.JPG.jpg        arrow.JPG.jpg   blank.JPG.jpg


So, if you are making a processing step conditional, based on someone selecting or not selecting a checkbox, you'd configure it as "on" for any conditions dependent on it being checked...


processing on.JPG.jpg

and you have TWO options for configuring a condition dependent on a single checkbox NOT being checked:


1. not exactly "on":




2. exactly "blank" (the text field is left empty):

processing blank.JPG.jpg

I keep a gmail account that I use for testing client emails. I'm not sure how, but this account has been running on the newer Gmail platform (with Gmail tabs) ever since I opened it, even while my personal gmail does not. When I logged into this account this morning, I saw some interesting news.


The first was this survey question. Of course we can only speculate at this point, but it looks like they may start sorting emails somewhat differently depending on the way you're using the account.

Screen Shot 2013-12-19 at 9.43.52 AM.png

Secondly, and I take this as great news!, Gmail is now auto showing images. This was always one of my biggest gripes, especially as an email marketer. For B2B senders, this isn't usually as big of a deal, as most emails are more text heavy than content heavy, but for B2C senders, whose emails are primarily comprised of images, this is awesome!


Screen Shot 2013-12-19 at 9.44.17 AM.png

Anyone have any other speculations?

It has been a while since I wrote a post to Topliners (and truthfully, my Topliners points are craving my return to the top 100!) so I pondered about a topic that is very important but may not get all the credit it deserves. Your subscription management strategy should be just as important as your creative lead generation campaigns, but many companies still have limited to no options on how contacts are communicated to and their ability to determine their preferences. Hopefully this post has you review your current subscription strategy and opens the door for a review or optimization of your existing process.


This immediately got me thinking - what are some great resources, examples that I have shared with clients to help them along this path! I can not take all the credit as there have been folks before me that have talked in length about this so I figured I would share some of these awesome resources. To end, I will share my secret sauce to subscription management success.


I start with my colleague, crowds2crowds from who boldly demonstrated in a great blog two great examples of Email Subscription Centers that allow the end user to determine how they want to be communicated with. His examples though very different still provide a good resource to get your company thinking!


I found this blog post from HAVAS DISCOVERY which immediately connected with me as the purpose of a subscription center is to allow the contact to "Opt-Down and no Globally Opt-Out" by providing options that clearly speak to your companies areas of interest and determine communication frequency levels.


When thinking subscription management here are my top 5  items to consider:


  1. How easy is it for someone to determine how often they would like to be communicated to?
  2. How user friendly is your subscription center?
  3. Are you giving your contacts several things to unsubscribe from or are they only given a global opt out? (there is no magic number here, you just need to find the 'sweet spot' between cumbersome and clunky and non-existent)
  4. Is there an opportunity for the contact to update their existing profile?
  5. Are you currently marketing to countries in Europe? If yes, is your subscription management compliant with European laws?


I'd love to hear your feedback and thoughts on what your organizations are doing. If you have pages you'd like to share, myself and I trust the community would appreciate it!


Thanks -


Jason Pemberton

Director, Key Accounts


Yes we all know that progressive profiling is pretty cool and we all want to implement it.

Couple if months back I jumped into this adventure too. Here is some background of we I wanted to it.



Our Trial download form had 15 fields, 3 of them helped lead routing in SFDC (Country, State and No. of employees )

Others were profile or contact info product of interest etc... Once the forms is submitted the user were sent a trial key and a URL to download the .exe file.


Once the user download the trial and start the installation process we asked for Name, Email and product key. In-case if anything was different a duplicate record was created and this lead to lot of issues.



Many system for involved, like Website form passed to Elqoua and a Key Gen service. The info passed to SFDC.



1.Simplified form with 4 fields with product of interest selected from whichever page the form gets accessed form.

2. Created a web services that links the email to the Key Generated.

3. When the user put the key in the installer we did a web service call and pulled the email back. which meant we did not ask for email, name, company etc...

4. Made Country, State and No. of employees pick list so room for error.

5. Lastly created a survey at end of trial finish profiling.



No more duplicates.

Clean data, higher form completion.

Increase in Trial activation result to Higher close rate.


If need more detail please contact me.

That’s right, folks. Nearly three years after receiving Royal Assent and going through a seemingly endless set of delays, comment periods, and guidance changes it appears that Canada’s Anti Spam Legislation (CASL) is finally coming into force. Canada’s Minister of Industry James Moore announced today that CASL will come into force on July 1 2014. Eloqua’s Dennis Dayman posted about the announcement here.


We wrote about CASL at length here but as a quick reference, these are a few of the main points of the law:


  • CASL requires express consent. This means NO pre-checked boxes.


  • CASL is not just an email law.
    • It covers installation of computer programs without the end user’s consent
    • It covers any Commercial Electronic Message (CEM). A CEM is defined as any electronic message that encourages participation in a commercial activity. A CEM could for example be:
      • Email
      • SMS
      • Instant message
      • Some social media messages


  • It covers any CEM sent TO or FROM Canada. The CRTC will work with international regulatory bodies such as the FTC to ensure compliance by parties based outside of Canada’s borders.


  • Prescribed information is to be included in every CEM as well as any request for consent. Requests for consent are also covered by the law, which means that they cannot be sent without first obtaining express consent.


  • Existing contacts cannot be ‘grandfathered’ in most cases and will therefore require marketers to gain affirmative consent from their Canadian contacts before the law comes into force. Addresses who have already opted in under PIPEDA may however be permitted.


  • Fines are steep, up to 10 million dollars per violation and private rights of action are permitted.


What’s next?


Businesses will need to scrub their lists and remove any covered address for which there is no affirmative opt-in to receive email and other CEM. It is expected that many email lists will be significantly reduced in size as a result. Privacy Policies and form collection on websites should be updated to ensure proper consent. In the case of forms, this includes moving from an opt-out (pre-checked) to an opt-in (not pre-checked) methodology.


Eloqua recommends that businesses meet with their legal, compliance, and marketing teams to determine the full scope of changes to their business practices in order to comply with the new law as there are a number of key considerations and requirements not provided in this article which may apply. We also encourage affected parties to read the full text of the law, which can be found at

Often you may encounter a situation where a salesperson needs to change the email address on a contact record in your CRM.  Since Eloqua uses email address as the unique identifier, the auto-synch will run and try to find a match using the new email address. However, since this change has only been made in the CRM, it will not find a match in Eloqua and therefore create a new record instead of modifying the existing contact.  Ideally you will want to configure your integration to update existing contacts in cases such as this in order to avoid sending duplicate communications a two addresses owned by the same contact, or sending emails to an inactive address.


There are two ways to change the email address on an existing contact:


  1. Perform and upload with the purpose of “Change Email Address”.  This will allow you to upload a file containing a list of old email addresses and new email address, and Eloqua will make the updates.  Jordo’s Playbook outlines a solution using this method for CRM systems track contact field history (such as Salesforce)
  2. Perform a contact upload using a field other than email address as the unique identifier for the purpose of the upload.  This is the method we will be using in this solution.


In order to automate email address changes using a unique identifier other than email address, we need to find a field that exists and is unique for all contacts in Eloqua; for this purpose we will be using the Eloqua Contact ID field.  This is a system generated ID which is assigned to an Eloqua contact upon creation.

We also need to ensure that this same unique identifier is available on any leads or contacts in your CRM system.  This is easy for leads created by Eloqua (just map Eloqua Contact ID in your Create Lead external call), but can be a bit trickier for leads created directly in your CRM.  We can account for both kinds of records using the following process:


Standard Integrations

  1. Create a field in your CRM system called “Eloqua Contact ID”
  2. Update your Create Lead, Update Lead and Create Contact External Calls so the Eloqua “Eloqua Contact ID” field is mapped to the corresponding field in the CRM.  This will ensure that all leads originating from Eloqua will have an Eloqua Contact ID.  To handle contacts and leads who originate from the CRM, we will need to make changes to our auotsynchs.
  3. Create a new Get Leads autosynch and a new Get Contacts Autosynch (Jordo's Playbook contains step by step instructions for creating autosynchs), and add a filter to the syncs so that they only retrieve leads/contacts who have an Eloqua Contact ID in the CRM.  Both of these synchs should use Eloqua Contact ID as their unique key.  This will ensure when any lead or contact in your CRM who has an Eloqua contact ID changes their email address, Eloqua will update their existing Eloqua contact record instead of creating a new record.
  4. Create a new Integration rule collection called Update Eloqua Contact IDs.  This collection should contain 2 rules:
    - If a contact has a CRM Contact ID, run the Update Contact external call- If a contact has a CRM Lead ID, run the Update Lead external call
  5. Create a second Get Leads autosynch and a new Get Contacts autosynch (Call them Get Leads (Email) and Get Contacts (Email) to keep things straight).  Add a filter to these syncs so that they only retrieve leads/contacts that do not have an Eloqua Contact ID in the CRM. Both of these synchs should use Email Address as the unique identifier
  6. Modify the Upload action on the Get Leads (Email) and Get Contacts (Email) autosynchs, and configure it to run the Update Eloqua Contact IDs integration rule collection.  This will ensure that any time a record without an Eloqua contact ID is brought over from your CRM, Eloqua will immediately update the CRM record with the Eloqua contact ID.  This means that a contact will never come through the email autosynchs more than once.

to recap, in total you should have 4 autosynchs:


Get Leads (Eloqua Contact ID) – Will run on all leads with an Eloqua contact ID.  Matches Eloqua contacts using Eloqua Contact ID as the unique identifier

Get Contacts (Eloqua Contact ID) – Will run on all leads with an Eloqua contact ID.  Matches Eloqua contacts using Eloqua Contact ID as the unique identifier

Get Leads (Email) – Will run on all leads without an Eloqua contact ID.  Matches Eloqua contacts using Email address as the unique identifier, and executes the Update Eloqua Contact IDs integration rule collection to write Eloqua Contact IDs to your CRM

Get Contacts (Email) – Will run on all leads without an Eloqua contact ID.  Matches Eloqua contacts using Email Address as the unique identifier, and executes the Update Eloqua Contact IDs integration rule collection to write Eloqua Contact IDs to your CRM

Custom Integrations


For custom integrations using the Data Export and Import area of the application, the steps are a little different since Data Imports do not have upload actions which can be used write contact IDs back to your CRM.  If you have a data import/export based integration, your solution will look like  this:

  1. In Eloqua, create a new checkbox contact field called “Sync Contact ID”
  2. On your CRM side, create two files for import into Eloqua, one should contain all contacts to be synced over from your CRM which have an Eloqua Contact ID, and one should contain all contacts to be imported that do not have an Eloqua Contact ID
  3. Set up an import to pull in the contacts that already have Eloqua contact IDs, this should use Eloqua Contact ID as the key field.
  4. Set up an import to pull in the contacts that do not have Eloqua contact IDs.  This import should use Email address as the unique key.  Every record in this import should also write a value of TRUE to the “Sync Contact ID” field
  5. Create a new segment called “Contact IDs to be synced”.  This segment should contain one filter which looks for any contacts that have a value of TRUE in the “Sync Contact ID” field.  Share this filter and save the segment
  6. Create a new export to push contact IDs to your CRM system.  This export push all of the members of the “Contact IDs to be synced” segment to your CRM and should be scheduled to run 1 hour after your imports.
  7. Create a new program in program builder with three steps:
    i. Wait two hoursii. Run Update Rule – Set “Contact IDs to be Synced” to FALSEiii. Remove from program
  8. Set up a feeder on this program to feed the members of your “Contact IDs to be Synced” filter to the program after your imports run.  This program will ensure that contacts are removed from the “Contact IDs to be Synced” segment after they are pushed to the CRM system



To recap, in the custom integration solution you will have:


Two imports

  • One to bring in records with an Eloqua Contact ID using Eloqua Contact ID as the key field
  • One to bring in records without an Eloqua Contact ID using Email Address as the key field, and writing a value of TRUE to the “Sync Contact ID” field

One Export

  • This Export will push all contacts with a value of TRUE in the “Sync Contact ID” field to your CRM

One Program

  • This program will clear the “Sync Contact ID” flag after contacts’ IDs have been exported.

Sharing problem.

Posted by masoud.banbersta Nov 25, 2013

I can't share content with my network. Whenever I try to share the following message appears.

Your content could not be saved due to an error. You may have been logged out. If this problem persists please contact your system administrator. Click here to refresh this page.

I refresh the page and make sure that I´m Logged in and still receive the same message. Who knows what the problem is? Thank you in advance!

In using the campaign object we ran into a challenge. The standard fields for a campaign are simply sent and responded. We wanted to expand the options for some campaigns to other statuses as well. For example email with landing page we wanted (sent, email opened, form fill). We wanted to standardize this so that the fields are the same every time a marketer chose it. This is not possible directly in SFDC.


Fullcircle CRM has an appexchange program that is very reasonable that allows you to do just that. You can setup standard or custom member status values by campaign type and then they are always standardized. Not sure if anyone else has tried to solve this one, but wanted to share.


The Easy Campaign Member Status Manager from Full Circle CRM enables you to define standard or custom member status values by campaign type. Set up your default values, and never have to worry about them again!


Easy Campaign Member Status - Full Circle CRM - AppExchange


Predictive Lead Scoring

Posted by jmugo Nov 21, 2013



Are any of you using predictive lead scoring? I have dived into this area recently and learning how it works. Of particular interest are the following companies providing this service:

  • Infer
  • Mintigo
  • Lattice Engines


What has been your experience with any of these vendors or with predictive Lead scoring in general?

Here's one for people who want to add a page anchor without uploading a custom HTML template. Although it seems simple, it was certainly a lightbulb moment for me!


1.     Open the landing page editor

2.     Drag a text box onto the page

3.     Right-click on the the text box and select 'Edit Source'


4.     Add the following code into the editor and click save (This creates a HTML id, which here is called 'guide'. You can call it what you like)


5.     Place the text box on the landing page in the place you'd like to anchor. In this example I want to anchor the orange section.


6.     Now you can create the hyperlink to your new anchor. We'll keep it simple and create a text hyperlink (you can create an image link by adding the image to a text box and editing the code in the same way).


7.    If you want your hyperlink to be on the same page, add a new text box, right click and select 'Edit Source'


8.     Add the following code, making sure that the HTML id (in this case #guide) matches the one you named in step 4


9.     Place the hyperlink text box wherever you want (probably at the top of the page) and save the landing page


10.     If you want the link to be placed somewhere other than the landing page, you'd create the hyperlink as usual, but include the HTML id at the end of the url. For example: '


Hopefully, clicking on your links should take you straight to your page anchor!


Thanks, James

For anyone working within a single instance of Eloqua in which Contact Level Security (CLS) has been built, gauging the relative health of your departments or lines of business' databases can be a challenge. The dashboard reports in Insights are generally set up to look at the database of your entire instance, so while your entire database may be considered "healthy" compared to industry standards, certain areas may be under-performing. One way to recreate the database health dashboard is to segment and filter your contacts based on their CLS identifier field, in my case BELONGS_TO =, and apply the same logic that goes in to the reachable, active, inactive definitions and field completeness criteria.


Here is an example of what a database health segment might look like:

DB Health Segments.jpg

Total Database includes just one filter criteria. In my case, Compare Contact Fields Conpare contacts that have field BELONGS_TO and contain {BUSINESS CODE}


Reachable contacts are those contacts who have opted-in and are not hard bounces*


Unreachable contacts are those contacts who are either unsubscribed or hard bounces*


*This is a good example of where AND versus OR matters as well as grouping the criteria (as indicated by the parentheses).


For my team, active contacts are defined as anyone who has taken any action in response to an email with the last 12 months. You can change this to as little as 1 day. Here you want to make sure you are grouping and changing from AND to OR.


Inactive contacts are those which haven't taken any action within the last 12 months. Here you want to use AND because a contact must meet all three criteria to be considered inactive.


Finally, field completeness filters are fairly straightforward.

First Name_Completeness.jpg

To track this growth over time I created a simple spread sheet to record the changes to this segment every week. I know, a manual process...eek! However, I've opened an Idea in the Support Portal so with any luck an update to the dashboard that allows for contact level security filtering may be coming in the next release!



Ever wondered how to submit your great idea for a Feature Request to our Product Team?


Head on over to Eloqua’s support portal by clicking on the question mark in the upper right hand corner of your screen. Once you're there, click on the Ideas tab (with the lightbulb icon) and check out all of the other feature requests that have already been made by other users.


You can add your idea, or vote up an idea that's already been added. You can also track to see which ideas are being reviewed and which ones are scheduled for upcoming releases.


(Big thanks to melissakowalchuk for the awesome screenshots!)



Not sure if this is the right forum to post this, but thanks to Eloqua Support tech (Jagmit Bhatthal), I was able to learn how to customize MailTo email recipients, subject line, and body text in HTML codes. Here is the link to the step by step guide:How to customize MailTo for Multiple Recipients, Subject and Body in HTML codes


How to customize MailTo for Multiple Recipients, Subject and Body in HTML codes with samples

You can use MailTo in your HTML documents to support customized automatic emails from your web site.

By using the MailTo in your href links in HTML files, you can manage multiple recipients in a semicolons seperated format. You can also set a default subject field text for the email. Also it is possible to set the Copy To or the CC field values by typing the recipients for the CC field value. This capability is also valid for the Blind Copy To or the BCC field recipients.

The MailTo syntax also enables the HTML developer to set a default BODY text for the email object that is prepared using MailTo.

You can find a list of sample MailTo HTML codes to summarize the use of MailTo syntax with samples.

For more information on about the syntax of 'mailto' URLs. RFC2368 defines the format of Uniform Resource Locators (URL) for designating electronic mail addresses

First sample uses the below code:

<a href=""></a>

And seen on the HTML web page as below:

When the internet user who click on the above link will have the Outlook or the Email Client program that is set as default email program opened for a new message as shown below with only the To... field value is defined with one recipient.

mailto sample


Second sample illustrates a simple mailing but this time to multiple recipients in a semicolons seperated format in the HTML code. Some Client Email programs may also support comma delimited email address lists for declaring multiple recipients. But Microsoft Office Outlook does not recognize the comma seperated syntax for multiple emails.;

mailto sample with multiple recipients

You might have seen that some of the emails have been declared with in a new tag "To" in the hyperlink tag A. But this method is not supported with most of the email programs. And is not a good practise to place such a html code in your web pages.

If you also want to declare the Copy To or the CC field recipients, then use the below syntax for your codes. It is just like adding a new query string parameter named "CC" to a URL;

mailto sample with CC recipient

We can alter the above syntax in a similar way for Blind Copy To or the BCC field. This time our new query string parameter will be "BCC". The sample for the BCC can be build as follows:;

mailto with bcc recipient

After dealing with the recipient declarations for our new mail message in the HTML codes, we can further customize the new mail object with defining the subject of the email as follows: To Syntax with Samples


As you will guess BODY of the email can be customized in the HTML code by passing a new parameter named BODY in the query string of the email object with in the hyperlink href definition. Below is a  sample for a customized email with its body is defined in the html code. To Syntax with Samples&body=Hi, in this article you will find samples about how to use MailTo in HTML

mailto with body field

If you want to customize the body with a little bit more for instance if you want to add new line characters in your email you can add "%0D%0A" string within your body text. You can place "%0D%0A" where you want to see the line breaks or the end of line in your message string. Also if you want you can replace the blank character or " " empty space character with "%20" and form your text values with "%20" instead of space characters. This way the space characters in the message texts are URL encoded with "%20". To Syntax with Samples&body=Hi,%0AIn this article you will find samples about how to use MailTo in HTML

mailto with multiline body field

I hope the sample are helpful to summarize the use of the mailto in your html codes to design a URL for processing emails.



Ada Liaw-Martinez

As of the Fall '13 release, E10 users now have the ability to pull a visual click-through report.


Before you try to pull this report, you need to opt-in to the beta release. Call support and have them enable this feature.


After it is enabled, you can find this report right on the email asset itself. Travel to the settings and it will be the last option. See screenshot below.


Screen Shot 2013-10-29 at 2.26.19 PM.png

There is a great step-by-step post for finding the Shared List Asset ID using Program Builder. However, while teaching at EE13 todd.sprinkel opened my eyes to an easier way to locate the IDs for Shared Lists.


Asset IDs can be handy. Here are just two scenarios where you might crave the Asset ID.

  1. Talking to support about a particular asset. It isn't always easy on a phone call to relay a long asset name (since you are all using superb naming conventions I do know asset names can be extended).
  2. Also Asset IDs are needed in E10 if you want to use the processing step configuration to trigger based on picklist. For example, you want to add form submitters to the correct Shared List based on their lead source. You can capture lead source on the form and then use a picklist to match their lead source to the Shared List you wish to add them to. However, you need the Asset ID to do this.

Locating Shared List Asset ID:

  1. Navigate to a Shared List (Contacts > Shared Library > Shared Lists)
  2. Open the Shared List
  3. Go to the Action Gear drop down in the upper left
  4. Click on Run Deduplication  or Run Update Rule
  5. shared list menu.png
  6. Look at that pop-up window url (You will see something like:
  7. The ID is the number that comes after ContactInfoID… so In the example above … 57
  8. You can close the pop-up as soon as you have looked at the url.


Side note: Campaigns, landing pages and emails all have the campaign ID in the URL at the top of the editor screen. Super easy. You just navigate to that asset inside of Eloqua and check out the url in the address bar when you arrive.

Locating other Asset IDs (such as Campaign)

  1. You navigate to a campaign canvas
  2. The url appears in the address bar as
  3. Therefore, this Campaign Canvas ID is 239

Filter Blog

By date:
By tag: