So I have a few sites that use amazon ads for their mains source of revenue. http://rvgadgets.net is one and http://www.kidstoysquad.com is another. Now these sites are starting to pull in some noticeable income it has become apparent that I have not done a good job of using the correct amazon ads code.

If you are not familiar with what I am talking about here is the short and sweet of it. Amazon gives you a special code to use in any of your ad links or banner links. You get one main code something like code-30 and then you can setup as many as you like “under” that. You can run reports on each code. So normally you would have one code for each site and even a code for each format under a site if you wanted. It is a way to segregate your ads.

Well if you do not use the right code when you go an build your links then all of your referrals are messed up. You get reports that one site is sending in orders when that is not the case.

So what to do? You run some SQL on your database:

update ‘wp_posts’ set post_content = replace(post_content, ‘code-30’, ‘subcode-30’);

And everything is ok.. Well for the future at least.

No Comments
Uncategorized