• Marketing

    Excel Formulas to Extract Subfolder from URL String

    by  • September 25, 2016 • SEO • 0 Comments

    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(],FIND("/",])+1, FIND("/",], FIND("/",])+1)-FIND("/",])-1),"home") Using...

    Read more →

    Social Media Silos and PPC Landing Pages

    by  • July 28, 2009 • ppc • 0 Comments

    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...

    Read more →

    Stop The Bleeding: Google Affiliate Slap No More!

    by  • July 27, 2009 • affiliate marketing, ppc • 0 Comments

    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...

    Read more →

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

    by  • June 8, 2009 • Entrepreneurship, Marketing • 3 Comments

    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...

    Read more →