28
Feb

How To Tell Exactly What You Sold As An eBay Affiliate

One of the things that frustrates many Build A Niche Store users and eBay affiliates in general is that they can’t figure out what specific items they’re earning commissions on. I see this question, or rather frustration, expressed in many forums, blog comments and many other places on the net. This would be valuable information for the affiliate marketer because you could then target this info better on your site if you knew what your hot selling items were.

So you can’t know for sure what you sold through the eBay affiliate program, that’s a bummer. Oh, but you can, and it’s not all that difficult. All you need is Microsoft Excel or any program that opens Excel documents or tab separated files and access to your CJ account.

Here’s how you do it:

Log into CJ and click on Run Reports in the top left tabs. Next, right below where it says Run Reports – Transaction Reports, click on Report Options and you will get a box that looks like this:

Commissions Summary

Once you do that, click on the drop down box under Select Report Type and select Commission Detail. When you do that, the next box below will change to say Advertisers: All. Click on that drop down box and select eBay from your list of advertisers. Go to the next section down labeled Filter Results By and in the box labeled Web site: All, select your web site that you want to see eBay stats on.

Next, go over to the right a little and under Select Time Frame, click the radio button that says Date Range and select the date or dates that you want to find specific transactions for. Your screen should now look like the one below:

eBay Commission Details

Click on Generate Report and you will then be taken to a screen that looks similar to the one below. You could have either more or less transactions depending on how many sales you had that day for that site.

Download eBay Commission Report

Once you are there, scroll down to the bottom of the report where it says Download Report and select Excel from the drop down box and then click Submit. You will then get a dialog box that asks you if you want to open or save the file, click Open and Excel will open with your details. With my example there will be only three lines in the spreadsheet, one is an Advanced Lead and the other 2 will say Winning Bid under the Auction Name column. Follow the Winning Bid row and scroll over the the far right of your spreadsheet and look for a column that says Order ID. If you followed everything correctly you will now see a cell full of numbers like the one below:

eBay Order ID Cell

BAM! You now have exactly what you’re looking for. Highlight the second number in the cell and copy it to your clipboard. Now go over to eBay and plug it in to the main search box and see what comes up. Item number 310023014821 on eBay is a Romanian 500 Lei silver coin that earned me a $1.66 .83 commission.

eBay Item Sold

Pretty cool, huh? You can do that with any item sold on eBay and you never have to wonder again what you’ve sold through the their affiliate program.

But wait, there’s more…

What if you want to check out all the items you sold in a particular day or period of time? It would be a drag to have to plug in every number one at a time to find out which items you sold if you had several. Today is your lucky day because there’s a way to list all your items at once. On the right hand side of the main search box on eBay click on Advanced Search and you will get a screen like below. Make sure you click on the box that says Completed listings only and put in all your numbers either space or comma separated. You do have to sign in to eBay to use this feature. If you don’t already have one, you can get an eBay account here.

eBay Completed Listings

Click on Search and see what you get:

eBay All Items Sold

As you can see, I sold the coin mentioned above and a Dell keyboard through the same site. That’s the beauty of the eBay affiliate program. You can earn commissions on two completely unrelated items because you get credit for whatever purchases someone makes within a 7 day period.

Use this valuable information to target your visitors with the most popular items you’re selling or just to see what’s bringing in the big commissions. Have fun and earn some bucks with the eBay affiliate program.

Cheers,

Alan

Popularity: 6% [?]

Tags: , , ,

If you have enjoyed this post, please consider subscribing to my full RSS feed or you can have posts send directly to your inbox if you subscribe by email.

Bookmarks: | del.icio.us | Digg it | Furl | reddit | StumbleUpon

