AMWSO is working on a suite of tools that are aimed at making it easier for affiliate partners to work with merchant data. We're aiming to resolve a range of issues and the first one we have focused on is "Getting the data clean"
http://www.amwso.com/rss/detail.php?ID=4#119
After you read the info at the link above, come back to ask questions or discuss it.