Skip navigation

Do It

1 Post authored by: RichardGar

[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

Filter Blog

By date: By tag: