PhpBay Pro Keyword Search Tricks

<Rant>
Well, I've said it before and I'll say it again.  PhpBay Pro RULES!   If you haven't already, check out my post where I talk about the great free PhpBay Mod I use for keyword tracking, “MUST Have PhpBay Pro Mod (FREE)“.  And, if you are still trying to create eBay niche stores with something besides PhpBay Pro then stop right now.  Forget BANS or any free eBay plugins that you might have found.  They are junk.  Go, check out PhpBay Pro now.
</Rant>

So, assuming you have PhpBay Pro now, let's talk about doing searches.  PhpBay Pro let's you narrow your search by many different ways.  One of the helpful ways (that many of the free eBay niche store plugins dont' do) is that it allows you to search on categories.  However, what if you need to search across multiple categories, but you want to return very specific items?

Here's an example, let's say there is an eBay category of 99999 (Random->Random Parts, let's say) under that are two other categories, 99111 (Random->Random Parts->Widgets) and 99222 (Random->Random Parts->Sprockets) and let's say you want to return both Widgets and Sprockets that are in Fine condition.  Well, you can't have multiple categories in PhpBay.  Well.. not exactly, but you can set 99999 as your category to search in and it will search through the child directories 99111 and 99222.  But, what do you put in your keyword field in the phpbay bbcode tag?  Well, this is where you get tricky with parentheses and pipe symbols.  Check this one out:
[phpbay] (widget|sprocket) (fine), , "99999"[/phpbay]

That will find listings that have the words widget or sprocket AND the word fine, in any order.

However what if you want to also display listings of multiple sprockets and widgets? Well, you could do something like:
(widget*|sprocket*) (fine)

but I think wildcards should be used sparingly. They can slow down your search or cause it to break outright. Why not just do:
(widget|widgets|sprocket|sprockets) (fine)

Anyway, if you do have PhpBay Pro, then check out this great PhpBay Forum post that talks about keyword tricks.

Step Three: You need Twitter (really?!)

So, it's been awhile but I'm back to documenting my process for creating new affiliate marketing sites.  This step might be optional if you are starting a Niche Store, but it's definitely necessary for community forum sites and blog sites.  Heck, I think it's necessary for any site if you want to get visitors right now.  I'll be honest with you here, I never really got twitter.  I mean, sure I had a Facebook account but that's about as far as I went with the whole social networking thing.  Twitter just seemed like Facebook, only with just the status updates and nothing else and that didn't make sense to me.  I figured it was something that teenagers were into.

Well, the truth is that twitter is an invaluable marketing tool for a few reasons.

  1. Google seems to really "love" Twitter.  So, if people are tweeting @you it's probable that Google could index Twitter and see these @you links pointing back to your twitter profile and then back to the site you are promoting.  So, having an active twitter following can really help with your search engine optimization.
  2. Heck, if you have a few thousand twitter followers then you'll get tons of traffic just from Twitter referrals.  This is nice if you've just launched your site and you are impatient.  That is to say, you don't want to wait around for 2 months for your organic traffic to start showing up.  Just build your twitter following and get folks visiting your site from the get-go.

There are three Twitter software tools that I can't live without.

  1. Bird Feeder - Bird Feeder is a miracle.  It makes it incredibly easy to build your Twitter following very rapidly.  Effectively, each day you can un-follow Twitter account who aren't following you back, then make sure you follow everyone who newly started following you and then you can follow new users (based on things like keywords searches, hashtags, who they are following, etc).  So, if your money site is all about doorknobs then you can follow users who use the word "doorknob" and then the word "vintage" or the word "antique" and not the word "sandwich".  Or, if you find another twitter user with 20,000 doorknob-loving followers then you can just follow his followers each day.   I'm only a few months into Affiliate Marketing but I already have a dozen twitter accounts each with 2000-3000+ followers.  I couldn't have done it without Bird Feeder.
  2. Twitter Tools Plugin for WordPress - Twitter Tools is a great free plugin for WordPress.  Basically, you can configure it to auto-tweet every time you post a new page or post in WordPress.  Conversely you could also have it convert your tweets into blog posts, but I don't really see the point in that.  Also, you can use the Twitter Tools sidebar showcase the last # of your tweets.  I dig that because I fee like if I tweet @someone or retweet them then I've also effectively posted a link to their twitter page (and hopefully their site) on my page.  So, it's a good way to help other folks out.
  3. TweetMeme Button for WordPress -  TweetMeme is that little green button in the upper right of this page.  It shows how many times your URL has been tweeted and it also makes it very easy for users to retweet your page, if they like it.

So, those are the Twitter software tools that I can't live without and why I think Twitter is an invaluable marketing tool.  In my next Affiliate Journal post, I'll talk about other WordPress modules that I can't live without.

phpBay Pro/ WordPress Search Mod

Alright Partner.  This is more talk about leveraging phpBay Pro to make money for you.  If, after reading my previous blog post, "MUST Have PhpBay Pro Mod (FREE)", you are still trying to create eBay niche stores with something besides PhpBay Pro then stop right now.  Forget BANS or any free-ebay plugins that you might have found.  You are just wasting time.  Go, check out PhpBay Pro now.

Now that you are happily cranking out niche stores like nobodies business you might be asking yourself, "Self, wouldn't it be great if people could use the WordPress search function on my site to actually search eBay directly".  That is to say, can we have the search results be presented from ebay auctions instead of links to pages/posts on your site.

Good news, it's wicked easy to do this.  Look for the search.php file in your theme and edit it.  (NOTE: I'm not sure how to make this work with themes that use searchform.php instead of search.php)

Now, look for the following code in your search.php:
<?php if(have_posts()) : ?>

Delete everything from this line up until (and including) the following line:
<?php endif; ?>

Now, in it the place of the delete code, enter the following:

<p align="center">Your search for '<strong><font color="#FF0000"><? echo $_GET["s"] ?></font></strong>' returned the following results:</p>
<p>
<?php
function phpBaySearch($term) {
$keyword = $term;
$category = "";
$text .= '[phpbay]' . $keyword . ',20,' . $category . ', ""[/phpbay]';
echo phpBayPro($text);
}
phpBaySearch($_GET["s"]);
?>
</p>

Save your new search.php and head over to your site. Type something in the search box and see the majesty and beauty of ebaby search results displayed real purty-like on your site!

I'm hoping to get Hanji, from money-code, into phpBay Pro and then I'm sure he can tell us how to modify themes that use searchform.php to do the same thing.  I'll also post a question in the phpBay Pro forums and I'll follow-up if I get any answers.

For what it's worth, though, if you are using a theme like Arclite that seems to use both search.php and searchform.php, then I've had good luck with

1) backing up the original search.php
2) copying index.php over search.php
3) editing the new search.php, removing the if and else statements related to have_post and replace that entire chunk with the phpBay pro code above

MUST Have PhpBay Pro Mod (FREE)

First off, If you are creating eBay niche stores and you aren't using PhpBay Pro then stop right now.  Forget BANS or any free-ebay plugins that you might have found.  You are just wasting time.  Go, check out PhpBay Pro now.  (Go ahead... I'll wait).  Ok.  Now that we are all on the same page, I'll get on with my story.

See, I was talking with Hanji (from moneycode.com) and he was asking me about the Custom ID capabilities of PhpBay Pro.  See, he's a genius who writes all his own stuff so he can do all sorts of cool tricks with PPC campaign tracking, and whatnot, using Custom ID with EPN.  He suggested that I look for a plugin or Mod for PhpBay Pro because surely someone else out there wants the functionality.  Sure enough, I found a great post by Anthony Wakefield on the PHPBay Forums.

Here's what his Mod can do for you:

  • Show you exactly which Search Engines & Search Keywords generate sales.
  • Show you what referring sites generate sales.
  • Incorporates the Previous '12th Parameter' Custom ID, so you can define this as you wish, and it's added on to the search engine and referrer info.
  • Track Adwords or other Ad Campaigns via a referring URL & 30 Day Cookie.

Using his Mod, you can download your Transaction reports from EPN (Make sure and download all events and keep it checked on All Programs) and you'll see the following format in your  Custom ID field.

[KW = Airport Express A1264] - [SRC = google] - [MED = organic]

KW is Keyword, & SRC is Source (ie. yahoo/google/msn)

