Hello, I want to create a combined report of google adword data and commission junction data. I have brought some keywords from google adwords and if I get commission through that keywords related products from commission junction. But I am not sure how to combine these both data. I have extracted both adwords data and commission junction data using corresponding AIPs. In commission junction I can see SID and adwords adgroup id. Can we combine these two? Or how can I get correct report (amount commission get for each keywords) anyone have idea about it. I am not sure I explained it correctly. Please help. Thanks, Vip
I don't know if CJ will pick up a parameter passed to them and report on it. That's the key obviously. Seems like it does since you mention you see the adgroup ID. If so, you need to pass along the ad's ID. That will be more useful than the keyword although you can do that too along with the match type. Until recently, I didn't know this could be done but this page explains all the codes you can pass. You are interested in the {creative} tag for the ad. The problem then will be to link the data from CJ and Adwords. For this, you will need to download the data from both and use a database management system like Access. A spreadsheet just won't cut it.
Hello, Thank you very much for your reply. Yes I have downloaded data from both CJ and adwords and inserted into mysql database. But how can we relate it. Is the adwords adgroup id and CJ's SID are same? I think we can use CJ's SID for tracking commission. But my doubt is which adwords parameter we can use to check the money I spend to buy keywords and commission i got from CJ. Below are the data fields i am getting for cj using API. campaign_name campaignid campaign_status adgroup_name adgroupid adgroup_status keyword_text impression click average_position quality_score ctr average_cpc max_cpc cost report_date Please help. Thanks, Vip