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

Google AdWords Forum

Which keyword made the sale?

 3:39 am on Mar 10, 2005 (gmt 0)

Using Adwords and CJ is there anyway to tell which keyword made the sale? When you have 100 keywords and 10 have clicks is there anyway to know whcih keyword generated the sale? If so, please explain. Thanks



 7:10 am on Mar 10, 2005 (gmt 0)

Well yes, you can set up links each using a different 'sid' (found under advanced options in CJ) for each keyword. Then for destination URL in AdWords, just specify the appropriate link including its sid.

It's probably a very worthwhile thing to do if you have the patience.



 7:16 am on Mar 10, 2005 (gmt 0)

I used the sid, it's not showing up in my CJ advanced reports, those columns are all blank.

You sure CJ doesn't have to enable something?

FYI, I was doing a lot of specific keywords but found the phrase match worked a heck of a lot better, a lot less work, and my revenue shot up.


 8:34 am on Mar 10, 2005 (gmt 0)

Perhaps they do have to turn something on. Perhaps it just doesn't work right. What I quoted was based on my own reading of CJ's "features".

I tell you, the on-line world gets by with such lax standards with regards to tight programming compared to the offline world of applications.

That's why I joined the on-line world :)



 8:45 am on Mar 10, 2005 (gmt 0)

I let CJ make the entire link, when you go into GET HTML, and their pop up shows, I click on "Show Advanced Options" and it brings up SID, where you type it in.

All it does is add "?sid=blah" to the end of the URL, but it's not being tracked in the report.

C'est la vie.


 10:05 am on Mar 10, 2005 (gmt 0)

So, IncrediBILL, the most it tells you is who's coming through in your log?

Sorry, Zeus - my suggestion was theoretical, not something I had tried.

If they included a column on their reports though, it must be something they intended to have working.

You guys and other CJ Affiliates should write them. Perhaps if enough people requested it.....



 11:28 am on Mar 10, 2005 (gmt 0)

I can confirm that CJ's SID tracking feature works great, and is already "on" by default in your account.

I make plenty of CJ sales, and the only time the SID tracking code hasn't shown is when I've set it up wrong.

Although it was mentioned how to set up the SID tracking code in an earlier post, I'll do it again...

Append it to the end of your CJ affiliate links, as follows... A question mark, followed by SID= and then a tracking code you assign. For example: example.com?SID=1234

Then when you make a CJ sale or generate a lead, the tracking code 1234 shows up in your stats, if set up properly.

Remember that you can use CJ's SID tracking feature to track by specific ad, or by specific keyword.

To track by KEYWORD, assign a different, unique tracking link to the Destination URL of each keyword in your campaign.

Power Tip: An easy way to manage this step is by using a sequential number as the tracking code, automatically assigned by using " Edit > Fill > Series..." in an Excel spreadsheet. Then batch upload to the proper ad group.

To track CJ conversions by AD, assign a different, unique tracking link to each ad. And be sure there are no Destination URL's assigned to any specific keywords, or they'll override your ad tracking links.

You'll know you've set it up properly when the tracking code for an ad or keyword shows up in the SID column of your CJ stats. If it doesn't, you've most likely made a mistake somewhere, not CJ.

Marty Foley

[edited by: eWhisper at 1:26 pm (utc) on Mar. 10, 2005]
[edit reason] Please use example.com for sample links. [/edit]


 2:21 pm on Mar 10, 2005 (gmt 0)

I can't believe I missed the box to enter "sid" in the advanced option. Silly me. Anyway, once I add a sid to my link does it then show up in the "report" on CJ where my sales and commission are listed? If so, where do I see it? How do I know which keyword or ad made that sale? Thanks again.


 3:36 pm on Mar 10, 2005 (gmt 0)

> once I add a sid to my link does it then show up in the "report" on CJ where my sales and commission are listed? If so, where do I see it? <

Yes, it shows up in the "SID" column of your CJ reports, for sales and leads.

> How do I know which keyword or ad made that sale? <

