Spreadsheet: 328947d1404145343-extension-of-iferror-vlookup-formula-help-needed-publisher-control-sheet-may
Sheet: Gross profit

Liverail totals
INSERT TO ENABLE FORMULAS TO WORK | Site | INSERT TO ENABLE FORMULAS TO WORK | Impressions | Revenue | Spend | Revenue eCPM | Spend eCPM | Inventory | Overlay/Preroll
6710 Kitara Media | 6710 Kitara Media
Adam' Test Site | Adam' Test Site
[NAME] | [NAME]
Altitude Digital - Pre-roll | Altitude Digital - Pre-roll
AnyClip | AnyClip
AnyClip | Anyclip - RADAR
Cheezburger - Failblog | Cheezburger - Failblog |  |  |  |  |  |  |  | o
Cheezburger - Failblog | [NAME] |  |  |  |  |  |  |  | o
Cheezburger - Failblog | Cheezburger - icanhas |  |  |  |  |  |  |  | o
Cheezburger - Failblog | [NAME] |  |  |  |  |  |  |  | o
Cheezburger - Failblog | Cheezburger - roflrazzi |  |  |  |  |  |  |  | o
Cheezburger - Failblog | Cheezburger - thedailywhat |  |  |  |  |  |  |  | o
Coull Test Site - Dev & QA | Coull Test Site - Dev & QA |  |  |  |  |  |  |  | o
Coull Test Site - Dev & QA #2 | Coull Test Site - Dev & QA #2 |  |  |  |  |  |  |  | o
Coull Test Site - Dev & QA #3 | Coull Test Site - Dev & QA #3 |  |  |  |  |  |  |  | o
Coull Test Site - Dev & QA - Stage Smaato | Coull Test Site - Dev & QA - Stage Smaato |  |  |  |  |  |  |  | o
Coull Test Site 1 | Coull Test Site 1 |  |  |  |  |  |  |  | o
coull.com | coull.com |  |  |  |  |  |  |  | o
Curse - Reign Of Gaming | Curse - LOLPro |  |  |  |  |  |  |  | o
Curse - Reign Of Gaming | Curse - Marriland |  |  |  |  |  |  |  | o
Curse - Reign Of Gaming | Curse - Minecraft Forum |  |  |  |  |  |  |  | o
Curse - Reign Of Gaming | Curse - Minecraft Gamepedia |  |  |  |  |  |  |  | o
Curse - Reign Of Gaming | Curse - MMOChampion |  |  |  |  |  |  |  | o
Curse - Reign Of Gaming | Curse - Reign Of Gaming |  |  |  |  |  |  |  | o
Czarina Media | Czarina Media
DailyMotion | DailyMotion |  |  |  |  |  |  |  | o
DailyMotion Pre-roll | DailyMotion Pre-roll
Demand Media Private Exchange | Demand Media Private Exchange
Future - BikeRadar | Future - BikeRadar |  |  |  |  |  |  |  | o
Future - CVG | Future - CVG |  |  |  |  |  |  |  | o
Future - T3 | Future - T3 |  |  |  |  |  |  |  | o
Future - TechRadar | Future - TechRadar |  |  |  |  |  |  |  | o
Health Guru | Health Guru
IntoHand Mobile SDK | IntoHand Mobile SDK |  |  |  |  |  |  |  | o
JW Player | JW Player VAST |  |  |  |  |  |  |  | o
[NAME] | [NAME]
Matomy - PreRoll | Matomy - PreRoll
MMORPG | MMORPG |  |  |  |  |  |  |  | o
Muzu | Muzu |  |  |  |  |  |  |  | o
Perform Group_North America | Perform Group_North America
[NAME]'s vastomatic test | [NAME]'s vastomatic test
Publisher [NAME] Do not archive - AF | Publisher [NAME] Do not archive - AF
Publisher Test Site | Publisher Test Site
Publisher Test Site 2 | Publisher Test Site 2
SideReel | SideReel
Stickyads.tv | Stickyads.tv
[NAME] | [NAME]
UVidi | UVidi
Video Natives - Pre-roll | Video Natives - Pre-roll
VideoMize | VideoMize |  |  |  |  |  |  |  | o
VideoMize - Pre-roll | VideoMize - Pre-roll
Viewster | Viewster - Pre-roll
Viewster | Viewster - Pre-roll - Syndication Sites
Web3 - Pre-roll | Web3 - Pre-roll
[NAME] adjustments
DailyMotion | DailyMotion |  |  |  | 11.23 |  |  |  | o
DailyMotion Pre-roll | DailyMotion Pre-roll |  |  |  | -14436.11
Less Google as shown in LR |  |  | Impressions | Revenue | Spend | Revenue eCPM | Spend eCPM | Inventory
DailyMotion | DailyMotion |  |  |  |  |  |  |  | o
Less Smaato as shown in LR |  |  | Impressions | Revenue | Spend | Revenue eCPM | Spend eCPM | Inventory
Cheezburger - Failblog | Cheezburger - Failblog | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | [NAME] | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | Cheezburger - icanhas | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | [NAME] | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | Cheezburger - roflrazzi | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | Cheezburger - thedailywhat | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - LOLPro | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Marriland | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Minecraft Forum | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Minecraft Gamepedia | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - MMOChampion | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Reign Of Gaming | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Future - BikeRadar | Future - BikeRadar | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Future - CVG | Future - CVG | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Future - T3 | Future - T3 | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Future - TechRadar | Future - TechRadar | Smaato - Mobile - Generic |  |  |  |  |  |  | O
MMORPG | MMORPG | Smaato - Mobile - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | Cheezburger - Failblog | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | Cheezburger - icanhas | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Cheezburger - Failblog | Cheezburger - roflrazzi | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - LOLPro | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Marriland | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Minecraft Forum | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Minecraft Gamepedia | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - MMOChampion | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Curse - Reign Of Gaming | Curse - Reign Of Gaming | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Future - BikeRadar | Future - BikeRadar | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Future - CVG | Future - CVG | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Future - T3 | Future - T3 | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Future - TechRadar | Future - TechRadar | Smaato - Tablet - Generic |  |  |  |  |  |  | O
MMORPG | MMORPG | Smaato - Tablet - Generic |  |  |  |  |  |  | O
Less SpotXchange in LR |  |  | Impressions | Revenue | Spend | Revenue eCPM | Spend eCPM | Inventory
[NAME] | AdMedia_SpotXchange
Altitude Digital - Pre-roll | Altitude_SpotXchange
AnyClip | Anyclip_SpotXchange |  |  |  |  |  | AnyClip has 70/30 split
Czarina Media | Czarina_SpotXchange
DailyMotion Pre-roll | Dailymotion_SpotXchange |  |  |  |  |  | $9 CPM for DM
6710 Kitara Media | Kitara_SpotXchange
[NAME] | [NAME]
Matomy - PreRoll | Matomy - SpotXchange
SideReel | Sidereel_SpotXchange |  |  |  |  |  | Sidereel spend floor price of $4 CPM
Stickyads.tv | Stickyads_SpotXchange
UVidi | Uvidi_SpotXchange
VideoMize - Pre-roll | Videomize_SpotXchange
Video Natives - Pre-roll | VideoNatives_SpotXchange
Viewster | Viewster - SpotXChange
Web3 - Pre-roll | Web3_SpotXchange
Add AdX |  |  | Impressions | Revenue | Spend | Revenue eCPM | Spend eCPM | Inventory
DailyMotion |  | Dailymotion.com |  |  |  |  |  |  | O
Muzu |  | Muzu |  |  |  |  |  |  | O
Blinkx |  | Blinkx |  |  |  |  |  |  | O
(Non-represented) |  | (Non-represented) |  |  |  |  |  |  | O
Evolve Media |  | Evolve Media |  |  |  |  |  |  | O
JW Player |  | JW Player |  |  |  |  |  |  | O
Perform Group_North America |  | Sporting News Media |  |  |  |  |  |  | O
 |  |  | Impressions | Revenue | Spend | Revenue eCPM | Spend eCPM | Inventory
