My strategy has always been to point them at whatever suits your industry (amazon for product reviews, tripadvisor for travel/tourism, Google and Yelp for local biz, WeddingWire for wedding vendors, etc.)  Then make a page on your site that is site.com/reviews and syndicate your reviews to that page.  When someone Googles me + reviews, I want MY site coming up so I can highlight what I want when I want.  It's just good reputation management.  They can still see the rest further down the page but if I can come up #1 for highonseo reviews I sure want to.

I totally dorked up the cells in step 9 - I fixed that in my answer above.

As far as the Step 10 - 11 thing, I don't think I did.  I think you skipped the second half of step 10.  Here's my original text, with bold.

10. Highlight the cells from H1 to H12.  Grab the black square in the bottom right of the border box.  Drag this selection down all the way to H2000.  **Copy all your cells from A1 to H2000 and paste values to remove any formulas.  We want just text now.  **

---------------------

Instead of copying and paste values for Column H, I just said do the whole thing.  At this point you only want text so it makes sense.  I was going to edit but I think the correct step is already in there.

 I'm glad you liked the answer.  Sometimes it's difficult to take the time to write up a long answer like that but once in awhile it just happens and comes out.  I had a feeling others may like being able to mess with that sort of data so why not, right?

I'll write it up soon - I think I may do a bit on "playing with your food data in Excel."

I'm going to go make a few edits to my post so it has all the right steps.  Thanks!  I see that I messed up my Bs and Hs.  After awhile I think I lost track of typing up each step and tried to recreate in my head what I had done. lol

Thanks for the endorsement Keri! Appreciate that.

From the post you linked - it doesn't look like the Grab It link works with the new Analytics.  Those are great alerts to setup but maybe someone can write up a 2013 version.

TY!

Really??  That's strange - if you PM me the domain, I can do a bit more digging.

Sure, you mostly care about ones that have already jumped up in impressions or clicks, right? I'm going to be very specific on the steps but this isn't as hard as it looks.

1. Go to Traffic Sources > Search Engine Optimization > Queries

2. Select a date range and then use "Compare to" and use "Previous Period."

3. Set Show Rows to 500.

4. Sort the table by Impressions.

5. Copy all the data from the table starting from "1. keyword" and finishing with the end of the table (last change%).  Paste this data directly into Excel. You should have columns A-F used, it'll look very messy.  Something like the attached "sorting1.jpg"

6. Find & Replace "% Change" with "Change"

7. In Column G put this formula:  =IF(LEFT(B1,6)="Change","Yes!","")  Copy this formula from G1 to G2000.  Every line that says "Change" should now say "Yes!" at the end.

8. Copy column G and use "Paste Values" to remove the formula and leave only the "Yes!" in place.

9. To match keywords to their change line, follow this specifically.  In H4, type =B1  This should now say your keyword.  Manually type in a few of these, so go to H8 and insert the formula =B5, then do the same with H12.  The formula is =B9.  You should see three keywords in Column H.

10. Highlight the cells from H1 to H12.  Grab the black square in the bottom right of the border box.  Drag this selection down all the way to H2000.  Copy all your cells from A1 to H2000 and paste values to remove any formulas.  We want just text now.

You should see a list of keywords in column H now, every 4 cells or so.  Check Sorting2 attached.  The rest is very simple.

11. Sort by Column G, Sort by Values, Z to A.  This should be looking valuable now.

12. Delete Rows 501-2000.  All rows should be "Yes!" now.

13. Delete Columns A, B and G.  Feel free to move Column E to Column A if it makes you feel better.

14. Insert a new Row 1 at the very top.  Label each like this:

Cell A1: Impressions

Cell B1: Clicks

Cell C1: Avg Pos.

Cell D1: CTR

Cell E1: Keyword

15. Highlight Row A and push View > Freeze Panes > Freeze Top Row.  Highlight all the data, press Ctrl T to create a Table.  Now you can easily sort any row and sort through your data.  See sorting3.jpg attached.

It's really not as complex as it looks.  Just use the two formulas, follow the steps and boom, sortable and pretty data.

(I may write this up as a YouMoz post with better screenshots, maybe a video tutorial or something, so thanks for giving us the chance to help!)

sorting1.jpg sorting2.jpg sorting3.jpg

1. Go to Wolfram Alpha

2. Enter the domain without any subdomain (ie. wordpress.com)

3. In the 3rd result box, top right, push "subdomains."

4. When it opens, push "more" (top right of the box)

You'll get something like this:

http://bit.ly/XaJ7o3

I think you're right - your link profile is definitely not up to where you'd like to see it.

The thing is, you own control of almost all your links. They are directory submissions, minisites, etc.  You aren't getting a lot of natural links, social linking or anyone talking about you.  You need to generate that "word of mouse" that will get links to you that are out of your control.

I didn't suggest copying from Word into Wordpress.  I suggested the opposite - do a final spell check, word count, etc. in Word by copying into Word.

You can add plugins and such, browser add ons and whatnot but it seems to me that for a 700 word article, it would be pretty simple to check spelling, fix a couple words and update the post.

To "grade" content, it's a big difference if they are using Wordpress or not so I gave the best Wordpress answer I can.  If not, obviously that's not an option.  Scribe is great but a bit over the top to pay for something that Yoast does easily enough.

If you're using Wordpress, then Yoast's SEO plugin does most of this.  It grades based on a keyword (you can change the focus keyword a couple times if you need to check a few phrases.)  It does keywords on page, reading level, etc.  It also tells you whether you've over-used a keyword.  It's not as much a grammar checker (you may find it easiest to quickly copy & paste your content into Word for a spelling/grammar, word count check.)