Based on the unique tracking code you've assigned each ad or keyword.

A shortcut for looking up tracking codes is to use a text editor or other software that will let you search through all files containing your keywords (or ads) and their tracking codes, without opening the files.

For example, I use UltraEdit. I think NoteTab Light (which is free) lets you do the same.

Then when you generate a CJ sale or lead, it's a quick task to look up the exact ad or keyword, for your records.

Marty Foley


 4:56 pm on Mar 10, 2005 (gmt 0)

Yup, did ALL that... no SID

I'm registering sales, and passing a parm on a URL is web 101 so I sure didnt get that wrong.

Even let CJ's HTML thingy create it for me after it failed when I did it manually, still doesn't show.

At this point I don't care as long as the SALES keep showing up.

Guess I'll email CJ support and wait for my canned non-answer.


 5:17 pm on Mar 10, 2005 (gmt 0)

Two last questions.

Can I go into the edit section of adwords and just add on the end of each destination link a sid? Example I could add on "&sid =widget"?

Second question can I used words as sid's?

Thanks for all your help.


 5:29 pm on Mar 10, 2005 (gmt 0)

> Can I go into the edit section of adwords and just add on the end of each destination link a sid? Example I could add on "&sid =widget"? <

Yes, you can manually add an SID to your CJ affiliate links, if you prefer.

> can I used words as sid's? <

Yes, you can use letters and/or numbers. I don't know what the maximimum allowable number of characters is though.

If you have more questions CJ offers some PDF docs that explain more about it, on their site. Not sure where, though ;-)

Marty Foley


 5:45 pm on Mar 10, 2005 (gmt 0)

> Example I could add on "&sid =widget"? <

One problem may be that you're preceding the SID with an ampersand, instead of a question mark (?SID=XXX). At least you are in your example.

Marty Foley


 6:15 pm on Mar 10, 2005 (gmt 0)

I went to CJ and added a sid using the advanced deal and it added the & so I figured that is needed and not a question mark. I will test it a little later again and see if it does it again.


 7:56 pm on Mar 10, 2005 (gmt 0)

I played around with it a little and found this out.

If I change the "Destination URL" and add a SID it inserts an ampersand (&) instead of a question mark.

If you do NOT change the "Destination URL" it inserts a question mark.

Can anyone else check and confirm?


 9:11 pm on Mar 10, 2005 (gmt 0)

Some of the CJ merchants who use batch processing don't support SID. Most merchants don't use batch processing and many that do support SID, but there are some that don't.

As for whether to use? or &, it's pretty easy to figure out. If there's already a? in the URL, use &. If there isn't, use?.

archie goodwin

 9:39 pm on Mar 10, 2005 (gmt 0)

Another helpful thing using AdWords with CJ links is use dynamic keyword insertion into your SID.

For example:?sid={keyword}

only downside is you won't know what kind of match it was if you have multiple kinds in that adgroup. We separate our adgroups so sid=p{keyword} for a phrasematch and so on.


 3:50 am on Mar 11, 2005 (gmt 0)


You just add?sid={keyword} to the end of your link? Then in the SID column of the report it displays the keyword? Do I understand you right? Thanks

archie goodwin

 4:34 pm on Mar 11, 2005 (gmt 0)

zeus: yep, that's exactly what we do.


 4:59 pm on Mar 11, 2005 (gmt 0)

Archie Thanks, Zeus


 8:50 pm on Mar 16, 2005 (gmt 0)

What if your not linking directly to CJ? For example, you setup a html page with a banner or something that then links to cj, will you have to create a seperate page for each keyword?

archie goodwin

 10:46 pm on Mar 16, 2005 (gmt 0)

We do this for campaigns that we have our own landing pages, but I'm not really knowledgable (ok, not at all) about how exactly the process works. We put the dynamic keyword into the landing page url, and it dynamically generates a page with the proper CJ SID in the links.



 12:03 am on Mar 17, 2005 (gmt 0)

WOW, that sounds interesting... think you can get more information on it? It will benefit me a lot.

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