Skip navigation

[If anyone knows a better way of doing this please let me know. I believe they might be changing the limit soon to around 200k but essentially this problem may still exist]

 

Summary

 

This approach will create a report that is over 65,000 contacts and you can then use row numbering to filter 65,000 records at a time so you are batching your exports within the limit. This will involve multiple exports but you can quickly batch the rows by updating the numbers. I will also add in a prompt as an additional section so users without an Analyzer license can then group the contacts into 65,000 batches without needing assistance from the analyzer user.

 

If you are doing a mass export of all contacts, you could just add the field "Eloqua Contact ID" instead. As this is for a campaign and the contacts IDs are more random I can't use "Eloqua Contact ID" as a filter

 

Background

 

We routinely get asked to export contact level data with lots of email addresses so we easily go over this 65,000 limit. When you hit export it will then just take the first 65,000 contacts only. I can't find a way of doing this to increase the limit but there is a way to make this a little easier by filtering by bands to cover 0-65,000, 65,001 - 130,000 etc. The Pivot view is supposed to support pagination but this is an alternative approach.

 

When you need to export large volumes of data from Oracle (OBIEE) / Insight to excel for example you are limited by the settings configured by Oracle. It appears if you own the non-Eloqua version you can change the middleware to export more but with the version that they use with Eloqua you don't have access to change this.

 

Method

 

You will need an Analyzer license to do this.

 

> Let's say we have a report that looks like this. There are multiple emails in a massive nurture. We have been asked to show all of the opens by contact so they can do a deeper analysis.

 

 

> Go to the "Results" tab and hit the add "New Calculated Measure" icon

 

 

> Click on the function icon

 

 

> Select the "RCOUNT" function which is for row counting

 

 

> Change the expression to 1. So it should be RCOUNT(1) and not RCOUNT(expr)

 

 

> You should then see a list of numbers for each row. You can sort to arrange more neatly if needed.

 

 

 

 

> Save it

> Return to the "Criteria" tab and create and filter on the RCOUNT column

 

 

> Add in your banding so it can operate between two values. This must be a maximum of 65,000 records because that is the maximum number that can be exported (at present Jun-18)

 

 

> You should end up with this.

 

 

> When you go to the "Results" tab you will now have the first 65,000 rows only

 

 

> If you want to export the next batch of contacts (65,001 - 130,000) you can then update the filter and run it again for the next batch.

 

 

Additional Section

 

> If you want to make this functionality available to other users that don't have an Analyzer license you can add it as a prompt.

 

 

> Select the green plus icon

 

 

> Then double click on the new prompt and update per below. Note I've added a custom label so the end user can see something else other than "RCOUNT" which might not make much sense for them. The description will only show as you hover over the prompt.

 

 

> The users should then see a prompt box like this when they are running the report

 

 

Hope that helps

Use case: Let us say you wanted to have phone numbers to be in the following format without spaces and “00” or “+” in the starting of the phone number.

  1. Open your Program Canvas or Campaign Canvas and drag and drop CWM app, click on configuration.
  2. Assuming you are aware of CWM app, select Action as “RegEx Replace” and enter below code.

 

Find: \D ->it will remove all the spaces, “-“from the phone number.

Replace: Blank

 

3. Now, select Action as “RegEx Replace” again and enter below code:

Find: ^\s*(?:\+?(\d{1,3}))?[-. (]*(\d{3})[-. )]*(\d{3})[-. ]*(\d{4})(?: *x(\d+))?\s*$

Replace: 00$1$2$3$4 or +$1$2$3$4

 

 

4. Test your configuration: You will notice in first example- input of “+1231224543” with output of “001231224543”, and input of “123 456-1717” with output of “001234561717”.

 

** Please try it in your sandbox first.

 

** Need more information on Contact Washing Machine App? Click below Oracle Help Centre doc on what is Contact Washing Machine app, how to download/install it and it’s actions - https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAA/Help/Apps/ContactWashingMachine/Tasks/InstallingContactWashingMachine.htm?Highlight=contact%20washing%20machine

 

 

Hope this is helpful.

 

Thanks

Use case: Let’s say (see below snapshot) you have customized - “Email Analysis by Email Group” report per your use case and now you would like to customize the secondary “Total Clickthroughs by Contact” report to be replaced with the new, custom report you have created with specific contacts fields.

Let us get started:

As stated, I would be taking “Email Analysis Overview” report as an example, so when you click on any out of box report, analyzer license allows you to customize the report. Hence, Analyzer license is must in this case.

 

  1. Open any out of box report – let’s say,  “Email Analysis by Email Group” report, when you click on any metrics, let’s say “ Total Clickthroughs” it takes you to a drilled down (secondary) out of box report “Email Analysis by Email Group - Total Clickthroughs” which tells you the contact details like – email address, first name and others. We all know we can customize “Email Analysis by Email Group” report, now you can actually customize the later (secondary or drilled down) report. So, that any user click on your saved report and clicks on drilled down report, it will actually takes the user to customized drilled down report.

Below are the steps to customize the drill down report:

  1. Open any out of box/custom report and “save as” in any of the folder. Let us say the report is “Email Analysis by Email Group”.
  2. Open the drill down report and “save as” it as well. For Example – “Email Analysis by Email Group - Total Clickthroughs”
  3. Click on the gear icon of the attribute you want to update, click on “column properties” of “Email Analysis by Email Group” report.

   4. Click on “Interaction” ->”+”->”Actionlinks”:

 

    5. Click on “Navigate to BI Content”:

    6. Select your secondary or drill down report and save.

    7. Hit Results on primary report and you will notice that on clicking the “Total Clickthroughs” you will be getting customized secondary report.

 