If you've entered your own Custom ID field in the [phpbay] tag (although, if you had luck with this, let me know, I'm having issues) then you should see ad additional [CID = something] chunk in there.

To use Anthony's MOD you just need to edit your auction.php file.  This should be in the root of your site (it's one of the files you uploaded when you installed phpBay Pro).

Locate the following code:

$ktv["ccid"] = $_REQUEST["ccid"];

and replace it with:

#PHPbay CustomID Mod By Anthony Wakefield - Anteck On PHPBay Forums
# String Splitter
function strbet($inputStr, $delimeterLeft, $delimeterRight, $debug=false) {
$posLeft=strpos($inputStr, $delimeterLeft);
if ( $posLeft===false ) {
if ( $debug ) {
echo "Warning: left delimiter '{$delimeterLeft}' not found";
}
return false;
}
$posLeft+=strlen($delimeterLeft);
$posRight=strpos($inputStr, $delimeterRight, $posLeft);
if ( $posRight===false ) {
if ( $debug ) {
echo "Warning: right delimiter '{$delimeterRight}' not found";
}
return false;
}
return substr($inputStr, $posLeft, $posRight-$posLeft);
}

# If 12th Parameter Set, Format For Use In Referrer Custom ID
if (isset($_REQUEST["ccid"])) {
$PRESETCUSTOMID = $_REQUEST["ccid"];
$PRESETCUSTOMID = str_replace('_','-',$PRESETCUSTOMID);
$PRESETCUSTOMID = str_replace('/','-',$PRESETCUSTOMID);
$PRESETCUSTOMID = ' - [CID = '.$PRESETCUSTOMID.']';
}

# Google Analytics Cookie Extraction & Write-Out Referrer Custom ID
if (isset($_COOKIE["__utmz"])) {
$utmz = $_COOKIE["__utmz"];
$garef = '|'.$utmz.'|';

$source = strbet($garef ,'utmcsr=','|');
$medium = strbet($garef ,'utmcmd=','|');
$term = strbet($garef ,'utmctr=','|');

$searchstring = '[KW = '.$term.'] - [SRC = '.$source.'] - [MED = '.$medium.']'.$PRESETCUSTOMID;

# Filter Unfriendly URL Characters
$searchstring = str_replace('_','-',$searchstring);
$searchstring = str_replace('/','-',$searchstring);
$referrerinfo = $searchstring;
$adsearchkw = ' - [KW = '.$term.']';
$adsearchkw = str_replace('_','-',$adsearchkw);
$adsearchkw = str_replace('/','-',$adsearchkw);
}

# Check For Ad Cookie, If Exists Then Write Into Referrer CID
unset($i);
if (isset($_COOKIE["AdwordsID"]))
{$ADVERT = $_COOKIE["AdwordsID"];
$referrerinfo = '[AD = '.$ADVERT.']'.$adsearchkw.$PRESETCUSTOMID;
}
# Pass Referrer CID onto PHPBay CCID
$ktv["ccid"] = $referrerinfo;
# End Of Mod

But, Anthony isn't done yet. He also created a system for passing a URL Referrer which then turns into a 30 day cookie. This is a Theme Mod that sets the cookie and if you want to use it you need only to edit your header.php file in your WordPress theme.

What it enables you to do is pass a Referrer ID from your PPC link by appending ?ad=ReferrerID to the end of the URL. When you do this, a cookie is set on the users computer for 30 days. Now, if they come back to the site three weeks later and buy something, you can still see that they originally came in via that ad. Also, it will add the original search keyword used to find the PPC Advertisement.

Here's what some example output:

[AD = ReferrerID] - [KW = refurbished iphone 3gs for sale] - [CID = 32GB iPhone]

So, to use it, edit your header.php (or equivalent file) on your site and add the following code:


<script type="text/javascript">

function geturlvar( name )
{
name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regexS = "[\\?&]"+name+"=([^&#]*)";
var regex = new RegExp( regexS );
var results = regex.exec( window.location.href );
if( results == null )
return "";
else
return results[1];
}
</script>

<script type="text/javascript">

