Google adwords and commission junction combined report

My doubts regarding google adwords and commission junction combined report

[vipinpa]

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

[smallcompany]

You're working on the best possible way of doing affiliate business when about tracking your own activity.

I have extracted both adwords data and commission junction data using corresponding AIPs.

Now you need to program something that will put it together based on SID.
On a Google side, you get the SID from the URL which can be set for each keyword separately. On CJ side, SID is already separated value.
Each CJ transaction with identical SID should add commission for the period given.

Your end result should show the total commission of i.e. 3 sales that were brought in with SID "example"

LMK if I missed something and you need more clarification.

[vipinpa]

Hello,

Thank you very much for your reply.

Yes got some idea from your reply. But my doubts in this section,

"On a Google side, you get the SID from the URL which can be set for each keyword separately"

My doubt in google adwords section. CJ is clear and we will get SID directly 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

What is SID in this?

Can you explain it with an example of sample url?

Thanks,
Vip

[smallcompany]

Below are the data fields i am getting for cj using API.

This is from Google AdWords, not from CJ.

Can you explain it with an example of sample url?

As I said, I never used this as I'm not a coder, but I dug a bit and found this:
[code.google.com...]

Here is another link:
[code.google.com...]

I remember that in the past, if you used {keyword} in your destination URL, AdWords would replace it with the keyword from your ad group that has triggered the ad (not the real keyword if it was a phrase or broad match).
I guess you could use this, plus extract the real keyword if it's available and send both as SID to CJ. Then, after pulling both reports via API and comparing them you could see the performance of your each keyword from your AdWords campaigns. This is all supposed to happen through some application built by you.

[vipinpa]

Hello,

Thank you!
Yes it is AdWords, not CJ. My mistake, sorry :)

Thank you for your detailed explanation. I hope it will help me. I will work it like this and let you know if any difficulties.

Thanks again.
Vipin