You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Guidance needed on correct method to calculate aggregate Open Rate and CTR in CRMBI in Eloqua

in Eloqua

Summary:


Content (please ensure you mask any confidential information):

In CRMBI we are putting together a rolled up view of our Q2 email performance across a set of campaigns and want to confirm the correct way to calculate the aggregate Open Rate and Click Through Rate at the total level. I have attached the Excel file we are working from so you can see the exact figures.

 

Here is our current method and an alternative we are considering.

 

How we calculate it today

 For the total row, we take each individual campaign's Open Rate and CTR and average those percentages directly. So the total Open Rate is the simple average of the sixteen campaign open rates, and the same for CTR. This currently returns roughly 25.5 percent Open Rate and 7.2 percent CTR.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!