Skip navigation

In the Spring '13 release, Eloqua upgraded its SQL Server Integration Services (SSIS) to the latest version, which gives clients greater speed and stability on uploads. This new version does not allow for source files that are formatted incorrectly , where syncs that were previously running correctly are no longer successful, causing issues for many clients.

If you receive an error similar to the following, you need to fix the source file:

The column delimiter for column "<column name>" was not found

This error generally means that there is an extraneous column present for example, there is no value in the header row, but there is a value within one of the subsequent rows.


Column A

Column B


Text A

Text B

Text C



If this is a one time upload, please open it in a spreadsheet program and validate that there is no data past  the last column that has a header. If there is, remove it and resave the file. If there is not, delete ALL the columns past the last one, and resave the file. Then, try the upload again.

As a temporary measure, clients with recurring uploads that are formatted in this way have had the functionality rolled back to the earlier version to allow for correction of the source file. Over the next several months, we will be communicating with clients a timeframe of when they have been will be moved to the new system, to allow for changes to be made at the source.

The code attached in the file performs a lookup based on a data card. Follow the steps below to get this to work:

1) Navigate to the Web Data Lookup area in the Eloqua Application and create a new data lookup. Ensure that the data lookup is of "Data Cards" Type. Also, ensure that the field selected for the data card field match is the data card unique field -- in this demo, the email address was used. 4-23-2013 2-00-51 PM.png



2) click save to create the data lookup. After that, click on data lookup options on the top right corner and choose "Get data lookup scripts"

3) Download the attached file and open it in an html editor -- do NOT right click and choose view source in a web browser window as this has shown to create issues.

4) Replace the code in section1 and section 2 in the file with the equivalent code that you got generated when you clicked on the option "Get data lookup scripts" . Note that nothing else needs to be replaced - keep everything in the file as is.

5) Ensure that you replace 'xxxx' with your siteid. The site-id can be found by looking at the integration details of any form -- in E9, or by viewing the html details of the form under the gear icon - in E10.

6) Your data lookup is ready to be tested.

Attached is a file that contains the code necessary to implement strict-mode tracking with an opt-in banner on a non-Eloqua landing page. Follow the steps below to get the code attached to work -- the banner to display on the page:

1) Ensure that strict-mode tracking is enabled for your Eloqua install -- create a case with support for that

2) Once Strict-mode tracking has been enabled, go to visitor tracking>visitor tracking package and find the Restricted Country list menu in the center window. Click on it and add any countries for which you want the banner to appear. Note that if you choose NO countries and implement strict mode, NO visitors will be tracked. You must select at least one country to restrict which would ensure that ONLY visitors from that country would not be tracked unless they opt-in.

4-23-2013 1-29-53 PM.png



3) download the attached file. Open the html file file in any html editor. do NOT right-click and view source in the browser to copy the code from the file as this has been shown to create issues -- spaces being copied affect javascript.

4) once you have the file opened in an html editor, copy the source and place it in the page where you want to implement strict-mode tracking. Ensure that you replace 'xxxx' with your siteid. The site-id can be found by looking at the integration details of any form -- in E9, or by viewing the html details of the form under the gear icon - in E10.
5) Voila! the web-page should display the banner below


4-23-2013 1-25-37 PM.png


Content Embed - Beta App

Posted by fsakr Apr 22, 2013

Hi All,

At this time, Eloqua has decided not to push the Content Embed functionality into production. We will no longer be making it available for new clients. For similar functionality, please see GetSmart content (Get Smart Content Personalization) on the Eloqua AppCloud.



We're happy to announce that we're releasing a Beta version of the Content Embed widget to this week. The app lets marketers insert content from any Eloqua Landing Page on their own web pages. This is a limited Beta release, so please note that some features may change between now and the final release.


The application is easy to setup and use, here's an early look :



Setup the application by defining the source and size for your Content



Define which Landing Page to display, based on Contact, Company and Visitor data :


Test and Embed

Finally, you can use see the script below on any of your pages to display Eloqua Content


We're looking for a few early adopters to join our Beta program and we'll provide more details once the application is live.

Please touch base if you need more information or are interested in joining the Beta program.




PurposePrevents bots from submitting Forms (fewer junk submissions).


BenefitIt will be seamless to the User Experience (submitters will not have to fill out any extra fields).


CaveatThis only prevents bots that fill out every field in a Form.



1)  Include a text field in your Form (hide it using css instead of through the native form property - use "display:none").

2)  Name the field something normally seen in forms that is not required for your current form (example:  "Address 3").

3)  Form Bots fill out every field they see in the code (if "Address 3" is submitted with a value then you know it's a bot).

4)  Add conditions to each Processing Step in your Eloqua Form:

-- If the field is filled in, disregard the submission.  If the field is blank, continue with the Processing Step flow.


-- if the field is filled in, disregard the submission.  If the field is blank, redirect to a second Eloqua Form where you run your standard Processing Steps.


Additional Tweak:  To prevent Human submitters from clicking submit repeatedly, insert javascript that disables the Submit Button after clicking it.


Other Options:

1)  Dynamic Human Proof (ex. Captcha)

-  Difficult to set up

-  Very accurately prevents bots

-  Prevents actual form submitters from clicking submit multiple times to cause multiple submissions

-  User Experience is affected

2)  Static Human Proof (ex. Chocolate Factory)

-  Simple to set up

-  Accurately prevents bots

-  Prevents actual form submitters from clicking submit multiple times to cause multiple submissions

-  User Experience is affected

There have been some useful enhancements made to the Form Population Cloud App recently, and I just wanted to bring them to everyone's attention.


For those not familiar with this app, it is a Cloud Component that can be added to an E10 landing page, along with your form, and will allow you to pre-populate the form with data from Eloqua.


You can configure the app to fill in your form fields with Eloqua contact data, visitor profile data, static values, query strings, and now...values from DataCards and Email Group subscription status.


When a known contact or tracked visitor lands on your page, the app will pull the chosen data from Eloqua, and pre-populate your fields with the data according to your mappings.  The component has been enhanced to also support multi-select lists, check-boxes.


If you haven't already, give the app a try, it may save you some headaches!!

Hi folks,


I wonder if the preset function actually works. From Segments, I choose "Upload Contacts", select my preset (one I saved from a recent process), and "Click the cloud to upload a file". The next screen shows a preview of my data, and the following the mapping. The mapping looks all good, i.e. every field from my upload file matches Eloqua fields. When I finish the process, my Data Import always stays empty. The contact upload notification also indicates there was nothing imported:


15-04-2013 13-08-26.jpg


If I use the exact same upload file without a preset and map the fields manually the imports works fine. Am I doing something wrong?




Join me drive systems excellence for the Dell Software Group. The role is focused within Sales & Marketing systems (SFDC, Eloqua, OBIEE) however such experience is not a must.

You will need to be incredibly organized, highly motivated, willing to accept change and understand that you will be solving problems for which no manual exists. Fun!

Ping me if you would like to talk.

Ask your contacts to unsubscribe.

Why would you ever send an email to a contact prompting them to unsubscribe? Maybe to increase engagement? To show more accurate results? To increase sender score? To improve your database quality?


Yes to all!


Those contacts in your database that are not engaging and not unsubscribing are hurting your campaigns a lot more than you probably realize. Your analytics are skewed, the inactive contacts are not engaging, and this is making your open rates and clicks perhaps lower than the truth. Having these inactive contacts in the segments you build for campaigns is also misleading; your down-the-funnel calculations will be incorrect if the top of the funnel is incorrect.


So how do you effectively engage inactive contacts while suppressing the truly inactive ones? Following these four steps, either annually or semi-annually, will minimize your inactive contacts.


1. Determine your definition of “inactive contact” by taking into account your buying cycle, and buying process, and average conversion time. For example, if your average buying process is 3 months, then contacts with no activity for 5 months could be considered inactive. Think about including extra time in your dentition, not all contacts are ready to buy at the time of their first engagement. It also may take some testing to decide the correct duration of inactivity.


2. Build the segment of your inactive contacts in Eloqua. Using the definitions and criteria determine in the above step, use the necessary filters to build the segment. These contacts will receive a series of email to re-engage or unsubscribe.


