AdWords Search Terms Reports

Search terms report are useful for letting you know what keywords searchers used to trigger your advert but it does not tell you which bidding keyword was used. Google’s new report has added a “Keyword” column that allows you to see the exact bid keyword that matched the searchers query in order to trigger your advert. It is part of a customisation you can make in adding new columns under the search terms report.

Seeing the matched keyword is useful in giving you information to make certain decisions like adjust the keyword, add negative keywords to the campaign/adroup, adjust ads/bids or even relevant landing pages.

Further reading:

Adwords blog

Search Engine Land


Anchor Text Variation Pre & Post Penguin

Anchor_DiversityA lot of link builders have been struggling with the correct ratio of anchor text after the Penguin update. Below is a suggestion by mMatt Cullen who Many SEO’s have a lot of respect for:

“Pre-Panda/Penguin, there was a pretty specific formula that would
work the majority of the time for ranking a website in Google.
Obviously, this was dependent on the competition too, but the key
strategies went something like this…

1. Get a bunch links – a lot of them

2. Get links with your keyword in them

The formula looked like this:

– 60% of your links should be your main keyword

– 15% of links are your main keyword + other words (eg: read about,
check out, etc)

– 15% of your links generic text (eg: click here, visit site)

– 10% of your links as the text (eg: your link URL used as the text)

And like a lot of people have experienced, when Google’s
Penguin update came around, it effected this “formula”.

BUT there’s one very good reason that some of our sites
didn’t get hit at all, or recovered extremely fast.  And it has
absolutely NOTHING to do with where we were getting the links from,
but more so with “how” we were  linking… i.e. the link
density and anchor text we were using.

We quickly realized that the old way of doing things needed to be
changed.  Slamming your sites with a bunch of keyword rich anchor
text is finished – it won’t work.

But the reason we’ve now rebounded is because of the following
two things:

1. It wasn’t the links that were the problem

Getting a ton of links still works.  Do I need to repeat that?

Most people froze and just stopped building links altogether
fearing that if they continued, their sites would get hit even

They were wrong.  You see I figured that if you suddenly stopped
business as usual, that it would be a sure-fire sign to Google that
you were up to something and then they would hit you even harder.

They were looking for a reaction on your part.  If something
suddenly changes, you’re likely gaming the system.  If your
links are in fact natural, well then why would anything change?

It wouldn’t…

So we got that part right and now we’re almost back to
pre-Penguin traffic levels and rankings.

But there was a second thing…

2. Anchor text links have CHANGED…

Our formula for the amount of keyword anchor text we used was now
defunct.  We didn’t change it right away (keeping with what I
outlined above), but we did slowly phase in a new formula.

The new formula goes a little something like this (obviously
adjusting as needed, based on our competition too):

20% – your main keyword that you’re wanting to rank for

25% – related LSI keywords (these are keywords related to your main
keyword.  Think of these as the “related” searches that
Google shows you as you’re typing in their search field).

35% – your URL as the anchor text, as well as other combinations of
“branded keywords”.

20% – generic keywords

Google is now looking for a more diverse linking profile – a more
natural one.”

Checking Server Status and Backlinks with Scrapebox

scrapeboxScrapebox has a couple of useful addons for checking the status of your pages and backlinks of previous linking sites and webpages.

You may want to check the status of many pages in a website to know if they are alive or dead so as to decide what to do with them – e.g. redirect them to a live page.

Create a list of Indexed Pages

The first thing you want to do is create a list of webpages for the site. You can do this by using Screpbox sitemap plugin or by using the command to get a list of webpages indexed in Google, Yahoo and Bing. Once you get this list you need to remove duplicates from the different search engines so that you have a clean list to work with.

Check Server Status

From Scrapebox instal the Alive Check Addon and run it for the list of indexed urls. You can tell it what status code to treat as alive such as 200 success or reverse check for 404 pages. You can also choose whether to follow a 301 permanent redirect or count it as dead. This will provide a result of the urls with comments like Alive, Dead or failed. In case of Failed it is useful to recheck a few times in case your site server is rejecting your request as precaution to too many requests.

Check Backlinks using Scrapebox

Another useful addon lets you check if your links are still up on a particular webpage. The link checker plugin works by checking a bunch of webpages or blogs for mentions of your site. You can also use it to check if the links are nofollow or otherwise. My experience with the addons is that you need to run the server status error list a few times as it time-out before finding an actual link. However, the link not found report was accurate.

Below is the instruction video for both addons:

Backlink SWOT Analysis Case Study

A recent review of car finance websites resulted in the following backlinks SWOT analysis.

Domain profiles

site explorers compare metrics

A look at open site explorers compare metrics shows Money Supermarket has a strong page authority due to strength of its domain and number of internal links to the car finance page. However, Car loan 4U has more High MozRank and MozTrust, 8,754 external followed links from 868 root domains and 595 C block.

Search Engine Keyword VisibilityKeywords Visibility

We took the top keywords relating to car finance, car loans and car credit and ran a rankings report for Google and Bing. Car loan 4u and money supermarket are tied in first page rankings with 61 keywords each in Google. However Car Loan 4u totally tanks in Bing with no ranking for main keywords.

Backlinks History

Backlinks History  comparisons

Backlink history shows carloan4u has had higher velocity of backlinks than its main competitors but has a slowdown in last quarter of 2008 with the same domain diversity. This is probably as result of less site wide links in navigation and footers. Creditplus has less velocity of backlinks history but a greater diversification of where the links are coming from which has always been aspects of a good links profile.



 Anchor Text Diversity

Anchor Text Diversity

Domain Anchor text distribution shows a good distribution of main industry keywords and some brand name links for most sites. This is important due to the recent Penguin update targeting over optimised backlinks so there needs to be linking with brand terms so as to get at least 75-80% share. However, the high proportion of money keywords in Car Loans 4U to brand terms appears unnatural.





Spam Links

There is evidence of black hat & paid links activity in some profiles . These spam links could lead to possible penalty by search engines following algorithm changes link Penguin and manual review exercises. The solution is a take-down request or disassociate your site through Bing and Google’s disavow tool.



Traffic Opportunity

Traffic Opportunity  forecast

The keyword “Car finance” is the dominating search term in the industry and a forecast shows it will continue to be a dominant keyword in 2013.



Search Engine Visibility Opportunity

•Increase ranking for a keyword like “car finance” from position 3 to first position will increase traffic by more than 150% in Google search alone according to a study conducted by slingshot.
•Increase visibility in Bing as another source of traffic and insure for change in search behaviour.
•Increase visibility for long tail research based keywords via link bait blogging.





Link Building Opportunities

Pursue white hat link building through:

•Blogger outreach & guest posting.
•News editorial links from major newspapers and news channels.
•Regular press releases via PRNewswire, PRweb etc.
•Link bait via blog posts, infographics, video etc.
•High quality curated directories.


Threats to a link acquisition campaign can come from:
•Using black hat, paid links from low quality sites.
•Future Google algorithm updates: You can mitigate this by sticking to strictly “white hat” link building techniques.
•Lack of visibility in smaller search engines: Change in search behaviour in favour of other search engines could lead to a loss in traffic. Mitigate this by ensuring rankings in all traffic sources.

SWOT Summary

Below is the self explanatory summary of above SWOT analysis:

Going from Google Penalty to Reconsideration

Google Penalty letterA website owner responded to our advert in panic leaving  several phone messages and email contact requests. He woke to receive the dreaded email from Google informing him his site has been penalised due to unnatural linking behaviour  If you have been doing some aggressive link building in the past then you may get a similar email telling you your site has been de-listed for suspicious behaviour. The question is what are the steps one should take to get out of the Google jail.

Below is the steps I took to go from the warning letter to a reconsideration request.

Download Backlinks

Find out what links could be causing the problem. Now, the problem here is that Google has been notoriously secretive at telling us what links it counts for our site. A Google search for shows very few links so we have to rely on other sources like Open Site Explorer and MajesticSEO to find our backlinks. Matt Cutts in his disavow tool launch video suggests that the warning letter comes with sample links found to be unnatural but there was no such hint in our clients email. You do get more backlinks information from webmaster tools though you have to dig a little. You have to jump over to your webmaster tools traffic tab then click on more tab under the “who links the most”. This will give you a list of all sites linking to you but you want the actual links. To do this you need to click the “download more sample links” tab which gives you a CSV list of actual URLs where you have backlinks.

Do a Backlinks Audit

