Tool to prune PPV URLs?

E

envision

New member
Jun 5, 2008
210
6
0
The length of URLs to be used in most PPV networks is limited to 40 or 50 characters. If you want to target specific pages on a large site, this can be limiting:
example.com/archive/2009/11/?storyId=123456​
The 40 character limit cuts this to:
example.com/archive/2009/11/?storyId=123​
To get the full story ID, I offset the taget:
mple.com/archive/2009/11/?storyId=123456​

Sometimes, I select a piece from the middle so it catches parts of the domain and parts of a pretty permalink:
largesite.com/entertainment/2009/11/04/The-Quick-Brown-Fox​

But doing this for hundreds of URLs manually is too tedious. Is there a software that makes this shifting easier? Something that let's me select the segment with the mouse or some kind of intelligent algorithm and saves a 50 and 40 character version along with the original URL?
 


What is the point anyway. You get almost no traffic for bidding on long tail urls.
 
^^ this ftw, however I can say... even though you wont get a lot of traffic, if you hit the right long tail you can get some epic epc's and conversions if you twist it right.
 
eliquid said:
^^ this ftw, however I can say... even though you wont get a lot of traffic, if you hit the right long tail you can get some epic epc's and conversions if you twist it right.
Click to expand...

yea, I definitely agree with this, I have some obscure long tails that convert at like 65%
 
envision said:
The length of URLs to be used in most PPV networks is limited to 40 or 50 characters. If you want to target specific pages on a large site, this can be limiting:
example.com/archive/2009/11/?storyId=123456​
The 40 character limit cuts this to:
example.com/archive/2009/11/?storyId=123​
To get the full story ID, I offset the taget:
mple.com/archive/2009/11/?storyId=123456​
Sometimes, I select a piece from the middle so it catches parts of the domain and parts of a pretty permalink:
largesite.com/entertainment/2009/11/04/The-Quick-Brown-Fox​
But doing this for hundreds of URLs manually is too tedious. Is there a software that makes this shifting easier? Something that let's me select the segment with the mouse or some kind of intelligent algorithm and saves a 50 and 40 character version along with the original URL?
Click to expand...

I use excel...made a spreadsheet that does this automatically. My version deletes the ones that are 40+ but I'm sure that you can find/make something that takes the middle or beginning 40 letters.

Here's the setup for mine:
Insert URL's in first column
Second column =IF(A2="","",LEN(A2)) ----This gives the length of the URL.
Third column =IF(B2<=40,A2,"") ----If URL more than 40, delete
Fourth and final column =IF(C2="","",C2) ----cleans up the URL's for easy pasting

Excel = awesome, I'm sure you can find something for your purpose on there.
 
If you want to do this in PHP, you can do it with this:

HTML: 
<?php

// the string that comes in, change to a $_GET or $_POST if you want to grab from a form
$data = "url.com/filling/the-uirlsskldhasdadlihalkfhalkh,example.com/djfghskjdfghskjdgf/,http://www.example.com/kjhdfkjshdlkjfbsdjkfskjdfs,http://www.wickedfire.com/affiliate-marketing/88455-tool-prune-ppv-urls.html";


//$array = explode(",",$data);

// how long is the max length? if set to 0, it will ignore and strip normal prefixes
$max = 40;

// uncomment below to look at the raw array if you need it
//print_r($array);
//echo "<br />";

// set the integer value
$i=0;

// replace prefixes, add another one here if you want to the array $replace
$replace = array(
	"http://",
	"www.",
	"https://"
);

$array=str_replace($replace,"",$array);

// output string for the cleaned stuff
$output = "Cleaned URL's:<br />\r\n";

// while the integer is less than the number of url's, go ahead and clean it up
while($i<=count($array))
{

if($max>0) // this is if we have a max value to work against
{
if(strlen($array[$i])>$max) // if the length of the url is more than the max
{
echo "Over 40! - Lenth = ".strlen($array[$i])." - "; // tell us about the url
$over = strlen($array[$i])-$max; // calculate how much over it is
echo "Over# $over - "; // tell us how much over
$array[$i] = substr($array[$i],$over); // cut the string down to size
echo "Value: ".$array[$i]."<br />"; // tell us the string for reference

// add to the output string
$output .= $array[$i]."<br />\r\n"; // add it to the output
}
else // looks like it isn't over
{
echo "Value: ".$array[$i]."<br />"; // tell us the string
// add to the output string
$output .= $array[$i]."<br />\r\n"; // add to the output
}
}


$i++; // increase $i by one for the loop
}

echo "<br />".$output; // HIT THAT SHIT

You could input any comma separated values in the $data variable up above, or even set up a form submit or something. Go nuts. Hope this helps :)
 
DirSP said:
What is the point anyway. You get almost no traffic for bidding on long tail urls.
Click to expand...
You keep on believing that. I'll go with eliquid:
eliquid said:
... even though you wont get a lot of traffic, if you hit the right long tail you can get some epic epc's and conversions if you twist it right.
Click to expand...

