View Single Post
  #1   Report Post  
sfmoored sfmoored is offline
Junior Member
 
Posts: 4
Default Calculating Weighted Average

I want to calculate a single weighed average (a "Response Index") from three email disposition metrics:

The averages for all campaigns (and thus "Response Index" = 100):
Open Rate 26.3% (a number higher than this is better)
Click Rate 3.4% (a number higher than this is better)
Unsubscribe Rate 0.02% (a number LOWER than this is better)

I would like the "Response Index" to represent these weights:
45% Open Rate
45% Click Rate
10% Unsubscribe Rate

Sample Campaign #1:
Open Rate 20.1%
Click Rate 4.1%
Unsubscribe Rate 0.00%

How would I calculate the Response Index for Sample Campaign 1? This does not work: 20.1%/26.3%*45 + 4.1%/3.4%*45 + 0.00%/0.02%*10

Thanks for your help!!