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.



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


Build A Niche Store Version 3 Release Date March 3rd

Build A Niche Store v3Build A Niche Store (BANS) users received a very exciting email yesterday letting them know that version 3 of the eBay affiliate niche store builder is getting the final tweaks and will be released on March 3rd. This new version promises to be a very significant upgrade to an already robust script for use with the eBay affiliate program.

I’ve been reporting on the progress of the latest BANS update for about a month now and have been telling everyone that the upgrade is just one more week away. Well, it is official from the horse’s mouth, as of this coming Monday the release of version 3.0 is just one more week away. This latest email included a link to a pdf file that outlines all the major upgrade features of this new version, complete with numerous screenshots of the new admin panel and interface.

BANS Interface

The pdf outlines in much more detail than any emails or updates up to this point all of the new features including:

BANS Goes Global– All previous versions of BANS have only included 4 or less countries eBay has a presence in. The new version adds 8 more including Austria, Belgium, France, India, Italy, Netherlands, Singapore and Spain to the United States, Canada, United Kingdom and Australia.

BANS Goes Local– New geotargeting features of BANS now allows you to target local customers anywhere. Sell eBay featured golf clubs to someone in Florida or to golf enthusiasts around the Masters Tournament in Augusta Georgia. This also opens up local advertising opportunities for BANS store builders.

BANS For eBay Sellers– This is a very cool feature I didn’t even know about until this pdf was released. Not only is BANS great for eBay affiliates, it’s a fantastic tool for eBay Sellers as well. If you sell a lot of items on eBay or have an eBay store, you can set up your own web site outside of eBay and increase the exposure of your auctions, plus earn affiliate commissions on your own merchandise. eBay has allowed sellers to earn affiliate commissions on their auctions for about 7 or 8 months now. 

BANS Becomes Even More Search Engine Friendly– This is the most significant feature in my estimation because BANS will now allow you to automagically generate a Google Sitemap, cloak all your affiliate links (links will look like they go to your site, not eBay), generate meta tags site wide and for any individual page and will also allow you to place content both above and below your auction listings.

Other features include the option to have different advertising on every page of your site by overriding the global advertising options, the ability to edit different templates without publishing them, the ability to turn on and off individual store pages of your site and much, much more.

Now that I’ve teased you a little with all the new features of Build A Niche Store, why don’t you download the pdf here and check them out for yourself.

Next week I’m going to get the ball rolling on one of my new BANS stores by buying the domain name and doing the preliminary set up just to see if I can get the site indexed in the 7 days before the release of version 3. If you already have version 2 of BANS, updating to version 3 promises to be a simple process and should take only minutes.

Get more info on Build A Niche Store.


Popularity: 5% [?]

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