TechNetSource

How to Build an Advanced Keyword Analysis Report in Excel

This post was originally in YouMoz, and was promoted to the main blog because it provides great value and interest to our community. The author’s views are entirely his or her own and may not reflect the views of SEOmoz, Inc.

Analyzing keyword performance, discovering new keyword opportunities, and determining which keywords to focus efforts on can be painstaking when you have thousands of keywords to review. With keyword metrics coming from all over the place (Analytics, Adwords, Webmaster Tools, etc.), it’s challenging to analyze all the data in one place regularly without having to do a decent amount of manual data manipulation. In addition, dependent on your site’s business model, tying revenue metrics to keyword data is a whole other battle.

This post will walk you through a solution to these keyword analysis issues and provide some tips on how you can slice and dice your data in wonderful ways.

With Microsoft Excel, we can create a report with all the keyword data you will need, all in one place, and fairly easy to… Read the rest

What is a Link Farm? [Video FAQ Series]

[jwplayer mediaid="21949"]

A link farm is a website with a high number of links to different websites with no relevance or category logic, grouping, organization, or relevance to the domain name.

If you land on a site and there are hundreds of links all over with many unrelated topics, you’ve probably landed on a link farm. Link farms ARE spam and will be considered as such by Search Engines. The key purpose of link farms are to easily and illegitimately send signals to search engines to assist in ranking.

A few important things to keep in mind when it comes to link farms:

If you’re using link farms in any way for your SEO, STOP! It will not serve your clients end goal to rank well and long.
If you take a client on or have a website where you find your website has somehow been included in a link farm take corrective action to be removed.
And most of all, remember that SEO is ALL ABOUT RELEVANCE. Links farms are the exact opposite of obtaining the correct relevance signals to rank organically. The best

… Read the rest

The Hidden Factors in Accomplishing Your Online Marketing Goals – Whiteboard Friday

Posted by randfish

In this week's Whiteboard Friday, we go underneath the surface and bring to light some hidden factors in online marketing. These often overlooked details can have a huge impact in helping us accomplish our goals as online marketers. Please enjoy and don't forget to leave your comments below.

Please note that we shot this week's Whiteboard Friday on a brand new video camera and we still need to work out a few kinks. I apologize for the slight purple tint on the Whiteboard.

Video Transcription

Howdy, SEOmoz fans. Welcome to another edition of Whiteboard Friday. This week I want to talk about the goals that we try to get people to accomplish on the Web, the things that we're trying to accomplish as online marketers, and what we're trying to optimize for, things like: click-through rate from search results; getting people to subscribe to RSS and e-mail; getting them to click links that are posted on social networks; getting them to share things

… Read the rest

Are Your Titles Irresistibly Click Worthy & Viral?!

Posted by evolvingSEO

The 80/20 Value of Titles

Recently, Rand did one of the best Whiteboard Fridays I've seen in a while (I do watch all of them) about increasing the likelihood of your content going viral. He touches briefly upon the importance of your title for click through rate and sharability, but in this post I'd like to take a more in depth look at titles and how they help spread your content. (By the way, this is my first YouMoz – woohoo!)

In my opinion, the elements of writing click worthy titles deserve more attention. In the wonderful marketing book "Made To Stick", the Heath brothers note that any good news or editorial writer may spend 80% of their time crafting the title (or "lead") and then whatever time they have left on… Read the rest

Find New Keywords: Simplifying Keyword Research

Posted by Karen Semyan

In December, we rolled out branded keyword rules and metrics to campaigns to help you segment your branded traffic. Now, we’re excited to introduce a companion feature to make your keyword research easier: Find New Keywords. With this feature, you can view keywords sending you organic search traffic, filter on your brand rules, and determine if you want to track them in your campaign.

First, the basics.

You’ll discover the Find New Keywords feature in a tab under your Manage Keywords section. (This feature requires that you connect your campaign to Google Analytics, so if you’re not connected to GA, you’ll find instructions on how to do this on the Find New Keywords tab.)

But wait, where did the Manage Brand Rules page go?! We’ve moved your brand rules page into a tab under Manage Keywords, as well, so you can easily move among these sections as you manage your keywords.

… Read the rest