Excel Formulas to Extract Subfolder from URL String

To assist in your backlink analysis. With backlink data, you can then determine which folders are most linked to and investigate why, potentially replicating its success. For these formulas to work, it’s best to “FORMAT DATA AS TABLE” in excel.

Using Google Webmaster Tools Data

=IFERROR(MID([@[Your pages]],FIND("/",[@[Your pages]])+1, FIND("/",[@[Your pages]], FIND("/",[@[Your pages]])+1)-FIND("/",[@[Your pages]])-1),"home")

Using MOZ Backlink Data


=TRIM(LEFT(SUBSTITUTE(MID([@[Target URL]],FIND("//",[@[Target URL]])+2+IF(ISNUMBER(SEARCH("//www.",[@[Target URL]])),4),LEN([@[Target URL]]))&"/","/",REPT(" ",999),2),999))

 

 

 

Google Chrome’s “Now Everywhere” Is The One Commercial To Rule Them All

Leave it to Google to prove TV commercials can be effective. The new “Now Everywhere” Chrome commercial, featuring Beethoven’s 5th Symphony, is whimsical, intriguing, and quite addictive. See for yourself below:

Continue reading Google Chrome’s “Now Everywhere” Is The One Commercial To Rule Them All

Build A Big Email List Without Going Broke (Or Spamming)

Having An Active Email List Makes Things Easier (not to beat them up)
Having An Active Email List Makes Things Easier (not to beat them up)

“The Money Is In The List”

Yeah, yeah… but how do you get a list?

Well, first of all, you dont “get” a list – I’ve tried, and it DOES NOT work.

If you buy a list, and decide to start emailing them offers, you will get a bunch of spam complaints and your account will be shut off.

So we BUILD a list – which is also not easy at all. Well, kinda…

If you’re running PPC, you should ALWAYS direct traffic to a squeeze page. That’s a given. If you’re using the viralurl software, the same concept applies.

“But I think direct-linking is much easier” – EHHHHHHHHH WRONG!

With direct linking, you get much more people to see the offer, but they’re not ready for it yet – except for your ad, they really have no idea what to expect. And those that do buy your stuff, wont leave their info so you can email them later to buy more stuff.

So always have a squeeze page somewhere. It doesnt have to be a plain old page like Eben Pagan originally came up with, but it could be a blog, or even a squidoo – as long as you can capture their data.

Here’s where it gets tricky. Even though you have tons of email fields everywhere, people are just not signing up!

Warm Them Up

Again, if people are not driven to take action, they wont. If you expect it to happen just because, it wont.

Not only that, but email has been so beat up that people go extra lengths to protect it, which forces you to be EXTRA good.

Solution? OFFER YOUR BEST! Yes, give them so much info, or such a good bonus, that they just have to sign up.

It’s that simple.

I may be talking out of my arse, one would say… but this guy is definitely not.

He built a 200,000 emails list and continuously make $300-400k out of it.

Forget what I said and go see what he’s saying.

Is ViralUrl Really Effective? Yes, Here’s How

ViralUrl email marketing is more than a lottery
ViralUrl email marketing is more than a lottery

Yesterday, I posted about how to get your ViralUrl email open, so today, I’m going to talk a little about how effective their email marketing software is and what you can to do explore it.

So when you have a ViralUrl gold account, you’re allowed to email 3000 other members randomly, every 3 days.

As I mentioned before, because of neon-marketers and the volume of emails sent daily, a lot of internet providers will bounce your messages before they even show up in their inbox.

So out of 3000 you may get 900-1200 emails delivered. It’s still a decent number.

What I’ve experienced since February, when I got my account, is that around 80-120 people actually open a ViralUrl email. Out of those, around 30-60 will click on your link – depending on how good your copy is and how reliable your link looks like.

It’s beyond this post to explain good copywriting, but you know how valuable it its. What I want to talk about is making your links look reliable. I’m going to show you how to transform your weird affiliate links like this one:

http://www.productlaunchformula.com/plmjd.php?1715

into something much more sexy like this one:

http://www.marketandconvert.com/socialpilot

1. Log Into your Cpanel

2. Click on Redirects

3. Choose PERMANENT 301

5. Choose any domain (that does not have WordPress installed)

6. Pick an extension (/something – relevant to the product)

7. Add your affiliate link to the box that says “redirects to”

And that’s it!

The best part about it is that if you have a domain that is closely related to the product, the link looks way more professional and clickthrough averages go really high.

If you want to try it out, go sign up for a ViralUrl account now.

Any questions or concerns, post your comments here and I’ll get to them asap.

See ya soon!

Free PPC Management (including Setup) for a Month!

Free PPC Management For A Month?
Free PPC Management For A Month?

I will make this quick ’cause I really need to get some sleep – George Brown has just launched the Google Sniper, a great course for folks trying to make it in affiliate marketing.

The course doesnt cost nearly a 1/3 of what I charge for my services (PPC management is about $897, in average), but I believe it’s such a good course I’m willing to put my little outsource staff to work for it. Plus, they really need the practice 😉

So you’re getting:

 – market and keyword research2 campaigns setupall the ad copyongoing split tests (including website optimizer) – and an entire month of optimization. And everything stays with you after 30 days, clean and profitable. All for $77 bucks!

