Use Excel to Plan Meta Tags, Titles and URLs for SEO

Description

Mike from MarketingBreakthroughs.com sent in today’s SEO Tip, which has to do with organizing and planning the meta tags, keywords and page titles for an entire site.

Sometimes the taxonomy of an entire site can be overwhelming, and taking a proactive approach to site planning via putting together an excel spreadsheet page matrix can not only make things easier, but also address duplicate content issues which many websites experience in their meta data.

Differentiation in meta descriptions, file names and page title (along with on-site copy) is one of the keys to a Google friendly site, and here are some tips to get off to a good start using an excel spreadsheet to organize your work.

It’s useful to create a Microsoft Excel document to keep track of your page titles, file names, meta keywords, and meta descriptions, because different pages will have to be optimized for different words.

(Note that you shouldn’t do this for blog posts or news items, but rather the permanent pages on your website.)

By using Excel, you can also have a column with the LEN() function, which will give you the character counts of the cell of your choice. This is very important since only 70 characters are shown for a title tag in Google results and for description meta content, usually up to 154 characters are served.

You can also change the width of the cell, which will give you a general idea of how much space you have left.

I usually set it up with the following columns like so:

Page friendly name (use your site tree!)

File Name (or URL)

Page Title

Meta Description

Meta Keywords

The columns for page title, meta description, and meta keywords each have a small column after them to show me how many characters are in ...

Original URL

http://www.searchenginejournal.com/use-excel-to-plan-meta-tags-titles-and-urls-for-seo/8595/

http://www.searchenginejournal.com/use-excel-to-plan-meta-tags-titles-and-urls-for-seo/8595/