function Set_Cookie( name, value, expires, path, domain, secure )
{
var today = new Date();
today.setTime( today.getTime() );

if ( expires )
{
expires = expires * 1000 * 60 * 60 * 24;
}
var expires_date = new Date( today.getTime() + (expires) );

document.cookie = name + "=" +escape( value ) +
( ( expires ) ? ";expires=" + expires_date.toGMTString() : "" ) +
( ( path ) ? ";path=" + path : "" ) +
( ( domain ) ? ";domain=" + domain : "" ) +
( ( secure ) ? ";secure" : "" );
}

</script>

<script type="text/javascript">

var adwordsurlref = geturlvar( 'ad' );
if (adwordsurlref>""){Set_Cookie( 'AdwordsID',adwordsurlref , 30, '/', '', '' )
}

</script>

There ya go! I just added mine yseterday so I can't wait to look at my EPN Transaction report today. I'll follow-up with you all once I do, though.

Also, as I mentioned before, this Mod is FREE, but Anthony certainly spent some time on it. If you use it and find that it's working well for you, and saving you some time, please consider a Paypal donation. Heck... just buy the guy a beer, right? "payments at anteck.com.au" is the e-mail address you can use to send a paypal donation to him. (just replace " at " with "@", I didn't want him to get spam harvested because of my post)

NOTE: If this formatting is weird for you, then just head over to http://www.phpbay.com/forums/showthread.php?t=3148 to see Anthony's original forum post.

Picking a niche for your niche store.

So, I've made a handful of niche stores so far.  At first I was using a free WordPress plugin but I got tired of not being able to search by category, minimum price and so on.  So, I finally bit the bullet and bought Phpbay Pro.  It was $79 and that's a chunk of change, but you can use it on unlimited domains and it's free upgrades for life.  Besides, my time is valuable to me.  So, if I can make more niche stores in less time then it's completely worth the $79.

NOTE: If you do buy Phpbay Pro (or you already have it) something that isn't really in the manual is that you can have multiple keywords by using the "|" pipe character.  So, if you put in "doorknob handles hardware" in for a keyword in Phpbay Pro, you are actually looking for that exact phrase.  That might not be what you want.  You are probably wanting this instead "doorknob|handles|hardware".

Anyway, on my previous niche stores, I picked things that I was already into.  But, these things aren't necessarily good subjects for niche stores.  That is to say, I wasn't doing any research, I was just picking out of a hat, effectively.  What you really need is a way to see what people are looking for on eBay.  Now, there is eBay Pulse,which is pretty cool, but it seems like you can only see hot searches one category deep (unless I'm just missing it somehow).  Also, I don't know how far back the data goes on eBay Pulse.

So, after a little bit of digging around, I found TeraPeak.  They have over two years of eBay research data and you can use it for all sorts of purposes.  That is to say, if you are an eBay seller (as well as an affiliate marketer) then you use their data to know when to sell on eBay. I recently searched 90 days worth of auctions to find the best time of day and the best day of the week to sell some of my old HP DL320 servers.  You can find the best time/date for sell-through percentage or highest price, or try and find a balance of the two.  It's great for this!

But, I think for something like $5 you get access to all the search data as well.  So, now you can look for hot categories, hot searches, hot products, etc.  And you can drill down by category.  So, yesterday I used it to search something like 5-6 categories deep to find the searches that people are most often typing in a particular category.  Then I can create pages using Phpbay Pro where I use those popular search keywords to display auctions related to those searches.  The users dig it because now they can find what they are most likely to be searching for with just a single click.

Still not convinced?  Believe me, I get.  It seems like there is so much software to buy out there.  But, in my opinion, TeraPeak and Phpbay Pro are worth it.  Your niche stores are going to be quicker and easier to build and your niches should be more lucrative if you do the research up front.  But, if you want to see it in action, check out the Terapeak eBay Demo Videos.


Find hot products to sell on eBay

Google Adsense Filtering

Don't be alarmed.  You didn't miss Step 3 in my process to turn up new affiliate sites.  This is just a little side-trip on our journey.  You see, one of my sites relies on user-submitted content and I'm trying to monetize the site using Google Adsense (pretty much exclusively, although some direct ads might be nice as well).  Anyway, because of the way I was displaying the content and the fact that much of the user-submitted text is pretty brief, the adsense ads being displayed weren't really on target for what the site's readers would be into.  Hank, over at money-code.com, mentioned that he thought there were some filtering options at Adsense, so I stumbled over there to make sense out of it.

Turns out... it's pretty neat!  There appear to be two basic kinds of filtering: Competitive Ad Filtering and Category Filtering.

You can get to Competitive Ad Filtering by going to "Adsense Setup"->"Competitive Ad Filter" on the Adsense site.  From here you can filter your ads by the domain they are advertising.  So, if your vintage doorknob niche store has some adsense on there, you can block joesvintagedoorknobs.com's ads from showing on your page.  This is interesting enough, but it's not really what I wanted.  So, I headed over to Category Filtering.

Category Filtering can be reached from "Adsense Setup"->"Ad Review Center".  Here you can filter your ads by category, which is neat.  But, what's cooler is that you can see what percentage each category makes up of your earnings.  It looks like it's more of a snapshot than anything, but it's still interesting.  Especially because one of the things I was going to filter, weight loss ads, turns out to do pretty decent.   For me it was like 4% of my recent impressions but 6% of my earnings.  The other biggies seemed to be "Sexually Suggestive", "Politics" and "Video Games".  Huh?  Politics?

I'm not sure I would filter based on earnings percentage, though, just because these numbers seem pretty dynamic.  But, if Dating is at 5% impressions and 0% earnings over the next few days, I might consider it.  The other bummer is that I don't think you can filter per channel, it looks to be per Adsense account, which is a pretty broad brush to paint with.

The last thing I noticed on this page was "Allow and Block Google Certified Ad Networks".  Hmm... I'm certainly not an expert, but I had never heard of this before.  Apparently by allowing this you can accept non-Adsense ads to be delivered via Adsense.  At least, I think that's what I'm reading.  It certainly seems like a good idea to me so I'll enable that today and let you know how it pans out.

So, back to my story.  Last night (when I first discovered all of this), I wasn't sure which category I should filter to get rid of my "Quit Smoking" ads, so I decided to sleep on it.  But, what's interesting is that yesterday I also completely changed the format of the site in question.  Now, on the main page, I'm displaying 9 user-submitted pictures and excerpts of text (instead of just the latest one) and my targetting problems are solved.  Turns out that this is just enough text to get me the types of ads that my readers are more likely to click.  So, while my Adsense Filtering adventure was fun, it appears that I don't need to do any filtering after all.  Once again, it all comes down to content!

Okey dokey, that does it for my rambling thoughts on Google Adsense Filtering.  Let me know if you have any other good tips or tricks or further clarification.

EDIT: So, I was reading the Google Certified Ad Networks section wrong.  The default is "0 Google certified ad networks always blocked"  So, you get all those ads anyway.  You can opt-out, if you want, but I'm not sure why you would want to.  I also don't know what it was so hard for me to read this correctly the first time.

Step Two: Where to host your new site?

So, last week, in my post, "Step One: You need a domain, right?", I talked about how to minimize your spending when getting your hands on some choice domains.  That's all well and good, but now that you've got these domains, you need somewhere to host these sites, right?

My background is 15+ years in Cisco and Linux consulting so I already had quite a few servers on hand that I could have used to host my new affiliate marketing sites.  However, I chose not to host it on my existing servers.  Why?  Good question!

My existing servers are dedicated physical boxes on which I have root access.  They are very locked down and secure and I audit any and all code that I run on these servers.  I use them for hosting client's websites and typically these are websites that my company (through my brilliant development guy) has created for them.  I wouldn't say that I make any money on the actual hosting, but I definitely break even.  But, it's more important to me that I control the development environment and that I provide them reliable hosting of their site.  Let's say that we developed a site for them and they chose to host that with Joe Schmo's hosting.  Well, if they have a negative hosting experience, they are likely to attribute that (unfairly, maybe) to my company.  I don't want that to happen.

So, since these servers are so locked down and reliable, I want to be really careful about what software I run on them.  And, let's face it, if you are turning up a handful of affiliate sites a month, you aren't as focused on security as you are on QUICK.  You need to turn up sites now.  Now, while there are lots of great content management systems for this (Drupal, WordPress, etc).  I wouldn't exactly give them an A+ when it comes to security.

What would happen if your Vintage Doorknob niche store (running on an outdated WordPress, because you are too dang busy) get's hacked and now your paying web clients are also compromised.  You can't have this happening.  You don't want to risk this steady hosting income because you got sloppy.

But, you NEED WordPress, Joomla or Drupal!  Heh.  That's where Host Gator comes in!  For a meager $7.95/month (on their "Baby plan") you can have:

  • Unlimited Disk Space
  • Unlimited Bandwidth
  • Unlimited Domains

I challenge you to find more affordable hosting.  It doesn't exist.  (but, if you find, it lemme know).  What I love about Host Gator is how quickly I can setup new WordPress sites using Fantastico De Luxe.  It's pretty much the software equivalent of those tiny elves that fix shoes.  Only, they are making WordPress sites for you... not shoes.  C'mon.  Keep up here.

Once you sign up with Host Gator it wouldn't be a bad idea to create some sort of backup/restore plan.  Just because of the cost of the service, I wouldn't be surprised if some of their other clients are less than reputable.  So, you have to be prepared if someone from the Russian Business Network seizes the entire shared server or something else terrible happens.

I use Automysqlbackup to backup all my MySQL databases onto an off-site server and I use BackupPC to backup all of my public_html directory from Host Gator.   This way, if the unforeseen happens, I can quickly get my sites up and running again on another server.

Now, I don't want to scare you.  I just want you to be prepared.  You need to minimize your overhead and $7.95/month hosting for ALL of your affiliate sites is a no-brainer!  Hosting them anywhere else just doesn't make sense.  Order your Host Gator hosting today!


Step One: You need a domain, right?

Let me begin by saying that I'm not an expert affiliate marketer, I'm just starting out, but I wanted to share what I'd learned so far with the hopes that a) some experts might chime in and hit me with the clue stick and b) I could help someone else who is just starting out like me.

So, I've written up a little checklist for myself to follow, every time I add a new website.  And I'm going to work through that over the coming weeks.

The first step is "Think of a domain name, dummy".  One thing that I often do if I'm drawing a blank is use the Google Adwords Keywords Tool.  For this example, let's assume that I want to make a niche store for doorknobs.  So, I might type in "doorknobs" or "buy doorknobs" and leave "use synonyms" checked.  Then I sort the results by "Local Search Volume".   For the "doorknobs" keyword, there were something like 300,000 searches in September alone.  You are never going to be able to crack that one.  But, hay, look at "antique door knobs", there are 14,800 searches in September for that keyword.  That seems like something we might be able to work with.  So, then I try to incorporate those keywords into my domain name.

Once you have the domain name you want, you need a domain registrar.  I used to use Dotster for this and I have no problems with them at all.  They've been very easy to work with, but I needed to find the cheapest registrar out there if I was going to be registering dozens of domain names.    That lead me to the World's Largest Registrar - GoDaddy.com.

Go ahead, search to see if your domain is available:

Find a domain name now!

.com .us .biz
.info .net .org
.ws .mobi .me .co.uk
.in .at
.asia

If the domain you wanted was taken, you always have the option to Backorder Domains but that hasn't ever really worked out for me. I'd just look for another good domain name and keep moving forward. You don't have time to wait and you should be trying to spend as little as possible.

Speaking of spending as little as possible.  If you think you are going to get pretty gung-ho on affiliate marketing, then you should consider using Go Daddy Bulk Domain Registration or the GoDaddy.com Discount Domain Club both of them can save you money if you are doing a handful of domains.  I think the Discount Domain club costs about $81-89/year (depending on your commitment) but the domains are deeply discounted.  I did some quick looking at it looks like it would take something like 23 .com domains to see the break-even point.  So, keep that in mind.

Ok.  So, now you have your domain name.  In Step Two, we'll talk about your hosting options.


Go Daddy $7.49 .com domains

Affiliate Marketing – The journey begins

The journey begins, alright.  Just hopefully not into the "dark side".

Howdy all, I am a 15-year sysadmin with a strong focus in Cisco and Linux.  I recently decided to get my feet wet with affiliate marketing and this blog is going to document my journey.  I imagine being beset by many dangers and hidden evils as I try not to lose my soul.  Maybe documenting this process will help me to hang to my morals as well.