Home  › Search › SEO
spreadsheet-excel

SEO Number Crunching – 5 Great Excel Features

  |  July 23, 2014   |  Comments

Excel includes several features that can be very useful in improving SEOs' efficiency and can also enhance their ability to analyze relevant site performance data.

Excel is one of the most diverse and widely used tools in managing data because so much can be accomplished with this single tool. For example, there are people who are able to create entire infographics, games, and even programs using only Excel. Have you considered how it can be utilized to improve SEO? Here are some examples of how that can be accomplished using bot native formulas and tools as well as an extension that makes Excel even more powerful.

Specific Tasks: Formulas for Beginners

The key to using Excel successfully is applying the right formula to the right data set. Excel can be used in a variety of ways, but the formulas are by far the most-used feature. Sometimes the Excel formulas may seem to be very complex. In truth, some are, but don't be intimidated. That built-in complexity offers a savvy SEO significant power. Here are a few formulas that can be really useful for SEO analysis:

1. LEN

Action Performed: Returns the number of characters in a cell.
SEO Application: It's particularly handy in creating the right title and meta descriptions that meet the search engines' character counts.
Example » =len(A1)

2. CONCATENATE

Action Performed: Allows you to combine data from multiple cells. The text items can be text strings, numbers, or single-cell references.
SEO Application: A good use of it would be to create phrase match and exact match generator keywords. Another good use would be constructing large numbers of URLs for new content.
Example » =concatenate(A1," ", A34," ", B5)

3. IF

Action Performed: The IF function is a simple logic test. If the result of that test is true, do something. If the result of that test is false, do something else.
SEO Application: A good application of this function lies where the filters can't do the job. For example, perhaps you need to verify if a 404 error page (URL) is from a particular country site. Or perhaps verify if a PDF file and if has pageviews between 1,250 and 15,000. The IF function can find these answers for you.
Example » =if(A1 > 10,"do something if it is true", "do something if it is false")

4. LOWER

Action Performed: Convert texts in a cell into lowercase letters.
SEO Application: It can be handy to fix keyword lists exported from different sources with malformed words. It could also be useful in modifying large numbers of URLs with upper- and lowercase letters.
Example » =lower(A1)

5. VLOOKUP

Action Performed: The Vlookup is one of the most powerful functions in Excel. It allows a user to do a vertical lookup to find a value in a range or cells.
SEO Application: For example, it can be used pull search volume data from AdWords report and aggregate it into another report to project the traffic based on the rankings.
Example » =vlookup(A1,A1:C29,2,true)

Broader Utility: Beyond the specific formulas discussed, Excel has some broader uses that make it useful for SEO.

Manage Large Amount of Data

Excel is an excellent tool to use when dealing with large amounts of data. It provides an extremely useful feature called a Pivot Table. It is perfect to summarize, analyze, explore, and present summary data.

The Pivot Table is not the only feature in Excel that can perform this function, but it is the fastest way to break down the data into smaller data segments easier to deal with later.

A Pivot Table report is useful when analyzing related totals, especially when managing a long list of figures to sum and you want to compare several facts about each figure.

Additional Features: Extensions

In addition to the various features Excel has to offer, there are some additional tools to speed up the process. In Excel they are called add-ins.
One very popular SEO add-in for Excel is the SeoTools created by Niels Bosma. It is an Excel add-in that adds a bunch of useful functions for working with SEO and other Web metrics directly in Excel. This add-in can save a lot of time gathering data from different sources. One of the best features is the fact that it allows you to create custom SEO scorecard/report, which provides a succinct status report on your site's performance.
The installation is very simple. It doesn't cost anything. Totally free.

Conclusion

In summary, with a bit of training and experimenting, Excel offers some very useful features that can improve an SEO's efficiency, as well as greatly enhance the ability to analyze data relevant to a site's performance. What do you think? What are your favorite Excel tools/tricks that you use related to your site's optimization?

Image via Shutterstock.

ClickZ Live Chicago Learn Digital Marketing Insights From Leading Brands!
ClickZ Live Chicago (Nov 3-6) will deliver over 50 sessions across 10 individual tracks, including Data-Driven Marketing, Social, Mobile, Display, Search and Email. Check out the full agenda, or register and attend one of the best ClickZ events yet!

ABOUT THE AUTHOR

Crispin Sheridan

Crispin Sheridan is the Senior Director, Global Search at SAP. As part of the digital team, he established and leads the search and testing practices at SAP. Crispin is responsible for paid, natural, and mobile search and all online testing. Search and testing at SAP are fully centralized and globally funded and run under a hybrid in-house and agency model.

Crispin has proven that search learnings and keyword insights work hand in hand with social media marketing and together can effectively drive B2B lead generation. Furthermore, the development of the SAP.com Test Lab has contributed significant success to SAP's digital marketing efforts.

A frequent guest speaker at conferences, including SES New York, San Francisco, Toronto, London, Delhi, Shanghai, and Hong Kong, Crispin was appointed to the SES Advisory Board in December 2009. He has also been a guest speaker at the e-Metrics Summit and ad:Tech, and is a member of Google's B2B Technology Council. You can follow him on Twitter at @crispinsheridan and read his monthly SEO column on ClickZ.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Search newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

UPCOMING TRAINING

Featured White Papers

Google My Business Listings Demystified

Google My Business Listings Demystified
To help brands control how they appear online, Google has developed a new offering: Google My Business Locations. This whitepaper helps marketers understand how to use this powerful new tool.

5 Ways to Personalize Beyond the Subject Line

5 Ways to Personalize Beyond the Subject Line
82 percent of shoppers say they would buy more items from a brand if the emails they sent were more personalized. This white paper offer five tactics that will personalize your email beyond the subject line and drive real business growth.

WEBINARS

Resources

Jobs

    • Executive Assistant
      Executive Assistant (Agora Inc. ) - BaltimoreAgora Inc., an international publishing company, located in the Mt. Vernon district of Baltimore, MD...
    • Paid Search Specialist
      Paid Search Specialist (Boathouse, Inc.) - Waltham  Boathouse is looking for a Paid Search Specialist to work as a part of the Digital Acquisition...
    • Paid Search / Search Engine Marketing (SEM, PPC) Specialist
      Paid Search / Search Engine Marketing (SEM, PPC) Specialist (HeBS Digital) - New YorkJOB TITLE:     Paid Search / Search Engine Marketing...