3. Build the campaign in Eloqua and send the new segment through it. This campaign may be as small as two emails, maybe even one, or you can view it as a bigger “we want you back” campaign. The goal of this email or campaign is to acknowledge these contacts and prompt them to re-engage or unsubscribe. You can use this campaign to ask for feedback to improve your campaigns, which can highlight the cause of their inactivity. If possible, a subscription center would be best because it allows the contact to choose what they want to receive and perhaps increase engagement.


4. Follow up to their actions. If after several email attempts a contact is still inactive, it is best to remove them from your reachable contacts and either suppress the contacts or set aside for a later re-engage campaign. It important to segment the inactive contacts out of future campaigns. Hopefully the contacts unsubscribed themselves if they truly are not interested in your emails, or took the time to give honest feedback about your campaigns. Either way you have cleaned up your database!


This process ensures good data management. While it may lead to what appears to be less contacts in your database, at least the remaining people will be active contacts. Active contacts mean happier contacts and fewer spam complaints, which helps maintain a high sender score!


What are methods you use to clean up your database? All tips and tricks welcome!

For many marketing departments, we are using a single form to collect a variety of submissions - usually various content downloads. You are probably already utilizing the 'Send Submitter an Email' processing step, which allows you to send an email (thank you, confirm your subscription, download your content, etc.) to the submitter. But what about AFTER that email? Are you continuing to nurture these contacts, sending them follow-up pieces of information or offers? You may already know of (or even use) the 'Add to Campaign' processing step, but did you know that you can use a field on your form (product, perhaps, or maybe even the name of the content they downloaded?) to determine what campaign to send contacts to?


Here are some great ways in which you could use this functionality:

  1. Product-specific welcome campaigns based off the product associated to the content they downloaded
  2. Regionalized event invite campaigns based off the state they are in
  3. Similar content nurture campaigns based off the type of content they downloaded
  4. Feedback campaign soliciting feedback on the content they downloaded
  5. Graduated content campaign, offering more intense/detailed content as time goes on based on what they first downloaded


Wondering exactly how to make the magic happen in the system? Well, here are three different ways you could distribute your contacts to a campaign dynamically:


1. Through a hidden field on your form.

  • Add a new hidden field on your form called 'CampaignID'
  • Find the campaign IDs of the campaigns you will be sending contacts to
    • Open the campaign canvas, double click on a Landing Page that is currently on your canvas
    • In the Landing Page details, you will see 'Use the following URL when linking to this page:'
    • The Campaign ID of the campaign is included at the very end (elqCampaignID=XXX)
    • If you don't have a Landing Page already added to your canvas, simply add one and you will see the Campaign ID added in the details section
  • Populate the field the same way you populate your 'Document Downloaded' field, where the value is dynamic based on what campaign you want the contact to go to using the Campaign ID you took from campaign canvas
  • On your form, add a processing step for 'Add to Campaign' and set the destination campaign to 'Determined by a form field' and then choose your 'CampaignID' form field you created
  • This will now tell Eloqua dynamically, based on the value written in the hidden CampaignID field what campaign to add the contact to


2. Through a lookup table in your form processing step.

  • This options does not require you to add a new field, you can use your 'Document Downloaded' field.
  • You will need to grab the Campaign IDs from your campaign canvases, just as in the previous solution.
  • Add a processing step to your form for 'Add to Campaign' and set the destination campaign to 'Determined by a picklist'.
  • Your form field is going to be the 'Document Downloaded' field, and you are going to create a new lookup table (you can do this on the fly by clicking the browse icon and then clicking the plus icon to create a new picklist.
  • In the new picklist you create, your Display Name is going to be the values from your 'Document Downloaded' field, and your Actual Value is going to be the Campaign ID you grabbed from campaign canvas.
  • This is telling Eloqua that for the value 'Document A' in the 'Document Downloaded' field, for example, send the contact to Campaign A (based on a campaign ID of 123, for example).


3. Conditionally through multiple processing steps.

  • With this solution, again you don't need to add a new field you can use your 'Document Downloaded' field. You also don't need to find the Campaign IDs of your campaigns.
  • Add a processing step to your form for 'Add to Campaign' and set the destination campaign to 'Always the same' and choose one of the campaigns you want to add contacts to
  • Under 'This Processing Step Executes' to Conditionally and set the condition to a Form Field (choose your 'Document Downloaded' field) and set the criteria to exactly 'Document A' (for example).
  • This will tell Eloqua whenever the value in 'Document Downloaded' equals Document A, add to the campaign you chose.
  • This isn't the best solution if you have a lot of documents or a lot of campaigns as it's time consuming to set up and can be a lot to manage. If there are just a few, it's quick and easy and simpler than adding a new hidden field.


Hopefully one of the three above solutions will work for your organization, and allow you to further capitalize on the content someone downloaded and tailor future campaigns to their interests. Let me know your thoughts on which solution worked for you and what creative ways you are utilizing this trick!



Are webinars already a core component of your 2013 marketing strategy? Not only do your events need to stand out from the mass of others out there (see related blog post: 8 ways to make your webinars more compelling), it is also critical to do so cost effectively with measurable results of Marketing Qualified Leads.


There are some important steps while preparing and following up that can increase your effectiveness and ROI down the line. Here are four worth keeping in mind at all times.


Desired Outcomes

First, ask yourself, “What is the end goal of this webinar?” Is it to generate leads, to use in your nurture campaign, or to establish thought leadership and credibility?  All have their uses and purposes, but the reason will determine your audience, layout and metrics to measure success.


Target Audience and Promotion

Now you can determine the ideal audience, and what they know about your company. Get creative on your invitation; don’t stick to the overdone simple letter format. It is important for the invitation to address the audience correctly, and share information they don’t know without providing info they many already know.

If the webinar is targeted for your in-house list, an intimate, personalized invitation will work great and fits the relationship. Whereas, if inviting new contacts from a purchased list, or first contact, an informative and well branded layout will be more appealing and provide more insight into your brand.

Email invitations aren’t the only way to promote your webinar. Post details to your social networks, such as Twitter and LinkedIn. Even asking any co-workers or co-presenters to spread the word to their network is a great way to reach new contacts. Some Webinar service providers (such as BrightTalk) may also have marketing channels you can use, such as newsletters, banner ads, etc.


Extended Webinar Lifecycle

Don’t forget how to up-cycle your webinar after the live version is completed. Record your webinar to be used in other campaigns, such as nurture campaigns, or assets to gate throughout your site!

It is also important to offer the recorded version to all who registered for your webinar but were unable to attend; they could still be very interested in viewing the webinar. Another great way to repurpose your webinar is to use the manuscript to create whitepapers, best practice guides, fact sheets or infographics. Get creative!

Follow Up

Lastly, determine the appropriate follow up steps, not only to take with those who attended, but those who did not attend as well. If you have a lead scoring program in place, determine the appropriate change in score based on attendance. Based on your desired outcome from above decide the best follow up.

If your webinar was an intimate, product specific event for hot leads, it makes sense for sales to follow up with calls. If the webinar was to establish credibility, the attendees should be sent into a nurture campaign to further qualify the leads.


These are just a few ways to increase your webinar effectiveness. What other ideas and tips do you use for effective webinar execution?

Successful marketing automation initiatives map workflows that support a buyer through their journey. The so-called Buyer’s Journey is a process in itself that begins with research and awareness and moves all the way through the point of purchase, and post-sale with ongoing relationship marketing. Marketing automation enables small and large processes. These processes can include any of the following such as segmentation, lead scoring, nurturing, content delivery, and alignment with sales. Ultimately they ALL roll-up to supporting the Buyer’s Journey.


Build a lead management process in Eloqua in a phased approach that evolves into more sophisticated utilization as knowledge and skills grow. 


You can't build a process without agreement on the definitions!



Here are nine great questions to ask and answer when designing a process:


1. Where do leads come from?

2. What contact information should be collected and how?

3. How do we segment and triage leads?

4. What is a ‘qualified’ lead?

5. Who do we send marketing qualified leads to for follow up?

6. What content should we send to leads, when, and how often?

7. How will our marketing automation platform integrate with our CRM system?

8. If leads are disqualified, how will they be managed?

9. What are the KPIs we need to measure to determine effectiveness and efficiency?



Once you ask these questions your team may ask even more questions on building the lead management process that supports your business. And the more questions answered before going into production, the better the odds for succeeding with a marketing automation initiative.

Market smarter not harder.


If you are not seeing the amount of conversions you hoped for from your paid search ads, don’t increase your budget – instead improve your landing pages. Improving the landing page alignment with the ads will increase conversions without spending a penny more.


Asking these four questions will help you better align your ads to your landing pages to drive more conversions.


1. Is the offer on the search ad what is found on the landing page?

When arriving on the landing page is the promise from the ad on the landing page? Tricking users to believe they will get one thing and then the offer is something else results in high abandonment. The reader should not be surprised or confused when arriving on the landing page; it should be what is expected after clicking on the ad.


2. Is the Call to Action (CTA) clear and concise?

Can the user find the CTA button? The eye should be drawn to the CTA. Multiple buttons with the same CTA can be effective. Position one above the fold of the page and one after all the text. The reader can choose to read as much, or as little as they want.


3. Is the offer compelling and relevant to the target audience?

This one seems pretty simple. But if there are no conversions, look at your audience and re-evaluate if the offer is something compelling to them.


4. Is the offer worth giving their information?

How much and what information are you asking for? Asking for their driver license number for a Fact Sheet maybe too much to ask. But if it is high value educational content you are getting robbed if you only ask for name and email. The higher the value of the offer, generally the more information you can ask for. Think of it like going to a grocery store. If in your opinion, the item isn’t worth the price, you will most likely look for a cheaper option, perhaps from a competitor.


There are endless ways to tweak landing pages and paid search ads. Asking these 4 questions are a good method to follow with your campaigns.


What are your go to methods to improve conversions?

I recently posted a poll on Topliners asking “What new features would you like to see in Eloqua webinar apps?” What was the response? A whopping 64% of respondents said that an "Add to Calendar" (ICS) file with unique join meeting link for confirmation & reminder emails was their top priority. Why is this feature important? Simply put, this seemingly small change can deliver higher webinar attendance rates.


I have some good news for those who responded to the poll (and others who are looking to advance their Eloqua webinar programs): the ReadyTalk integration with Eloqua now provides ICS files with unique join meeting URLs and this functionality is delivering measurable results. In fact, one ReadyTalk customer (Compendium) saw their webinar attendance rate double with the addition of this feature.


Here are some brief instructions to help you get started …


Step 1: Install the ReadyTalk App from AppCloud

To get started, install the ReadyTalk Cloud Connectors from the AppCloud. You can learn more about getting started with the ReadyTalk App in this post or get the ReadyTalk App here.

Step 2: Add the ReadyTalk Cloud Connector to Your Campaign

In your Eloqua Webinar Campaign, add the ReadyTalk Register Attendee Cloud Connector as a step between the Registration Form and the Confirmation Email steps in your campaign:


Step 3: Create New Fields

On the Data Card you use for your webinar programs (or on the Contact Record), add two new fields to store the unique ICS files returned from ReadyTalk for each registrant:

  1. Outlook Calendar Link
  2. Google Calendar Link

In our instance of Eloqua, we have named these fields “Event ICS File (Outlook)” and “Gmail Add to Calendar Link” but you can use your own naming convention.



Step 4: Map ICS File Links to the New Fields

In the Optional Output tab of the ReadyTalk Register Attendee Cloud Connector, click on “New Output Mapping” to map the appropriate ReadyTalk Output Fields to the new fields you created on the Data Card or Contact Record:

  • Map “Event ICS File URL” to the “Outlook Calendar Link” field on the Data Card or Contact Record
  • Map “Event Google Calendar URL” to the “Google Calendar Link” field on the Data Card or Contact Record

This will ensure that the unique Add to Calendar links created for each registrant are captured in Eloqua.



Step 5: Add the Unique Calendar Links to Your Eloqua Emails

Create an “Add to Calendar” section on your Eloqua confirmation and reminder emails and include two new links/buttons:

  1. One to allow registrants to add the webinar to their Outlook calendar
  2. One to allow registrants to add the webinar to their Google calendar

Then, use Eloqua Field Merge functionality to automatically populate the emails with the unique Outlook and Google calendar links stored on the Data Card or Contact Record. Each registrant will then be able to add the webinar to their Outlook or Google calendar and have all of the information they need to join the meeting (including their unique “join meeting” URL) at their fingertips.




Hope this feature helps you drive higher attendance rates for your next webinar! If it does, please share your success story

Filter Blog

By date: By tag: