Creating Monster Advanced Drip Feed Blasts - Need Excel Help

Berto

Berto

Movin to TX
Jan 3, 2009
3,138
155
0
Proudly Incorporated in WY
wordai.com
Hey all,

I have a lot of URLs that I'd like to simply Drip on DripFeedBlasts on a daily basis. I don't want to deal with multiple campaigns (unless I force a 500-banger manually on certain days) - I just want ONE huge blast that I can keep modifying depending on what percentages of my links I'd like to spread around.

So I'm trying to create a spreadsheet, which is attached (Excel 2007 with macros format). I need some help though, because I'm NOT good at Excel and don't care to learn much.

How it works:
- Open it and enable macros.
- Enter your Spun URLs on Merging Blasts 1 through 100 (you don't have to fill all 100 columns, but that's the max)
- Enter the percentage you'd like that URL to get hit. The percentages must add to 100 or it will bark at you.

Moving to Berto Worksheet, here's what I do for you:
_ A greatest common divisor is calculated to simplify the # of links it makes
_ B7 through B106 will create your spun bbcode using the REPT (repeat) and CONCATENATE functions
_ It will all get concatenated in A109 using a function I found on the net
_ The final pipe will be removed in A112


PROBLEMS:
- Huge lists of characters don't work - CONCATENATE seems to get maxed out. Try doing 3 columns of URLs on the Merging Blasts sheet - one with 34%, the other two with 33. Each one will need to get listed 34/33/33 times. But columns B7, B8, and B9 all get truncated on the Berto Worksheet. Any workaround for this?

- My VB Script to do the Vertical Concatenation doesn't auto-refresh. You need to go into cell A109, go into the formula, and hit enter. I think this is because it's using Arrays. Any ideas for that?

- Again, there's a concatenation limit in cell A109 on Berto Worksheet. My Macro sucks, or CONCATENATE function sucks.


Can anyone help?

If not, I'm going to just make this a CSV file and do it in PHP and let you guys have that. I should have just done that in the first place, I'd be done and at the bar already.

File is attached.

THANKS!
Berto
 

Attachments



Berto said:
If not, I'm going to just make this a CSV file and do it in PHP and let you guys have that. I should have just done that in the first place, I'd be done and at the bar already.
Click to expand...

Yeah, fuck Excel. Here you go boys. Not heavily tested but seems to work well. Just edit MonsterDripFeed.csv and then run DripFeed.php.

See attached. It's well-commented.
 

Attachments

medway said:
Thanks for this, going to give it a shot.
Click to expand...

No prob. Worked great for me yesterday so let me know what happens.

Each 1% gets ~5 links on the 500 link package. I'm seeing that I'll need to upgrade to 1000 links/daily pretty soon, as I have too many pages that I want to nudge higher in the SERPs.

But over the course of time, leaving this MONSTER feed on will be nice so that if I forget to make any changes and go on vacation, I won't be throwing thousands of links at any one site. Just a nice spray.
 
I got this done in notepad with copy/paste... like he did in the Video Tutorial


Lol am i just too low tech?
 
Berto,
You lost me. How exactly do we use these 2 files? Any instructions would be most appreciated. Do we log into our DFB acct and then upload these into our acct, etc?
 
Edit the CSV and run it on a webserver. I use it locally on my apache, just have it in a folder and direct firefox to the PHP file. It spits out my spun stuff to the screen which I paste into DFB.

Now here's the problem I've experienced with this: The homepage links. The signature links work fine with these advanced scripts.

But right now there's no good solution of getting a random homepage link that is associated with its anchor, for whatever fucking xrumer reason. So I have it on "1st URL Heavy", and may consider going to "Generic anchor". But if you do the third option, it will just match ANY anchor to ANY URL in the entire thing when anchors are allowed in homepage links.
 
nice script, thank you.

my DFB account is not activated yet, so i dont know exactly how it works...
do your script also work with the 1000 or 2000 links package?
 
Berto said:
Now here's the problem I've experienced with this: The homepage links. The signature links work fine with these advanced scripts.

But right now there's no good solution of getting a random homepage link that is associated with its anchor, for whatever fucking xrumer reason. So I have it on "1st URL Heavy", and may consider going to "Generic anchor". But if you do the third option, it will just match ANY anchor to ANY URL in the entire thing when anchors are allowed in homepage links.
Click to expand...