Add Smaato |  |  |  |  |  |  | Gross revenue - Smaato take 25% of gross revenue.  This balance is then split with the publisher
Future - TechRadar |  | Future - TechRadar.com |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | Curse - Minecraft Gamepedia |  |  |  |  |  |  | O
Future - T3 |  | Future - T3.com |  |  |  |  |  |  | O
AnyClip |  | AnyClip |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | Curse - LoL Pro |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | Curse - Reign of Gaming |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | Curse - Marriland |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | Curse - MMO-Champion |  |  |  |  |  |  | O
coull.com |  | [NAME] All |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | Curse - Minecraft Forums |  |  |  |  |  |  | O
Future - CVG |  | Future - CVG |  |  |  |  |  |  | O
Future - BikeRadar |  | Future - Bikeradar |  |  |  |  |  |  | O
MMORPG |  | MMORPG |  |  |  |  |  |  | O
Cheezburger - Failblog |  | Cheezburger |  |  |  |  |  |  | O
Smaato cost of sales
 |  |  | Impressions | Revenue | Spend | Revenue eCPM | Spend eCPM | Inventory
Add SpotXchange
[NAME] |  | Coull_AdMedia (91479)
Altitude Digital - Pre-roll |  | Coull_Altitude (91250)
AnyClip |  | Coull_Anyclip (90875) |  |  |  |  | AnyClip has 70/30 split
Czarina Media |  | Coull_Czarina (91471)
DailyMotion Pre-roll |  | Coull_Dailymotion (91024) |  |  |  |  | DM floor price is $9
6710 Kitara Media |  | Coull_Kitara (91072)
[NAME] |  | Coull_Knowlera  (92266)
Matomy - PreRoll |  | Coull_Matomy_Media (92335)
SideReel |  | Coull_Sidereel (90864) |  |  |  |  | Sidereel spend floor price of $4 CPM
Stickyads.tv |  | Coull_Stickyads (91542)
Uvidi |  | Coull_Uvidi (91544)
VideoMize - Pre-roll |  | Coull_Videomize (90991)
Video Natives - Pre-roll |  | Coull_VideoNatives (91539)
Viewster |  | Coull_Viewster (92106)
Web3 - Pre-roll |  | Coull_Web3 (92486)
 |  |  |  | OpenX reports in GBP.  Hence needs to be converted to USD
