How to use VLOOKUP in Excel
Ever needed to compare lists of keywords in different data tables and match corresponding values together? Or needed to find things in a table or a range by row?...
Richard Baxter
Richard Baxter is an SEO Consultant of over 15 years and the Founding member of digital agency, Builtvisible.
Richard founded Builtvisible in September 2009. Since then he has grown a one-man SEO consulting agency into a 45 strong, industry accredited full service digital agency based in the heart of Old Street, in London.
More about Richard
Richard brings deep experience in SEO and organic digital marketing, having begun his career in search in 2003. Having worked in highly competitive verticals including travel, finance and retail throughout his career, Richard understands what is required to perform well in a crowded, competitive marketplace.
Anchor text optimisation best practices in link building
Overoptimising your inbound anchor text links can adversely affect your search engine rankings Despite it being 2018, the subject of best practices when it comes to anchor text remains...
How to use tables in Microsoft Excel
Most, if not all of my work in Microsoft Excel uses Tables. Using tables isn’t all that different to using cell references, and the outcome is a more agile...
How to: Add and improve related products in WooCommerce
WooCommerce is an exceptionally powerful, customisable retail CMS plugin for WordPress. As it’s WordPress, some organisations tend to reject it in favour of more complex platforms like Magento. While...
An SEO’s guide to XPath
What is XPath? That means (in plain terms) you can select any element, or the contents of any element, attribute, table or meta object in the source of the...
A complete list of embed code, social card, Href lang, Schema and meta code generators
Over the course of the past decade or so, lots of new standards for metadata have appeared. For social sharing, it’s thanks to Open Graph Protocol (OGP) tags, Twitter...
Prototyping automated product feeds for retailers
I was recently faced with the problem of creating a series of automated product feeds for a retail client. The requirement – deliver a feed in .csv format that...
Site migration – how we make sure a domain migration is successful for SEO
Because getting it wrong can be a terminal blow to a business.. SEO consultants share a nightmare: finding out that their client has decided to change their site’s domain...
How to improve your retail product page conversion
Most SME retailers focus more on traffic generation and promotion than they do on site conversion. Often we find that a focus on conversion rate takes a lower priority;...
How to optimise retail product pages for better SEO
How to optimise Your retail product ages for better SEO Product page optimisation is an oft-overlooked area of Ecommerce SEO. The key objection I tend to encounter is that...
Retailers: Improve your category pages before building links to your site
Or, as I like to put it: sort out your category pages for an easy win. The default response to most SEO ranking challenges is “we need more links”....
The Web Marketer’s Guide To Reddit
What is Reddit? Reddit “is an entertainment, social networking, and news website where registered community members can submit content, such as text posts or direct links.” (source). It’s the...
Why setting link volume targets for your SEO agency is a bad idea
Like every other SEO / digital agency, we get requests for “link volume numbers” in our proposals on a regular basis. That’s OK, we know how to deal out...
The impact of IP host location on your site SEO
Update: Does the hosting location of your server affect your SEO in 2019? This article was originally penned in 2015. In it, we demonstrated that across the broad spectrum...
There’s no such thing as “boring content”
There’s no such thing as “boring content”. Imagine the scenario. You’re a marketing consultant, hired to help bring a product into market. Very specialist item, limited audience, technical product,...