I apologize if I'm posting this in the wrong place, but I need some advice about tracking CJ sales. I'm an affiliate and send traffic to landing pages and then to the merchant's site via PPC.

I've been trying to find a way to use the sid field to track conversions to the keyword level. I have been successfull, but I'm having trouble figuring out how to compare it to cost data from PPC cost reports. I've been playing with Covert Conversion Pro, which is great because it shows you what search engine and keyword the sales originated from, but then you have to go into your AdWords, Yahoo, MSN, etc. account and manually compare the information to get the profitability.

Does anyone know if there is a way or program that will track the keyword and engine and also import cost data to determine ROI? It seems there should be a program or script out there but I just can't seem to find much info on the subject. Thanks in advance for any help!