I’d have come up with more appropriate bonus for this if I wasnt so lazy, but what the heck – I know it will be worth in the long run when folks realize PPC is not that difficult (or maybe I will lose potential clients… huh)

So if you’re trying to make your affiliate business work, get Google Sniper through this cleverly disguised affiliate link:

marketandconvert.com/sniper

Make sure you clear your cookies before you go to that page, or you may send the sale to another affiliate.

All you have to do after you buy it is post a comment here and I will get in touch with you to work out the details.

Social Media Silos and PPC Landing Pages

Weird freaking topic combination, isnt it?

But yeah, today I churned out a combination of these two topics, the first one at the YourIncomePotential, about landing pages and cheap ppc traffic, which is a continuation of the discussion about the google adwords affiliate slap.

I’ve had great feedback from the initial article about the affiliate slap, and now folks can see the basis of a highly-converting landing page.

And as I was reading about Social Media Silos, it struck me that most companies flush their social media marketing down the drain by failing to integrate departments and make them communicate.

A silly mistake that can cost thousands of dollars and waste considerable time, silos are the result of a poorly constructed social strategy. Companies that see a blog as another billboard are doomed.

Check out the material I published above, I’m feeling amazingly productive today and I’d appreciate your opinion.

Thanks.

Stop The Bleeding: Google Affiliate Slap No More!

Affiliate marketing is still hot.. who doesnt like a little slap?
Affiliate marketing is still hot.. who doesnt like a little slap?

When Perry Marshall posted Dr. Glenn Livingston’s email regarding the new Google Slap for Product Review Sites, several affiliates started reevaluating their operations.

Some decided to rely on technology (against Google?) and are investing on php and javascript cloaking for their affiliate links.

Google has made quite clear that they can crawl javascript links very well, and it’s only a matter of time until they get past any sneaky link defense left.

But marketers that are looking to build a solid business have decided to reevalute their sales process, and have been trying to figure out the best possible solution to clear the slap scars.

Much has been discussed, and Perry Marshall even held a teleseminar on the topic, but nobody has stepped forward with a proposed solution.

Well, I’m making my strategy to defeat the google adwords affiliate slap available, freely. No sign up required, no nothing. Enjoy it.

Actually, I do require one thing: POST YOUR COMMENTS HERE AFTER READING!

Thanks!

The Web 1.0 Corporate Website DeathTrap & How To Avoid It At All Costs

How To Avoid web 1.0 Traps & Monetize Your Website
How To Avoid web 1.0 Traps & Monetize Your Website

I’ve been working with a local gym introducing them to different ways of using the web as a communication channel and monetization opportunity.

Of course, the very first thing they asked was about Pay-Per-Click, to which I tried to explain (not successfully) that their beautiful corporate website would was not ready for it.

The reply was one I already expected:

“But the site looks awesome, I paid a lot of money for it!”

Yeah, I know.

They had a bunch of flash animations, amazing graphics, and a really kick-arse design. But the navigation was poor, there was very little content. But more importantly, if I were to use that for a PPC campaign, I needed a BRIBE and a CAPTURE FORM.

The owner looked at me like “Am I really paying you?

And the explanation that took me a couple of meeting to finally get him to understand was:

If you’re paying for traffic, you need to find a way to monetize those visitors.

Even if it means a simple data-gathering form.

What is the web 1.0 corporate deathtrap?

When that same business owner heard me saying that, he freaked out.

He was proud to have a cutting-edge website, and for him that was all that was necessary. But therein lies the trap:

Most brick-and-mortar business owners believe a website should be like the front of their store, and look pretty enough to invite visitors in.

But the fact is that the internet is the biggest, fastest-pace mall EVER. Online users’ attention span is minimal and they’re not attracted by looks only anymore. That was the web 1.0.

Visitors now want information, as they’re used to receiving it at an unbelievably fast rate from Google, Twitter, and many other sources. And making information attractive, educational, and satisfactory is key running a successful website and to widen a business’ communication channels.

Avoiding the web 1.0 Deathtrap

Get that expensive web designer of yours and feed him with everything that is going on in your business.

Tell him to update the site with a NEWS stream and publish press-releases-like messages (or even blog-posts-like) at least twice a week.

Instigate your visitor by publishing pictures, and videos on your website. But not studio pictures or professional videos: get somebody on your staff to take pictures of that special event or record a video of a class or seminar. It has to look real, not “made-for-tv”.

And that is just basic. To go one step further:

  • use the website to promote special events, and offer web-exclusive bonuses.
  • At specific events, record live customer testimonials
  • Start a blog: Let customers post their feedback.
  • Write an industry-specific ebook or record a video training and sell it on the website.

The web is the most effective communication channel a business can have, aside from personal interaction. It offers the most targeted advertisement platforms, and through the internet a business can uncover any market.

As long as top management is aware of it, a website will offer a ton of opportunities. But when management is stuck in the web 1.0, the best thing to do is introduce them to the information era.

I’ll keep you posted on our work as we move forward with the project.

If you’re a business owner looking for ways to establish a more positive online brand strategy, or you’re tired of paying good money for a website that is useless, post your question here (as a comment), and I’ll answer them.