19 Responses to “How To Tell Exactly What You Sold As An eBay Affiliate”

  1. Is there a way to do this with half.com as well? I had someone buy something for 21.99 and I can’t figure out what it was. Detail report from CJ give a “SKU #”. Checked half.com for that SKU and nothing found. Tried the e-bay trick since half.com is an e-bay company and no help there either.

    Mike

  2. Hi MIke, Unfortunately I’m not familiar with how Half.com pays out and their report format, so I can’t advise you on that one.

  3. Hi Alan,

    Thanks for the tips… I already knew how to find the single item but this batch search just doesn’t seem to work for me. I have tried it with spaces and commas in Firefox and also IE7 but the items are never found.

    I doubled and triple checked the numbers to be sure they were the right ones and they were. So, I’m at a loss why it works for you and not me.

    Any ideas?

  4. Great informative post.

  5. Hi Alan,

    Thanks for detailed explanation on this technique. I purchased BANS last summer and sort of let it gather dust due to other projects getting in the way. Your blog is very inspiring and is the kick in the butt I needed to dust it off and take action.

    In your example you said the item “earned me a $1.66 commission.” Did you mean .83 or am I missing something.

    Sincerely I appreciate deeply you taking the time to write all the encouraging posts here. Hopefully I can pay that back someday to someone else.

    Mike

  6. Chris – Make sure you’ve checked the Completed listings only box because it won’t work with the regular search. Also, if the item is more than 60 days old it probably won’t show up.

    Dean – Yes, my earnings were $1.66, not .83 Sorry, they were in fact .83

  7. Alan,

    Great tip! While I knew about the breakdown of that field and how to search on item number, I had never tried putting more than one item number in the search box.

    Chuck

  8. Hey Allan,

    I’m trying to use 4 sales from two days ago and have the item numbers spaced and the completed listings only ticked, Yet, it still doesn’t work for me. I did a search on all the items individually and they call came up as they should.

    Anyone else having a problem with this… strangest thing!

  9. Hi Chris,

    In order to get it to work you must put your query inside brackets. Example: (140209863527, 280204505143) Hope that helps.

    Alan, in regards to the 1.66 and the .83 what is the difference between the two? I tried looking on CJ and never could find an explanation other than commission(USD) was what the CJ affiliate receives. After reading that I was under the impression the .83 commission is what a CJ affiliate sees and the 1.66 sale was the total fee amount charged to the seller by Ebay.

    Thanks again for all your effort in making this resource available.

    Dean

  10. My bad, I actually earned .83 on the mentioned commission, not $1.66. Sorry for confusing everyone.

  11. Nice tips.. are you selling ebay products too?

  12. Excellent instructions. Is anyone aware of software that can handle this for us though.

  13. Alan,

    Thank you so much for posting this! I recently started a few BANS stores and while I have only had 6 commissions, it’s nice to now know what they were for! I have a question though….have you ever had problems receiving the correct amout for your commisions? I received an email on 2/29 from the eBay affiliate team stating the following:

    “A small subset of our publisher base is being affected by a reporting issue, which results in a delay in the calculation of the final value fee of a number of Winning Bids/BINs. As a result, you may notice reduced revenue commission amounts for successful transactions on certain days. We are working diligently to correct the issue, and will communicate the expected timeline for the fix as soon as possible. We apologize for any inconvenience this may cause you in the meantime.”

    I have to believe I am affected because after I was able to actually check my auctions today (thanks to you), I find it really hard to believe that an auction that ended on 2/19 that went for $79.99 only earned me a .12 commission….while I earned a .28 commission on a shart tooth that sold for .99 LOL I realize that affiliates only receive 50% of eBay’s revenue on an item, but surely there cannot be that much disparity between individual auction revenues….surely not! Any feedback you can provide will be appreciated. Thanks again!

  14. Cool post, is this a different program then the one at auction ad’s (shopping ads)?

  15. Julie – I also received that email from eBay and will be looking for a possible adjustment. There is a thread in the BANS forum that is discussing the same issue with apparently innaccurate reporting. I’m not sure where it is, so you’ll have to look around.

    Futon-Matt – This tutorial only works for stuff sold through the eBAy program run by CJ, not ShoppingAds.

  16. I have a much better suggestion, at least I think it is. Just go to http://www.mycjreport.com
    it is a free serive that was started by a digital point forum member . I use it all the time and it saves you stress. best of all it is FREE.

  17. Thanks for the feedback Alan. After reading the post over at the BANS forum and one over at the eBay affiliate forum, it’s nice to know I’m not scratching my head alone!

  18. jocelyn,

    Thanks for the link. I am aware of this site, but some people, including myself, are uncomfortable giving PID numbers and conversion data to a third party.

  19. Awesome tip. I’ll admit, I didn’t realize you could see the items. Of course, it still seems a little labor intensive, but it’s better than giving away your data.

Leave a Reply