One Formula to Rule Them All: SEO Data Analysis Made Easy in Excel

Posted by Jeremy_Gottlieb

Working in SEO, I always find myself poring over data and looking for ways to expedite the analysis process. Analyzing data can often be tedious, mind-numbing, and boring work, so anything that can be done to speed up finding that needle in the haystack is almost always a good idea. A few months ago, I began using a formula in Excel to categorize data and I’m constantly finding new ways to use it.

It took a little bit of time and practice to remember the formula, to understand how it works and how to troubleshoot it if it breaks, but the time and energy put into learning it have been dwarfed by the rewards I’ve seen from employing it successfully. If you take the time to learn this formula, I promise that it will be worth it — you’ll easily be able to cut down thousands (or more) of rows in Excel into bite-sized chunks for easy insight-pulling and data presentation.

Without further ado, I present to you:

=if(isnumber(search(“string 1”, [beginning cell])),”Category 1”, if(isnumber(search(“string 2”, [beginning cell])),”Category 2”, “Other”)

I apologize if I’ve confused you already. I’ll dive into the formula deeper, explaining its meaning and … Read the rest

July 11, 2016  Tags: , , , , , , ,   Posted in: SEO / Traffic / Marketing  No Comments

One Content Metric to Rule Them All

Posted by Trevor-Klein

Let’s face it: Measuring, analyzing, and reporting the success of content marketing is

Not only that, but
we’re all busy. In its latest report on B2B trends, the Content Marketing Institute quantified some of the greatest challenges faced by today’s content marketers, and a whopping 69% of companies cited a lack of time. We spend enough of our time sourcing, editing, and publishing the content, and anyone who has ever managed an editorial calendar knows that fires are constantly in need of dousing. With so little extra time on our hands, the last thing content marketers want to do is sift through a heaping pile of data that looks something like this:

Sometimes we want to dig into granular data. If a post does exceptionally well on Twitter, but just so-so everywhere else, that’s noteworthy. But
when we look at individual metrics, it’s far too easy to read into them in all the wrong ways.

Here at Moz, it’s quite easy to think that a post isn’t doing well when it doesn’t have a bunch of thumbs up, or to think that we’ve made a horrible mistake when a post gets several thumbs down. The truth is, though, that … Read the rest

July 1, 2014  Tags: , , ,   Posted in: SEO / Traffic / Marketing  No Comments

Take the SEO Expert Quiz and Rule the Internet

Posted by Cyrus-Shepard

You are master of the keyword.

You create 1,000 links with a single tweet. You rank for the word “rank.” Google engineers ask for your approval before updating their algorithm.

You, my friend, are an SEO expert.

Ready for fun? Here at Moz we gathered our wits (it didn’t take very long) and created a new quiz to test our SEO knowledge.

Based on a quiz that our co-founder Rand first published back in 2005, at the dawn of electronics and lighter-than-air travel, we now present to you the new and improved
SEO Expert Quiz.

The quiz contains
50 questions and takes about 15 minutes to complete. The questions are randomized so no two people will get the exact same quiz with the same order of questions.

Here’s what to expect.

1. The quiz is hard! 

Like, astronaut training hard. Very few people score 100%. The breakdown of performance looks like this:

  • 0-40% SEO Newbie: You rank on page 7, but are aiming to move up.
  • 41-60% SEO Novice: Young, but strong in the ways of the Force, you are.
  • 61-75% SEO Pro: The traffic is pouring in!
  • 76-90% SEO Expert and Formula One race car driver
  • Read the rest

May 28, 2014  Tags: , , , ,   Posted in: SEO / Traffic / Marketing  No Comments

Testing the First Link Priority Rule

This post summarizes the results of a recent internal test conducted to understand how a website’s navigation menu affects the ‘First Link Priority’ rule. A method for avoiding the consequences of this rule was also tested with positive results. While these tests were in no way exhaustive, they do add to the body of evidence available on the subject.

Optimized anchor text has long been an important aspect of search engine optimization because it helps the search engines determine the relevance of the target URL. And while a good SEO link-building campaign can help you achieve better optimized anchor text, a natural backlink portfolio will often be less than ideal.

For this reason, internal linking is crucial. It allows you to tell search engines what pages you want to rank for a certain term. In order to make your internal linking effective, there is one very important yet often overlooked rule you should be aware of called the “first link priority” rule.

What Is the ‘First Link Priority’ Rule?

The “first link priority” rule is Google’s way of making sure a webmaster doesn’t add hundreds of anchor text links into the content of their website. Basically, when the search … Read the rest

July 9, 2011  Tags: , , , ,   Posted in: SEO / Traffic / Marketing  No Comments

The First Link Counts Rule and the Hash Sign – Does it Change PR Sculpting?

Posted by Marta Gryszko

Last year Rand Fishkin wrote about Link Consolidation as the new PageRank sculpting.

He said:

"Put simply, consolidation is the practice of minimizing the number of pages that are linked to by consolidating content onto fewer pages."

and showed us this scheme:

Link consolidation

Using this method helps you to reduce the number of pages you link to from 6 to 1. It is based on the assumption that Google will treat all of these urls as if they referred to the same page. For example, if you link to, Google will index and will ignore other signs in url starting from #.


OK, so now you have 6 urls referring to the same page. Remember the "first link counts" rule? It says that it such a situation Google will follow the anchor text of only the first link. Since now there have been at least 2 exceptions from this … Read the rest

August 5, 2010  Tags: , , , , , , ,   Posted in: SEO / Traffic / Marketing  No Comments

TechNetSource on Facebook

TechNetSource » Rule