Mid October, a UK site got infected by a malware. The malware spread though the ad serving system to different page types. The development team cleaned up the malware and patched the system in a day. After having cleaned up the site from the malware, I requested a malware review from the webmaster tools console.

Google resources:

http://www.google.com/support/webmasters/bin/answer.py?answer=163634

http://www.google.com/support/webmasters/bin/answer.py?answer=163633

2 days later, our organic traffic from Google.co.uk dropped significantly. The traffic coming from the page types that had been infected dropped from about 80%.

2 weeks later, I submitted the same pages Googlebot visited on the day the site hosted the malware in site maps. I didn’t however any notice in crawl on GWT.
4 weeks later, no sign of improvement. I am submitting a reconsideration as a last hope.

For more info, I found an article about a similar situation. Their rankings got back after 10 days.

Update 10th December:

• Request for reconsideration
• 10 days later, we received Google’s usual email answer
• A week later, our rankings are back for one page type

I have been using trusted proxies that offers geo located proxies and parallel proxies for quickly set up rank reports. I am quite pleased with it.

I have stumble upon the only way to calculate the number of unique items in Excel and I am taking notes here

Add a column to the database and then add that field to the pivot table.

For instance if we want to count the unique occurrences of URL/Keyword, we shall add in the raw data:
- the row URL/Keyword in the raw data.
- In the first data row, enter a formula that refers to the URL and Kws columns. For example:

 
  =IF(SUMPRODUCT(($A$2:$A2=A2)*($C$2:$C2=C2))>1,0,1)

Copy the formula down to all rows in the database.
Then, add the field to the data area of the Excel pivot table.

source: Pivot technics

The facts:

JP cenney has been busted for using is black SEO technics. After a 3 month penalization, everybody shouts “JP cenney is back in the search results!”. Let’s check it out

If they are back, what kind of spring cleaning did they do and what are their new backlink strategies?

But first, The Google police officer, Matt Cutts confirmed the sanction on JP had been lifted. Where do they end up in the search now?

The New York Times article mentioned, JP used to rank really well for the keyword “dresses”.

When I search for “dresses” I cannot find JP in the first 100 results and when I restrict my search:

Using a proxy, their mobile site appear first: A subdomain that could have not have been concerned by the penalization. Not a very strong come back.

Party dresses maybe:

The backlink profile:

Let’s Majestic SEO do the talking…

11 Millions backlinks… Aie! that is going to require two month of my credit. Anyone feels like looking at the amount of domains and links they dropped?

Has Sunday been a sunny day in the UK or has the Panda Google’s update already stricken? Crawl rates show that the bots are done indexing the UK sites. It should be a matter of weeks. Any thoughts ?

Review of awR coming soon…

Your site’s design is the first thing people See
It should be a reflect of you in the Industry…

Make it easy for spider to crawl what you provide…

Everybody knows it is more flexible, better coding to write CSS yourself.

• But is it more efficient?

I am very bad at coding CSS.

• How can a grid help me out?

• Which CSS Framework should I chose SEOwise?

My requirements:

I am looking for a grid that is SEO friendly:Where I can push upp or down the different modules so that the navigation appears after the main content of the page.

I need a good control over the Font css.

The nominees are:

Two frameworks stands out:  Blueprint and YUI frameworks followed by960 CSS http://960.gs/ (less known but that might be more SEO friendly).

YUI framework:
+ Template columns are source-order independent, so you can put your most important content first in the markup layer for improved accessibility and search engine optimization (SEO).

- Does YUI framework provide us with semantic CSS?