The difficult part in sorting out the backlinks list is deciding which links are harming your site. There many places on the internet detailing what are considered poor links including

  • Bad neighbourhoods: links from gambling and porn/adult theme sites
  • Anchor text diversity: following from Penguin update anchor text proportion is on every SEO’s mind. MajesticSEO has updatedAnchor_Diversity their tools to show a nice pie chart of anchor text which you can use to ensure there is not too much focus on a one or two money terms instead of a brand term. Common thinking today is that your brand or website url should comprise 75-80% of anchor text with the rest being used sparingly among money terms.
  • An increase in links from one particular site: Again MajesticSEO is your friend in looking at backlink diversity. Webmaster tools can also be useful as it shows the total number of links from each site so you might want to start there. Unnatural high number of backlinks from one site can occur due to placing your site on the sidebar or footer which red flags Google to a paid link.

Link removal steps

Once you have got the clean list it is time to take steps to remove or discount them. Start by writing to the webmaster or site owner with a friendly email asking them to remove your link from their website. Most website owners should not have an issue with removing the links – especially if it means they will reduce number of links on page and get to keep the content of an article.

There are some webmasters who will not respond or try to hold you to ransom by asking for payment to remove a link. In this case Google has given us the new disavow tool to let them know you do not want to be associated with these links. To use the disavow tool you simply save the bad links list as a CSV and head over to the disavow tool and upload the list and hit submit.

Filing Reconsideration Request

Once you have taken steps to get bad backlinks removed or disallowed you can send a reconsideration request. You need to fill in the reconsideration form and submit to the Google webspam team and put as much detail as you can. The form is a mixture of a confession box and bad SEO’s reporting. It asks you to name any SEO who may have created these bad links for you. I guest this is one way for the webspam team to collate information and act where a one individual or company is constantly reported. You also need to provide details of all efforts you have made to get the bad links taken down and if you have asked Google to be dissociated with the links via the disavow tool.

After you fill in the request form you will get a message confirming you are being reconsidered for re-indexing. They do say it can take several weeks depending on amount of reconsiderations they are working on so don’t hold your breath!


Why do you need a press release?


A press release serves two purposes.

1) They can develop an amazing amount of link popularity
from real authority sites as a professionally written press
release actually gets distributed and posted to real media
sites. We’re talking major newspaper sites in many cases.

2) By getting exposure for your business on major authority
sites, you not only will see direct traffic from those
sources to your site, but it is not uncommon for a press
release to get syndicated and distributed to an even wider
audience if it gets picked up by a news service.

A press release is like article marketing on steroids.

A press release is one of the ways the big boys get
exposure. These are not designed for made for Adsense sites,
but for a quality websites.

If you’re on a budget you can find several free press
release distribution networks as well, though their exposure
will be far more limited.

If you’re not currently doing press release marketing you
are missing out big time. If you want to take advantage of this great resource then try our team.

We have two highly experienced professional, American, press release writers on staff. Click here to enquire about our press release service.
Related stories:

Link Building Tactics Review – Pros & Cons

Intro & Objectives

The object is to review various link building tactics for your website and look at their pros and cons. Objective of the exercise would be to increase the number of links from high quality sites and blogs.

As a link building service we would review each tactic in relation to client website and try implementation a few of the different tactics and share successes/failures on a portfolio.


Tactic: Link Building through Social Media

Link Building through Social Media by reviewing new and existing tweeter followers who are industry leaders and engaging them with the aim of eventually asking to link to us. The process is discussed on SEOmoz white board Friday Scalable Link Building Using Social Media.

This can be a long term relationship which we can use to promote a particular content or just hope to be in journalist/bloggers mind next time they think of link resources for their new article. The process can be complex and time consuming but hopefully streamlined by BuzzStream social component.

Pros: Such relationships can be more long term and far reaching than cold email requests. We have the advantage of using the BuzzStream social tracking ability.

Cons: It is very time consuming building and maintaining such relationships.


Tactic: Links from Journalists and top industry bloggers

We will search related content on big news media sites such as BBC, New York Times or CNN as well as industry niche news sites. These sites have potential to bring hoards of traffic as well as increasing rankings. This technique will involve outreach to bloggers or journalists who are writing content related to our projects or feature articles.

Process is as follows:

  • Search bloggers/journalists writing about our feature/project subject
  • Ask them to include our link or write a review of our feature
  • Entice with social mentions on our network

The proposal will be in the form of:

  • A link to our page with similar content will be useful to your readers
  • Appraise our content and link to it

