Excellent, did it, got data, very happy.

Just incase anyone else comes across this there is 1 correction to the above, and 1 missing step:

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 B8 and insert the formula =B5, then do the same with B12.  The formula is =B9.  You should see three keywords in Column H.

should be

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.

So you only put this formula in Column H, referencing column B.

Then, between Step 10 and 11 you need to copy column H and do Paste Values, otherwise when you sort in step 11 you will end up with #REF errors.

This has yielded some excellent data for me to slice and dice.

WOW!

That is the most detailed response I have seen in a Q&A.  Thanks for going to so much detail.

Definitely write this up as a YouMoz, as I have a feeling this would be a great interest to a lot of people, and could well get promoted to the main blog.

Right, I'm off to fire up Analytics and Excel and see what I can see.

This truly is brilliant.  Thanks so much.

Keri, thanks for the heads up on the alerts blog post.  I have used alerts, but for some reason I just didn't think to use these to identify changing trends in keyword usage.  So I will give this a look also.

Thanks Guys

Hi Guys

I just spotted in the Google Analytics > Traffic Sources > Search Engine Optimisation > Queries section a keyword that on the 27th Feb went from generating 35 impressions per day to 2000 impressions per day.

This was down to people searching for a newly launched product.

Does anyone know how I can identify any increases like this easily?  I only came across this by accident, and I am 1 month behind the times.  It would have been ideal to pick this up closer to the time so I could capitalise and write some great content on the topic.

Thanks

Paul

Hi

Not sure why this is happening, but I am having a lot of trouble viewing your gzipped sitemap.

Your robots.txt file is pointing at a gzip sitemap

http://www.tomlondonmagic.com/robots.txt

http://www.tomlondonmagic.com/sitemap.xml.gz

Is that what you submitted to google?  Try submitting the non gzip version and see if that makes a difference:

http://www.tomlondonmagic.com/sitemap.xml

Thanks

I think to get any helpful responses you will have to give some specific details.

It could be down to a number of factors, so in order to help the community is going to need to know what your site is to be able to look at it and give you some pointers.

With the info you have given, you are just going to get a bog standard list of all possible reasons for delisting, which isn't going to help you at all.

Thanks EGOL

This all makes sense.  It's nice to get a bit of a sanity check.

I think I worry because in the SERPs we struggle against our competition, but once we get a browser conversion is good.  So I keep worrying about the SERPs.  But I know I need to just concentrate on writing good content and adding depth to the site, and that will hopefully give us the pay day we are looking for.

Thanks

Paul

Excellent, great stuff

Thanks for your help.  I think these blog posts provide real value to the customers, which is the main thing.

Thanks

Paul

Hi guys

I have an eCommerce site and a blog. the blog is on a suddomain. I am writing content about our products on the blog, I.e. Full in depth reviews and top 10 lists etc.

These blog posts link back to the main product page.

It would also be nice for customers on the site to a "blogs about this product" section. However, would a link from the product page to the blog weaken the internal link from the blog to the product?

Thanks

Paul