1. 116 points via ChrisLDyson on Feb 11 2012  Flag    12 comments
    12 DISCUSSING
  • Chris Dyson   Feb 11 2012   Flag

    I know this is quite an old article but it's a great reference point for all SEO's/PPC/Analytics marketers and therefore deserves to be re-shared.

  • Michael J. Kovis   Feb 15 2012   Flag

    Old maybe, but still filled full of awesome! I had actually been looking for this article to reference a few things recently. Glad it popped up here! Funny how that worked out. :-)

  • Jonathon Colman   Feb 11 2012   Flag

    One of the all-time greats! I use something from this every day.

  • Neil Maycock   Feb 11 2012   Flag

    Great post Chris

  • Gael Breton   Feb 11 2012   Flag

    One of the most actionable piece of content for seo out there ;) with the google docs one.

  • Mike Pantoliano   Feb 12 2012   Flag

    Aw shucks. This old thing? :)

  • Dawn Wentzell   Feb 12 2012   Flag

    I still need to spend some time with this post. A lot of time, actually :)

  • Ken Wohl   Feb 12 2012   Flag

    This is really helpful. Lots of things I need to refresh on here. Thanks for finding and posting.

  • Tommy Swanson   Feb 13 2012   Flag

    I don't see this in there, but there is a better way to segment brand v. acquisition. =IF(ISNUMBER(FIND("beginning of brand keyword",A2)),"Brand", "Acquisition") Using the beginning of the brand keyword will help capture any misspellings.

  • Amit Yarashi   Feb 15 2012   Flag

    Wow. Cool post Chris, Learn't a lot in excel after studying your post.

  • Minh Nguyen   Feb 25 2012   Flag

    This is simply a great post I've used a lot to train interns. A valuable resource/gem.

  • PurposeAd   Dec 29 2012   Flag

    We built an Excel a few years ago that we used to Concantenate prefixes and suffixes to root keywords for both SEO and PPC keyword research. We then built a PHP app that does it faster and easier. Check out this little app and feel free to use it: http://www.purposeadvertising.com/concatenate.php?act=go

You must login to post comments.