excel for managing tons of data (6)
In this thread here http://stmforum.com/forum/showthread...or-and-bidding some interest was expressed in how to handle combing data from various camps with placement overlap.
So here is a cool excel formula.
=IF(ISERROR(MATCH(O3,$A$3:$A$675,0)),"0",LOOKUP(O3 ,$A$3:$A$675,$E$3:$E$675))
Consider the case where you are split testing bids as in the image above. You have several campaigns, all hitting the same placements. If you want to check out total spend on each placement you often cannot just copy paste your placements in ascending or descending order as some may or may not hit at each bid, making placement alignment for spend summing a bitch. The above formula will use excel to search through a column of placements, find its corresponding spend, and report it.
In this case, col. O is all the placements you are hitting at all bids. Q and R are that placement's spend at various bids. The formula above will search placement lists in column A or H for a placement, and output its spend in Q or R. In the event a placement is not found, it will output "0" in the table to make your sum function in col S not return an error.
or use it for where
IFERROR(
is a more efficient/cleaner function 
Originally Posted by ipyxel
is a more efficient/cleaner function
thedav: that's a really nice solution. I had something close that I devised for Airpush, but it wasn't as visually as clear as your layout.
Auditor: I believe it just combines the IF and ISERROR statements to make the formula a littler cleaner. Functionally it's the same
is your intention to study every placement into detail to see how much you need to bid to get impressions? how would you segment your campaigns after you get this data? 2-3 separate campaigns bidding for these placements?
how would u test new sites that come in on the RON but not noticeable when you whitelist/target sites?
Home > Technical & Creative Skills > Tracking Campaigns