Pros: These sites have potential to bring hoards of traffic as well as increasing rankings.

Cons: It is difficult and time-consuming to find contact details of journalists


Tactic: Competitor links import

This involves putting the competitor website into open site explorer to find the links pointing to their site. Downloading the links in a csv file and importing it into BuzzStream. Once in Buzzstream we sort out and keep high value prospects for outreach.

Pros: It is easier than searching for new links and they are more likely to link to us if they have linked to similar sites.

Cons: The competitor might find you are following their links and do likewise with our links.

Tactic: Dead link building

The process involves finding out links pointing to dead pages to our sites.  We need to download dead links pointing to our sites and contact webmasters pointing out the error and providing an alternative link source. It helps both sides because you are helping the webmaster as they do not like to link to dead pages.

Pros: The website has already linked to us in the past so likely to link again.

Cons: It is a time consuming and tedious process requiring technical ability and follow ups.

Competitor Dead link building

This involves running the chrome plugin on the links/resources page to discover any dead links. We can then use a template to contact the webmaster with suggestion of an alternative page on our site. The process of looking for dead links should happen as matter of course when looking at links/resources pages.

Pros: It presents the webmaster with a solution so it might build long term friendship.

Cons: It takes extra effort to note sites while scouring the industry websites.

Tactic: Approach sites already linking to us

Sites that have linked to us in the past are important as they are likely to link again so they should be approach for further link building opportunities. They should however be evaluated in terms of link value and traffic that they have generated. We will form a relationship with high quality sites that bring in traffic so that we can propose a new content to link to.

Pros: Webmaster is more likely to link if we point out they have done so in the past.

Cons: We need link diversity from new sites so not too much of this technique can be followed.


Tactic: competitions and giveaways

We can run a link building contest among bloggers with prizes like free advert or social media promotion. This can involve asking bloggers to write particular content about our site and awarding the best article. A recent good example can be found at

Pros: A prize or give-away is an easy way of getting attention of bloggers.

Cons: You may have to wade through a lot of poor content to pick a winner. Some webmasters might remove our link once they find out they have not won.



Tactic: Infographics

The process involves producing Infographics out of images and content in projects, feature articles and white papers.

Pros: You can watermark the image so that visitors know where it has come from.

Cons: The process might require external resources to produce the Infographics. The bloggers might not always link to the page you want them to.



Tactic: Phone calls

We need to phone and talk to some of the people we have made email contact with. The process involves making phone calls to link prospects already contacted starting with ones already having email dialogue, social media contacts and pure cold calls.

Pros: Hearing a voice related to a name might help to alleviate the fear that you are not a spammer.

Cons: Some people do not take kindly to cold/warm sales-type calls.

Tactic: Create movie via slide from images

The method involves:

  • Using Animoto or Windows Movie Maker to turn images on our site into movie files.
  • Upload to YouTube and other video sharing sites
  • Moderate comments
  • Promote channel via blogs and other social media

Pros: Having a YouTube channel creates another avenue of traffic as videos are part of organic SERPS.

Cons: You have to moderate comments to avoid abuse and spammers like all social media presence.

Tactic: Create a widget for placing on relevant sites/blogs

Create a widget with a feed of our content and offer it to relevant sites/blogs as a news/image source. An example can be seen at

Pros: Create a useful widget and it can be used several times across the web.

Cons: Time consuming to create a useful widget and it may involve web design team. The images are not in central location to be pulled by feed.

Tactic: Use client email list to request links

The idea is to use our lists of client data to approach them for a link back to a relevant our site. You need to discuss with relevant authority like sales managers how best to go about this without upsetting client relationship.

Pros: Our clients are very likely to link to us as we have a common interest.

Cons: It may be viewed as reciprocal link building which has been devalued by search engines.

Tactic: Encourage newsletter subscribers to link to us

This will be in the form of Encourage people to link by asking, “if you’ve enjoyed this newsletter, you can link to the permanent version at (insert URL)”.

Pros: Our newsletter subscribers may be more willing to link to us. It can increase social media likes and shares.


Tactic: Adding link prospects while browsing

Link prospects appear all the time while browsing within a particular niche. It is therefore useful to be mindful of link prospects even while browsing or searching for similar content. Finding a good value site and noting it can easily be done via the buzzmarker plugin to import into prospects.

Pros: This helps to steadily build prospects for future outreach.

