ATV by clip for Hellmans's campaign

atv_by_clip.rb

# Campaign Detail Exports - CDE SA - Hellmann's - Best Foods - Social Ads
# CDE export:
# PROMOTED VIDEO  0
# SOCIAL GAMING   -
# SKIPSTREAM      -
# CHOICEROLL      -
# ADD. TRACKED VIEWS  1562155


# OD Data export
# Date Filter: Single
# Data Source: od
# Stats: cum
# Date: 2013-10-24
od = {
  "cQSFFWBJ02Q" => 44893, 
  "rtmp://cp52347.edgefcs.net/ondemand/&mp4:streams/1570026296/1570026296_2387424316001_Mario-Batali-Intro-Hellmanns-FINAL-PR-REV--281-29-x264.mp4" => 73, 
  "83aClJk-lGs" => 45041, 
  "K4P3z2Djsu4" => 25291, 
  "xzwjmp"      => 3952, 
  "2MTK1gBvoUw" => 21885, 
  "fsyX4B0Jk9k" => 21879, 
  "d58lUl9SeMM" => 690, 
  "rtmp://cp52347.edgefcs.net/ondemand/&mp4:streams/1570026296/1570026296_2498900290001_Hellmanns-EC-Eggs.mp4" => 431, 
  "fABqOjn_sFE" => 6838, 
  "YMAdoKNjWaA" => 33269, 
  "BhUIFmCO9BA" => 28146, 
  "2rBcIb9j0wg" => 33527
}

# Rule data Export
# Date Filter: Single
# Data Source: rule
# Stats: cum
# Date: 2013-10-24
rule = {
  "BhUIFmCO9BA" => 224100,
  "2rBcIb9j0wg" => 33527,
  "rtmp://cp52347.edgefcs.net/ondemand/&mp4:streams/1570026296/1570026296_2387424316001_Mario-Batali-Intro-Hellmanns-FINAL-PR-REV--281-29-x264.mp4" =>  73,
  "cQSFFWBJ02Q" => 44893,
  "p1uKR5LuniM" => 297,
  "fsyX4B0Jk9k" => 190433,
  "2MTK1gBvoUw" => 200024,
  "D-K2vj4B8PA" => 301,
  "SUmL2Ldif3c" => 310027,
  "BdpAwNzTUk8" => 301,
  "KF-9SzjSR-U" => 74,
  "rtmp://cp52347.edgefcs.net/ondemand/&mp4:streams/1570026296/1570026296_2498900290001_Hellmanns-EC-Eggs.mp4" => 431,
  "vSRLjXrcC9Y" => 300,
  "K4P3z2Djsu4" => 219166,
  "Qzdgusuv65I" => 59,
  "wtQS40T3xkQ" => 301,
  "83aClJk-lGs" => 45041,
  "ZzLsV2HFcfQ" => 301,
  "s1RBXQxEiqk" => 300,
  "YMAdoKNjWaA" => 41927,
  "d58lUl9SeMM" => 88607,
  "qwxg_hCr2oc" => 297,
  "fABqOjn_sFE" => 6838,
  "xzwjmp"      => 4931,
  "23vr1T3bLUc" => 280494,
  "bhYMk9dm2Kk" => 141
}

atv = 0
rule.each do |k,v|
  p k
  od_value = od[k] || 0
  clip_atv = v - od_value
  atv += clip_atv
  p "clip ATV: #{clip_atv}"
end

p "ATV: #{atv}" # => "ATV: 1427269"