5 Replies Latest reply on Jul 9, 2019 5:39 PM by Alexa Kalapaca-Oracle

Total Unique Open Rate Calculated Incorrectly?

I pulled a basic email analysis report in Eloqua of 5 emails. It showed the total unique opens to be less than the sum of each email's unique opens. I am guessing this means the total contacts who opened an email (some contacts received more than 1 email). Fair enough. But then, to calculate the total unique open rate it took the total unique opens number and divided it by the total number of emails delivered. So for example, if you send 50 contacts 2 emails each, the max number of unique opens you could possibly have is 50, but the total deliveries is 100, so the max theoretical unique open rate is 50%.

To me this method of calculating unique open rate is completely useless. Wouldn't it make much more sense to calculate it as the total number of unique opens divided by the total number of contacts emailed? Then at least it's showing you something (% of contacts who have opened at least 1 email), whereas the current methodology gives you an arbitrary number.

• 1. Re: Total Unique Open Rate Calculated Incorrectly?

@z3115I experienced the same issue in Insight.  My total column for Open Rate (sum of a bunch of emails together) had a lower rate than it should have. It should get the percentage by taking the # of opens/# of delivered. I tried various combinations in the formula area and still the same result. It won't calculate it correctly. The individual email open rates for each email are correct (on the row), just not the aggregate total at the bottom for all emails. This is a very basic functionality that should work.

I submitted a Support ticket and this is what the agent said: "Additionally, I have spoken internally with my team in regards to how to edit formulas for "rate" based calculations in Insight. It seems that the rate based calculations are not functioning as expected at the moment, and many of our clients have been having trouble configuring formulas that will suit their needs for "rate" calculations. The developers are aware of the issues all our clients are facing with this and are working to fix it for a future update.

• 2. Re: Total Unique Open Rate Calculated Incorrectly?

We are having the same problem with the rates not calculating correctly. I submitted a support ticket regarding the sums and rates and was given this: Insight (OBIEE) Tips | Managing Unique Totals it will correct the Unique sums, but not the rates.

• 3. Re: Total Unique Open Rate Calculated Incorrectly?

We got the same results after submitted a support ticket. The unique open rate and ctr is more of a response rate, contact% of actual conversion rate to evaluate email performance. We have to redo all the calculations in excel. Really wish they could change it back.

• 4. Re: Total Unique Open Rate Calculated Incorrectly?

I just experienced a similar issue when calculating the unique open rate. ELQ posts 21.77%. After manually tabulating 47 unique opens against a 248 total delivered, I get 18.95%. I, too, will look into submitting a support ticket.

• 5. Re: Total Unique Open Rate Calculated Incorrectly?

Hi there, please have a look at this post to understand how the grand totals are calculated for uniques: https://community.oracle.com/groups/eloqua-insiders/blog/2018/07/03/insight-obiee-demystifying-unique-totals Tips in these posts might be what you are looking for: * https://community.oracle.com/docs/DOC-1029665 * https://community.oracle.com/docs/DOC-1022281