Tactic: Getting links from links/resource pages

The process involves searching for link/resource pages by keyword and asking the website to add our link. We have been using this technique for a few weeks and have got some links but a lot of  webmasters are ignoring the deep link request and linking to the homepage.

Pros: It is easier to propose a new link where there are similar links.

Cons: Links from these pages may become devalued by search engines in the future. Some website owners request a reciprocal link which we are not able to give. Most webmasters link to homepage instead of deep linking.

Tactic: Get citation links from Wikipedia

Target Wikipedia as part of our link building as follows:

1)      Create an account on Wikipedia. Resource:

2)      Search Wikipedia for a highly searched issue in feature articles.

3)      Scan through the feature and Wikipedia to look for a place on Wikipedia where you can add a citation back to our feature article.


Pros: Wikipedia ranks well for several research type queries related to NRI sites so there is potential to gain extra traffic.

Cons: The links in Wikipedia are no follow so they will contribute little to ranking. Amount of click- through is low because citations are at the bottom of the page.

Tactic: Start blogs to host images and videos

The idea is to start industry blogs that we can send images and videos with the hope that they will start ranking and pass traffic.

Pro: It is easy to setup a blog and upload images and videos.

Con: This was a good idea in the past but is doubtful now because of Google clamping down on blog networks.


Tactic: Directories

Submit your profile to internet directories used to be an assured way of getting a quick backlink. However Google has devalued a lot of general directories duie to their link farm nature. There are a few niche directories that are worth submitting to depending on the industry which we shall explore.

Pros: They are a quick way of getting a backlinks

Cons: Google is on the warpath against directories so very few will remain that are worth submitting to.

Download SEO factors via SEO tools for excel

This week had had the need to use seo tools for excel and gained a new appreciation for the free resource.

Basically I want to download a sites page titles, H1 headers into excel in order to perform further analysis. First I needed to download a URL list of all the pages of the site. To achieve this I used scrapebox which has a wonderful feature that scrapes all major search engines. In scrapebox this is what I did:

1)      Use the command

2)      Choose to scrape all the search engines Google, Bing and AOL

3)      Harvest the URLS then remove duplicate URL’s to get a clean list

This gave a clean list of URL’s that I simply pasted into a spreadsheet and run the titles command in excel tools for SEO. I got a result like this:

Title H1 H2
Special Footwear & Orthotics | Bespoke Shoes | Orthotics Central London – Free consultation Beautifully HAND crafted specialist Footwear & Orthotics in Central London
Accident Assessment Claims – Anthony Andrews Master Shoemaker Accident Assessment Claims Related Items
Adaptions, Build-ups and Raises by Special Footwear & Orthotics, Central London W1 Adaptations, Build-ups and Raises related items
Uncategorized Archives – Anthony Andrews Master Shoemaker


Complete list of seo tools for excel here but below are the main ones I found useful:

=GooglePageRank([URL]) – To get the Google PageRank by URL

=GoogleIndexCount([URL]) – To get  an approximation of the number of pages indexed by Google by domain (the equivalent to “”)

=WhoIs(string domain) – To get  WhoIs for a domain

=IsDomainRegistered([DOMAIN]) – Returns “true” if a domain is registered. WhoIs servers are configured in SeoTools.config.xml

=FacebookLikes([URL]) – To get  the number of total Facebook Likes of an url (same count as in a badge)

=AlexaReach([URL]) – To get  Alexa Traffic Reach Rank

=ResolveIp([URL]) – Resolves the IP address of the domain in an URL

=HttpStatus([URL]) – To get  the HTTP status code and its description. Also retrieves the Location header (useful for debugging redirects)

=ResponseTime([URL]) – Returns the number of milliseconds it takes for an url to load (cached)

=LinkCount([URL]) – Shows the number of links on a page (cached)

=HtmlTitle([URL]) – Shows the HTML title on a page (cached)

=HtmlMetaDescription([URL]) – Shows the HTML meta description on a page (cached)

=HtmlH1([URL]) – Shows the first HTML H1 element on a page (cached)

=HtmlH2([URL]) – Shows the first HTML H2 element on a page (cached)

=HtmlH3([URL]) – Shows the first HTML H3 element on a page (cached)

=XPathOnUrl([URL]; [XPATH]) – Gets the url and returns the result from xpath

Related posts:

SEO tools for excel examples by distilled

Excel for SEO by distilled