Hope that is helpful.

Below is the solution to disable the “view in web browser” link entirely – so anyone who already received any of emails and later clicks “view in web browser” link would see an error page.

 

For disabling 'view in the webs' link in sent emails follow the below steps:

  1. Log into your instance
  2. Email Setup -> Email Defaults -> Advanced Options -> Saved Email Settings -> Search for the email you want to disable
  3. Select the email and click -> search for deployment
  4. It will give you all email sends for this email
  5. You can disable them correspondingly.

 

See snapshot for more details:

 

I hope this is helpful.

Let's say you collect Birthdays of your customers in format Year-Month-Date and you wish to isolate the "Month" in another contact field called "Month" for some custom emails to be sent month-wise. Below is the step-by-step guide to extract just Month from Birthday (Format: Year-Month-Date) using Contact Washing Machine and RegEx, please be mindful of testing the CWM configuration in sandbox first.

 

  1. Create a contact field named – MONTH per say in your instance.
  2. Drag and drop Contact Washing Machine(CWM) app in a new Campaign from action bar
  3. Double click on CWM app and click on pencil icon.
  4. Enter below steps on Configuration window. Please Select, Step name, Source Field as your date of "Birthday" (Format: Year-Month-Date) contact field,  “RegEx Extract” under Action Item and enter code “[-.\/](\d+)[-.\/]” and Destination field as "Month" in this case.

 

 

     5. Hit Save.

     6. Your configuration is saved; now test it via hourglass icon given at the top of the CWM configuration window. Add email addresses via”+” sign and hit “Run Test” to test your configuration. See in below snapshot - you will notice "Input Value as Birthday date" as Birthday - 2015(Year)-04(Month)-01(Date) and "Output Value as only Month" as "04".

Hope this will be helpful. Do let me know in case of any questions.

 

** Need more information on Contact Washing Machine App? Click below Oracle Help Centre doc on what is Contact Washing Machine app, how to download/install it and it’s actions - https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAA/Help/Apps/ContactWashingMachine/Tasks/InstallingContactWashingMachine.htm?Highlight=contact%20washing%20machine

The purpose of this article is to create a simple-to-follow guide to allow you to add a Datepicker widget into your Eloqua Landing pages.

 

The end result will look something like this:

I’m aiming this guide to be as simple as possible as I know that some people are not familiar with HTML at all. Hopefully with this step by step guide it’ll be made easy & worry free.

 

 

So if we make our basic form in Eloqua with email & a custom text field for date:

(Make sure you also set the HTML name of your date field to ‘date’ (all lower case))

We view HTML of the form by going to Actions > view Form HTML, & copying all of it from the form onto the clipboard.

 

We now create a new HTML Landing page, which will look like this:

<!DOCTYPE html>

<html>

  <head>  </head>

  <body>   

<-—form HTML goes here -->

  </body>

</html>

 

Paste the whole of your form code in between the body tags (as specified above).

 

You can now view your Landing page & it will just have the basic form on a white page.

For visual sake,  we’re now going to tidy it up to make it a bit neater.

On your Landing page scroll up in the code to find the closing </style> tag.

Just before it we add the following.

div{ width:300px; margin:0px auto;}

input{ border-radius:5px}

This sets the width to a more reasonable size & centralises the form.

The second line just softens the corners of the input boxes (it may add a shadow as well, depending on your browser).

 

Now we get to the meat of the tutorial: Adding the JQueryUI script onto the page to get the plugin working.

 

So essentially we need two script files added: the JQuery main JavaScript library & the JQueryUI script that will handle the datepicker widget.

We’ll also need to add the JQueryUI css file to handle the graphical element, - but worry not, I’m here to guide you through it....

 

So there’s two ways you can do this.

  1. Use the Google CDN versions that are available here: https://developers.google.com/speed/libraries/
  2. You can retrieve the raw files from http://jqueryui.com/ and https://jquery.com/ and you can host these files in your own instance’s file storage for personal use.

The first solution is much simpler & serves up the files pretty swiftly, however you are of course relying on Google for the files, and in some situations you might prefer to host the files so that you are totally self-reliant.

I personally have had no issue with the google served versions, so I will be stepping through that solution here.

From the google developers libraries you retrieve the JQuery .js file and the 2 JQueryUI files – the .js & .css one. They will look similar to the below.

 

JQuery

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

JQueryUI

<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>

 

<link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css">

 

So now you have these files, you’re going to insert them into your HTML, right before the closing </head> tag like this:

 

Now we’re nearly set.

 

Remember when I said to set the HTML name of your date field to ‘date’? Well that just makes it a bit easier to locate, and as now you need to find it, the easiest way is to do this is to perform a CTRL+F find on ‘name=”date”.

This will seek out the <input field in question. It will have a value id=”field1” or something similar & we are going to alter it to say id=”datepicker”

 

Your revised input should now say something similar to
<input id="datepicker" name="date" type="text" value="" class="field-size-top-large" />

 

OK, - last step.

So back in your HTML, again, just before the closing </head> tag you’re going to add this snippet:

 

<script>

  $( function() {

    $( "#datepicker" ).datepicker();

  } );

</script>

 

And that’s it! – save your file and go and try your new datepicker widget.

 

Good Luck!

Filter Blog

By date: By tag: