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.

Great New Functionality for Google Analytics

About a month ago Google Analytics showed up with a bunch of new reports.  This is a bit old new for some but if you haven't checked out these new features you're missing out on some fantastic info we've all wanted for years. 

For instance, people have been hoping to know exactly how much money different Adwords keywords were bringing in, what the best days and times for their campaigns but it sometimes seemed that to a degree Adwords and Analytics were separated.  Well, no more!  Google has just announced a few new reports that will help you to know what keywords, campaigns & more are performing good (or not so good).  These reports are very valuable and this is just scratching the surface!  For full info, check out the link and video below. 

Analytics blog post:  New Adwords Reports in Analytics

Video:

Press Releases- Do They Still Impress?

A few years ago putting out a totally SEO'd press release was a great way to get a bunch of links back to your site, thereby getting better rankings in Google for your site.  In addition, the press release itself would get ranked in Google if someone typed in the right keywords.  They go to the press release that links to your site and you get even more traffic.  Does this still work as well today?  And if not, how can a press release help your site out?

As you probably guessed, once someone figured out how well this worked, everyone did this.  They put out lots of badly written, spammy, keyword and link stuffed press releases on sites such as PRweb, PRleap, etc.  They were trying to trying to game Google just for a link or links by just churning out releases that had no real value to a reader..  Google got wise to this and has greatly devalued the links coming from press releases.  So how do you get the most out of press releases today?  Is it even worth the time?

Best Practices for Press Releases

 Really, nowadays in a effort to reduce spam and level the playing field the

idea behind a press release is back to what it should be- Well written, timely, compelling, newsworthy.  If this is the case, it may get picked up by a number of news or other sites and reposted with links back to your site.

 And this is what your press release should be.  Here are a few simple tactics as far as optimizing press releases for maximum possible effect on your site:

1.  Deliver high value to whoever reads it.  As was mentioned, keep it well written, timely, compelling, newsworthy.

2.  Ideas for press releases:  A Press releases can announce a range of news items such as: scheduled events, personal promotions, awards, news products and services, sales and other financial data, accomplishments, etc.

3.  Have the keywords you want people to type into Google in your press release in a natural way.  For instance if you are a Lasik surgeon in Los Angeles, California your potential customer might type into Google "Lasik, LA" or "Lasik, Los Angeles".  Have these keywords in the release a few times but not in a spammy way.

4.  Use anchor text in your press release.  In writing the press release you are often given the opportunity to link to your site.  The actual text that is hyperlinked is the anchor text.  Make sure this text has the keyword phrase (like "Lasik, Los Angeles") linking to a page that has the same keywords in it.  Don't just hyperlink the words "click here" or something like this.  This may not seem like a big deal but it is.  Do a search on Google for info on "anchor text" and how much Google uses it.

5.   Keep your press release to a reasonable size and keep it on topic- you can always write another one later for another topic/subject. 

6.  Email it to some handpicked journalists and bloggers. Personalize the email message. For good measure, submit it to PRWeb, PRLeap, etc.

More great info on press releases:

High PR Web 2.0 Properties for Link Building in SEO

Description Tags- Who's in the Driver's Seat?

The last post was on Description Tags - 7 Quick Steps to Success.  While that post covered some basic things to make the most of your description tag it would be good to cover/emphasize another thought that could have an impact on the success of your description tags.

#1 Question:  Hey, we did everything you said to optimize our description tags & Google is showing a lame strange snippet from our site- What's going on?

Good question.  Here's the answer in short:  Google may totally disregard your hard work in creating compelling description tags and put whatever they want there.  Why?

Google's number one goal is to return the most relevant results to their audience, and because of this they may pull content from other portions of your page to better match the keywords used in the searcher's query.  Think about it- If you have a page on your that talks about gluten-free pasta you can likely only target one or two keyword phrases message in your description tag such as "gluten-free pasta" or "wheat free pasta".  Likely if the searcher types in those keywords the description tag you wrote will come up.  But if they type in "gluten-free spaghetti" Google may crawl that page and see that you indeed do have that phrase on the page and put together their own description tag/snippet to best match the searcher's query.  Here is Google's description with underlining and bolding added by us:

"Google's creation of sites' titles and descriptions (or "snippets") is completely automated and takes into account both the content of a page as well as references to it that appear on the web.

We use a number of different sources for this information, including descriptive information in the META tag for each page. Where this information isn't available, we may use publicly available information from DMOZ. While accurate meta descriptions can improve click through, they won't impact your ranking within search results. We frequently prefer to display meta descriptions of pages (when available) because it gives users a clear idea of the URL's content. This directs them to good results faster and reduces the click-and-backtrack behavior that frustrates visitors and inflates web traffic metrics.

While we're unable to manually change titles or snippets for individual sites, we're always working to make them as relevant as possible. You can help improve the quality of the snippets displayed for your pages by providing informative meta descriptions for each page."

What does this mean for you?

Does this mean you should just give up and not write meta descriptions?  No because in many cases Google will show your description for the search query.  But if they don't it basically comes down to what you should be doing already.  Having great content on your page, perhaps having keyword variations and well written copy so that if Google does show something different it will still be relevant.

More information on meta descriptions/snippets and how they work:

Excellent article by Ken Lyons:  Meta Description Mutiny! Take Control of Your Text Snippets

Official Google Video with Matt Cutts discussing descriptions/snippets:

Description Tags - 7 Quick Steps to Success

Your meta description tag is a valuable part of optimizing your site for Google that is often overlooked.  A description tag is basically a snippet of information on each page of your site that shows up in the search results below the heading of each search result (see picture below). The description tag does not show up on the actual page of your site in its readable text but rather is something that you enter for each page on the site.  At this time the length of the description tag shown by Google is 150 characters.

Best practices for description tags:

1.  Unique description tag for each page on your site. 

2.  Use each page as a chance to rank on Google for a phrase. 

3.  Use your target keyword(s) phrase in your description tags, preferably toward the beginning. 

4.  Use your targeted keyword phrase once, perhaps fitting in secondary phrases if possible.

5.  Use this tag to continue to interest the reader and give them extra reasons for clicking on your listing.  Think of this tag as valuable "real estate"- like a billboard that you can use to your advantage to get more clicks than you're competitor even if they are above you in the search results.

6.  Keep the description under the above amounts of characters to make your message complete and not trail off...

7.  Know that Google will not always use your description tag in the search results- see the following article:
http://www.wordstream.com/blog/ws/2009/11/19/meta-description-mutiny

Additional Links: 

Google's page on what they look for in the meta description tag and how best to optimize it:

http://www.google.com/support/webmasters/bin/answer.py?hl=en&answer=35264