Add OpenX |  |  | Impressions | Revenue in USD | Spend | Revenue eCPM | Spend eCPM | Inventory | Exchange rate (£'s to dollars) | 1.656
Future - BikeRadar |  | bikeradar.com |  |  |  |  |  |  | O
Future - CVG |  | computerandvideogames.com |  |  |  |  |  |  | O
Coull Test Site 1 |  | Coull - Marios - Test |  |  |  |  |  |  | O
coull.com |  | coulloffers.com |  |  |  |  |  |  | O
Cheezburger - Failblog |  | failblog.cheezburger.com |  |  |  |  |  |  | O
Factory |  | forums.sidewalkmag.com |  |  |  |  |  |  | O
Cheezburger - Failblog |  | geek.cheezburger.com |  |  |  |  |  |  | O
Cheezburger - Failblog |  | icanhas.cheezburger.com |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | lolpro.com |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | marriland.com |  |  |  |  |  |  | O
Cheezburger - Failblog |  | memebase.cheezburger.com |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | minecraft.gamepedia.com |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | minecraftforum.net |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | mmo-champion.com |  |  |  |  |  |  | O
MMORPG |  | mmorpg.com |  |  |  |  |  |  | O
Muzu |  | muzu.tv |  |  |  |  |  |  | O
Curse - Reign Of Gaming |  | reignofgaming.net |  |  |  |  |  |  | O
Cheezburger - Failblog |  | roflrazzi.cheezburger.com |  |  |  |  |  |  | O
Future - T3 |  | t3.com |  |  |  |  |  |  | O
Future - TechRadar |  | techradar.com |  |  |  |  |  |  | O
Cheezburger - Failblog |  | thedailywhat.cheezburger.com |  |  |  |  |  |  | O