That is just a normal software (xrumer) issue. (you get no better luck with ANY software that spins in 2 fields) You can't expect to spin 20 niches in two sections and expect Xrumer to know that links 2, 10, and 30 need to show when sig 2, 10, and 30 show. I mean... you probably could, some how..., but it would likely take way more work than is needed including sorting all your specific fields and such for the niches. No thanks, too much work for probably no difference.
 
070707 said:
That is just a normal software (xrumer) issue. (you get no better luck with ANY software that spins in 2 fields) You can't expect to spin 20 niches in two sections and expect Xrumer to know that links 2, 10, and 30 need to show when sig 2, 10, and 30 show. I mean... you probably could, some how..., but it would likely take way more work than is needed including sorting all your specific fields and such for the niches. No thanks, too much work for probably no difference.
Click to expand...

Thanks 07 - Yeah the DFB team has explained and fixed it as much as possible. I either do generic keyword or just go first link heavy and manually switch up the first link according to what needs the most juicing.

My method is working VERY well. Right now, I don't have any new campaigns/sites that need extreme blasting (2 new sites coming out this week though)... but I do have constant new inner-page content that needs indexed and a bit of juice.

After adding new content, I social bookmark them and give them about 5-15 xrumer links a day with my spreadsheet. It works, it looks natural, and it makes the domain look more pimp in general.

I drop it from the spreadsheet or put it down to 1% when it's at an acceptable place. So far so good.
 
trustadvert said:
nice script, thank you.

my DFB account is not activated yet, so i dont know exactly how it works...
do your script also work with the 1000 or 2000 links package?
Click to expand...

Yeah, all it does is make distributed spun BBcode... but note that 1% of 1000 = 10 links and 1% of 2000 = 20... not 5 like on the smaller package.

If you want to become more granular, then you can change up the PHP code for even smaller breakdowns. My script won't let you attack more than 100 different things as is, but would be easy to fix.

With my new campaigns coming out, I'll probably be upgrading my DFB account finally, and may expand this. If I do that I'll post new PHP code.
 
COOL TRICK FOR NEW CAMPAIGNS

So I just launched a new site/campaign. The home page is the money shot, but there are about 6 content pages that people search for too. So I made a well-distributed monster blast for it:

  1. Do your exact match keyword research - if using Adwords Keyword Tool, do an Export on everything and then sort by THE LAST MONTH'S SEARCH NUMBERS (unless this is a seasonal product and you know whats up)
  2. Pair your list down to the keywords you want to attack
  3. Make a formula that takes each keyword and computes its percentage: ie =C2/SUM($C$2/$C$30)
  4. Spread the love accordingly using my csv file :)
This is good because it looks natural. I'm not sending 500 links a day to the home page.

But for the home page xrumer option, I have it go to the first link heavy, which of course is my site's home page.

Enjoy!
 
couldn't edit above reply...

anyway, when i ran the php file in firefox, i got

$bbcode) { // For each line, repeat it by its percent divided by divisor for($repeater = 1; $repeater <= ($percentArray[$i]/$divisor); $repeater++) { $output .= $bbcode . "|"; // Note this is gonna leave one pipe dangling } } // Strip final dangling pipe from $output $output = substr_replace($output,"",-1); // Bingo, Bango, Bongo echo $output; return; // The following functions have been stolen from // PHP: gmp_gcd - Manual /* * function gcd() * * returns greatest common divisor * between two numbers * tested against gmp_gcd() */ function gcd($a, $b) { if ($a == 0 || $b == 0) return abs( max(abs($a), abs($b)) ); $r = $a % $b; return ($r != 0) ? gcd($b, $r) : abs($b); } /* * function gcd_array() * * gets greatest common divisor among * an array of numbers */ function gcd_array($array, $a = 0) { $b = array_pop($array); return ($b === null) ? (int)$a : gcd_array($array, gcd($a, $b)); } ?>
Click to expand...

any ideas on how to fix this?
 
oh... i tried to run it from my local computer, thinking that running WAMPSERVER can imitate running from a server

maybe i have got this all wrong
 
You must log in or register to reply here.
Top Bottom