Clean Up Those URLs

If you are running PPV, you are most likely scraping URLs. If you are scraping URLs, then you have probably wasted money on bad targets.  I certainly have.  Here’s a money-saving tip that will keep you from blowing through your testing budget bidding on google.com or answers.yahoo.com:

Go through your scraped URLs before you launch the campaign!

Scrubbing Bubbles

Nobody has cleaner URLs than this dude...

Yes, I understand that if you are targeting thousands of URLs, it can be time consuming to go through them one-by-one.  But here’s the trick: you don’t have to!  If you have your list loaded up in Excel, just press Ctrl + F to open up the Find menu, and then search for the usual culprits:

google.com, facebook.com, yahoo.com, wikipedia.org, etc.

Alternatively, if you are using AffExpert, you can filter these domains during the scraping process.  Just click the “Show/Hide Domain Filter” button on the URL Scraper tool, and it will open up a second box where you can put in the URLs you want to filter out.  Done and done.

So there you go, a simple tip that can easily save you $20 a campaign or more.

AffExpert > AffPortal (A Review)

AffPortal was the first “PPV Tools” website on the block.  It took a whole bunch of tasks that PPV marketers have to do on a regular basis, and made them faster and easier.  Things like URL scraping, etc.  Now that it’s been out for a while, a competitor has sprung up called AffExpert.  At first I was skeptical, because I am a huge fan of AffPortal.  But once I got the chance to dig in and use the tools during their free Beta period (which has expired), they won me over.

Most of the tools are self-explanatory by the title, but there are a couple of things that I really like about AffExpert’s system that make it unique:

  1. When you are scraping URLs, it automatically shows you the Alexa, and Quantcast rankings for all of them.  This is pretty cool because you can tell how much traffic a target is going to get before you even test it out on the PPV network.
  2. There is a really cool Basket system that you can save all the URLs to that you want to keep, and then download them all at once in one nice file.  This eliminates the all-too-common problem of duplicate URLs you get when you are scraping  through other methods, and it will also give you the option to add or remove the final slash (/) at the end of the URLs.  Since PPV networks like DirectCPV consider “domain.com” to be a different URL than “domain.com/”, this can be handy.
AffExpert URL Scraper

URL Scraper in action

Here are the PPV/CPV tools available:

  • Related Keywords
  • URL Scraper
  • Site Analytics (Alexa, Compete, Quantcast)
  • Domain Expander
  • Related Domains Finder
  • Top 1 Mil Domain Explorer
  • Domain Typos
  • URL Query Generator
  • YouTube Scraper
  • URL Follower

There are also some PPC tools:

  • Google Campaign Builder
  • Competition Spy
  • Adsense Finder
  • Keyword Grouper

There is also a self-hosted Weighted URL Rotator.  You can install this on your own server so you don’t have to worry about the data being snatched by somebody else (unless they have access to your server, and then you are just a moron).

I haven’t personally used the PPC tools much, so I can’t report on how they work.  That being said, it’s nice to get them for the one monthly fee, and if you are paying for another keyword tool that does the same thing, you can eliminate that extra expense and just use one tool set for everything.

All in all, I highly recommend AffExpert.  I use it personally on every PPV campaign I do, and it is a major time saver.  You can get a 7-day, fully functional trial for only $1, so what are you waiting for, give it a shot!

P.S.  Use promo code “BETAUSER” to get a discounted membership for life.