Thanks for the replies.
I've played with Excel too, but found it too limited. Maybe I experiment with the PHP a bit more. Ideally, this should work like this: Set the character count, have the software take a shot at finding the best clip (not always at the very end), then use the mouse and just move the clip (the yellow part from my example) left and right to adjust.

Not something PHP could do alone, would need a lot of JS too. Or maybe that's a good opportunity to finally learn some Objective-C. Been wanting to get into Mac programming for a while.

m0rtal said:
Affportal
Click to expand...
Can Affportal do something like this out of the box?
Or any other software?
 
It's pretty limited but it pretty much does exactly what you want it to in your OP, taken right from the site too lazy to take a screenshot for you:

Shrink to max length of 40 characters - LEFT to RIGHT
Shrink to max length of 40 characters - RIGHT to LEFT
Shorten to root url then remove duplicates
 
on a related questions does anyone know how trafficvance does matching ie

is

site.com/page/ and site.com/page/query going to match site.com/page/query?blah=hi

if not is there a wildcard? Also how does impression capping work when you have site.com and site.com/page/ both targeted? If they hit for site.com will they then not hit for site.com/page/ ?
 
ive talked to Ladan before and my impression from our talk was it is exact match URLs only, no wildcards and no matching partial if you put in a full url string
 
conv3rsion said:
on a related questions does anyone know how trafficvance does matching ie

is

site.com/page/ and site.com/page/query going to match site.com/page/query?blah=hi

if not is there a wildcard? Also how does impression capping work when you have site.com and site.com/page/ both targeted? If they hit for site.com will they then not hit for site.com/page/ ?
Click to expand...

eliquid said:
ive talked to Ladan before and my impression from our talk was it is exact match URLs only, no wildcards and no matching partial if you put in a full url string
Click to expand...

Pretty sure it's broad match. Use it to your advantage, that's all I'm gonna say. I don't like where this thread is going...keep it on topic, shortening urls, yes!
 
envision said:
You keep on believing that. I'll go with eliquid:


Thanks for the replies.
I've played with Excel too, but found it too limited. Maybe I experiment with the PHP a bit more. Ideally, this should work like this: Set the character count, have the software take a shot at finding the best clip (not always at the very end), then use the mouse and just move the clip (the yellow part from my example) left and right to adjust.

Not something PHP could do alone, would need a lot of JS too. Or maybe that's a good opportunity to finally learn some Objective-C. Been wanting to get into Mac programming for a while.

Can Affportal do something like this out of the box?
Or any other software?
Click to expand...

Good luck with spending that $100 in a week. It'll make a nice change. If you know how their bidding system works then you'll know why there is no volume and not worth the hassle (at less for the volume people).


conv3rsion said:
on a related questions does anyone know how trafficvance does matching ie

is

site.com/page/ and site.com/page/query going to match site.com/page/query?blah=hi

if not is there a wildcard? Also how does impression capping work when you have site.com and site.com/page/ both targeted? If they hit for site.com will they then not hit for site.com/page/ ?
Click to expand...

if you goto site.com/page/query?blah=hi it will match all 3. The highest bid is site.com/page/ and it will get first impression. Different keyword so you'll get 1 impression each if you have 1/24.
 
I might be wrong on the URL matching, again my impression was it was exact match.

However, I do stand by long tail URLs though. There are drawbacks for sure and it will take some time to use up your spend ( depending though ).

One of the reasons I do long tail is:
1. Less competition and less bidding wars.
2. I can really hone in my LP more then if I just bid on yahoo.com or forums.singlesnet.com
3. I generally like having more control of my spend and variables, then realizing I fucked something up after 5 minutes of launching my campaign and pausing it, only to find out I already spent $700 in that 5 minutes.
4. Less people ( affiliates ) seeing my campaigns and stealing them

Drawbacks? plenty..
1. Way less traffic ( depends on how many urls you bid on though )
2. More time until you find statistical relevance
3. Longer time to make big bucks

I find that with longer tail URLs, I myself do pretty good conversion wise/ROI wise. Again, peoples mileage will vary, but I like having several campaigns that only spend like $10 a day each, but make about $200 a day each Net without having to go through 10 sales funnels. Its just my preference though. That's just how I got PPV to work for me, the way I do FB/POF ads or Adwords is totally different and I like hitting the broader KW's and demo's on those platforms.

Some people can do well on the broad URL's, Ive seen them do it and it works for them. But with PPV I like to keep it simple and small and run several long standing campaigns that last for month and months ( got several running solid for over 18 months now )

I would suggest testing it and seeing what you like doing and how you like it.

Just dont ONLY do PPV, spread some of that shit out to FB and Adwords and MediaBuys. PPV is just a traffic source, not a holy grail.

Since PPV isnt my only traffic source, I dont mind doing long tail URLs, setting it, and forgetting it mostly. Its one of the few platforms I can automate 100% and then let it run for 5-6 days with no worries pretty much. Bidding on those long tails is almost like passive income on the side while I focus on FB/POF and Adwords.
 
You must log in or register to reply here.
Top Bottom
Back