Free Tool that Automatically Counts Title & Descripton Tag Lengths

No doubt you agree that any tool that simplifies or speeds things up in doing SEO is always welcome.  Here's a great little tool that you can use when writing title & description tags.  It automatically keeps track of how long these tags are so they fall within Google's guidelines.  After all you want to have nice well formatted tags and avoid the dreaded search results where your tags trail off...

You can find the tool by clicking To use this cool too click here.   This page courtesy of the good people at INT.  Best of all its free and works right on the page!

Do you have any suggestions on tools to speed title and description writing?

How to Highlight & Find PPC & SEO Keywords Quickly Using Excel

Sometimes the littlest things save the biggest amount of time.  So this will be a quick post on a time saving tip for either SEO's or PPC professionals working in excel.  We all know excel is a fantastic tool.  It seems everytime you use it, there is something new it can do to speed things up or make things easier.  Perhaps no program is better at easily handling thousands of keywords, organizing and rearranging them to interperet data quickly. 

But have you ever downloaded thousands, perhaps tens of thousands of keywords from either Adwords or server logs and wanted to see just a certain segment of them quickly?  For instance you downloaded 20,000 keywords from different campaigns for say, "pet toys" in Adwords and only wanted to find the keywords that contained "dog pet toys".  Or you did the same in downloading your server logs and wanted to do the same.  You could write a complicated formula but here's an easier way (this is for Excel 2007 but its basically the same for the other versions): 

How to Highlight & Find PPC & SEO Keywords Quickly Using Excel

Excel:   Find & Highlight Keywords

Handy for finding CPC, search terms, etc.

1.  Select Row/Rows

2.  Hit Ctrl + F

3.  Enter word(s) you want to find in find field

4.  Click options Button

5.  In the "Replace With" row click Format

6.   Select color you want cells to be highlighted (like yellow)

7.  Click Replace all:  Your cells with these words will be highlighted

8.  Click filter and filter by color to see just the highlighted keywords.

9.  Just click undo to undo this.

That's it!  Please leave a comment if this helped you or you would like further clarification.