homepage Welcome to WebmasterWorld Guest from 54.146.175.204
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Google / Google AdWords
Forum Library, Charter, Moderators: buckworks & eWhisper & skibum

Google AdWords Forum

    
Google adwords and commission junction combined report
My doubts regarding google adwords and commission junction combined report
vipinpa



 
Msg#: 4426828 posted 6:40 am on Mar 9, 2012 (gmt 0)

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

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4426828 posted 5:14 pm on Mar 9, 2012 (gmt 0)

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



 
Msg#: 4426828 posted 5:41 am on Mar 10, 2012 (gmt 0)

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

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 4426828 posted 2:22 am on Mar 15, 2012 (gmt 0)

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



 
Msg#: 4426828 posted 7:18 am on Mar 15, 2012 (gmt 0)

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Google / Google AdWords
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved