August 21st, 2013.
I’ve been using Google Docs to keep track of links built to client sites and to track the progress of any link removal work. Occasionally I’ve noticed links have either been removed, the linking page no longer exists, or the links reported in that incredibly useless ‘sample link report’ are wrong. As SEOs/link builders/content marketers/inbound marketers/digital ninjas (select/insert your choice of title here) this is something you’ll want to check from time to time.
Whilst tools like ScreamingFrog are great for this sort of thing, sometimes you might want the convenience of checking this within Google Docs:
This lovely little formula grabs the lowercase anchor text of the first link containing ‘www.datadial.net’ of the URL in cell A1.
Searchmetrics is a brilliant SEO tool, the amount of insight that it gives on client and competitor sites is incredibly useful. One of my favourite reports, along with some manipulation in Excel is to run a quick rankings comparison report on your competitors so you can gain insight into what they’re ranking for, more importantly what they’re ranking for and you’re not, and also how your site matches-up a full range of industry keywords.
For this sample report I’m going to take a look at some of the bigger sites in the insurance sector.
Other good insurance companies do exist, along with quite a few terrible ones.
Run each domain through Searchmetrics and run a long-tail keyword report on each of the sites that you wish to compare.
Export and download each of these reports.
In Excel create different sheets for each of the exports along with the first sheet which should be named ‘comparison’ this is where all of the magic happens and your data will be pulled-in.
Paste each sites data into onto it’s own sheet, as well as cumulatively into the ‘comparison’ sheet.
Then under Data > Remove Duplicates remove duplicated keywords on the ‘comparison’ sheet.
Then delete the following columns in the ‘comparison’ sheet – URL, Pos, Title, and Traffic Index. This should leave just Keyword, Search Volume and CPC.
Next add columns for each of the sites that you wish to compare. This should leave you with a sheet that looks something like this.
Then, using VLOOKUP you’ll need to pull the ranking data from the other sheets into the comparison sheet. So for example into Column C all of the rankings for Aviva will appear.
The formula you’ll need is =VLOOKUP(A:A,Aviva!A:G,3,0) The easiest way to generate this is to use the insert formula function,
Lookup value – Is the value that you’re looking up, in this case is column A, the keyword.
Table array – is the table you’re finding the value in, which is the Aviva sheet, so click in the table array entry field, then go to the Aviva sheet and highlight all of the columns.
Col index num – is the column with the data in that you wish to import, so column 3, the ranking position.
Range lookup – Enter FALSE or 0 here to find an exact match. This will cause #N/A to be returned if the site isn’t ranking for the keyword.
Repeat this for each site. And then expand the selection by dragging the corner of the box down to apply to each of the cells in the sheet.
Tidy the sheet up by formatting as a table, and (hopefully) you should have something that looks like this.
If the #N/A results are annoying you can easily remove them by modifying the VLOOKUP formular from
You can also colour-code the rankings using conditional formatting.
If you would like to download this example sheet I have added it here – CompetitorReport
June 25th, 2013.
All of the briefs we’ve received this year have included a request for a ‘mobile version’ of the proposed new site.
But what does this mean? And do I hear the creak of an overloaded bandwagon?
Just as 2011-12 was the year of the Social Strategy [with no specification as to what that actually means], 2013 is fast becoming the year of the Mobile Site.
Yes, it’s true that mobile use is increasing:
Source Monetate E-Commerce Quarterly.
But how should you respond?
People could be accessing your website from any number of devices (such as phones (of all shapes and sizes), tablets (of all shapes and sizes) and even smart TVs (of all shapes and sizes). So, as a website owner, you shouldn’t be asking whether you should be considering mobile options, you should be asking which mobile options to consider – or shock-horror, opting to do nothing.
So there are 4 main options available to you. Each has its pros and cons, so let’s get the run-down:
#1 Responsive Web Design
What is it?
In a nutshell, this is designing your site so that its layout responds to the device on which it is being displayed..
– Streamlined: The site is hosted on the same domain and uses the same URL so there are no SEO issues or redirecting issues.
– Consistent with Desktop Content: The same content is just presented in a different layout.
– Low Maintenance Cost: Although initial build costs may be slightly higher, the cost of maintenance and updating should be lower (as you are only maintaining one site).
– Slower Loading Times – If you are adapting an old site to a responsive site you may find that it is not fully optimised for mobile and is slow to load. However, if you are building a new site and taking a ‘Mobile First’ approach, this shouldn’t be a problem. But 3G and 4G coverage remains sporadic and unstable – so some content may take time to download.
– General Usability – Mobile users will generally have a goal in mind when accessing a website. Whether it’s buying, reading or checking-in, they may not want to go through the same process as a desktop user. They may expect a stripped down version of the site similar to an App.
– Lack of Mobile Features – You won’t be able to get the same level of integration from a responsive site – features such as camera, photos or calendars.
– Lack of Zoom - if you are used to pinching and zooming into websites on mobile in order to be able to read the tiny text then you will not be able to on a responsive website.
Whether or not to go responsive divides opinion. We’ve been experimenting on our own site with responsive design and generally prefer the regular layout, when viewing on an Iphone. But all sites and companies are different and user needs should be a chief consideration.
#2 Dedicated Mobile Site
What is it?
Dedicated mobile sites are purpose built versions of the original website which are hosted at a new domain address (usually by adding ‘m’ before or after the original address: m.tesco.com or www.argos.co.uk/m/.
The web server normally recognises which device is being used and serves (delivers) the appropriate site to display.
– Different Content – A site purpose-built for mobile will usually have features which can load more quickly on mobile platforms, and you can dispense with some of the superfluous elements found on the desktop version.
– Speedy Development – Compared with alternatives, a mobile site can be built relatively easily. This is less labour-intensive and subsequently less costly than other mobile options.
– Mobile-Focussed – Development for the mobile platform means that navigation and usability are friendlier for mobile users.
– Slower Service – Redirection from main sites to mobile sites takes time. It may only be seconds, but it still damages the overall user experience.
– Double Maintenance – Essentially two sites need to be managed; adding new functionality would need to be done twice.
– SEO Issues – Since the content (and therefore the traffic) is split across two URLs, there’s the chance that your overall SEO will suffer. However, there are ways around this which I’ll outline later in this article.
We built a mobile shop-page for an automotive client. The desktop site’s main focus is selling car parts, so we stripped it down to the essentials to make it easy for mobile users.
#3 Mobile Apps
What are they?
Apps are programs that are saved to the device. They’re relatively small (compared with full websites) and they tend to serve one function (reading articles, shopping, checking-in). They can be a useful way to allow mobile users to access one of your site’s main utilities, or to promote your brand (with a game or similar App).
– Completely Mobile Friendly - Apps have the distinction of being native to the device, so they can access and utilize any of the phone’s capabilities (Camera, Calendar, Maps etc).
– Offline Options – While some Apps require the internet to function fully (social platforms), many others can operate offline, or cache data when an internet connection is available ready for when one isn’t.
– Quicker Loading Times – Since the App is self-contained, loading times should be quicker. Of course this depends on (and is limited by) the device’s memory and processor power.
– Push Notifications - Apps have the ability to update you with the things you need to know. Such as when you receive a new friend request on Facebook, or when you’re near a public toilet.
– No Cross-Functionality – Apps are made for specific platforms. iOS Apps will work on iphone or ipad, but will not be usable by Windows devices – or any non-Apple devices for that matter. This means Apps must be developed for each platform, which is expensive.
– Updates – Apps need to be constantly updated and tweaked. This is in terms of both user-feedback and changes to the device. This can be time-consuming and costly.
– Downloading – Apps have to be downloaded for use. Success in the App world may require considerable marketing and promotion.
We’ve applied appropriate aptitude to developing an App for a company that focusses on standardised testing. The App allows mobile users to practice the tests wherever they are.
The 4th Option
So those are your three options regarding adapting to mobile. There is of course a fourth option and that is that of doing nothing. Most website operate perfectly satisfactorily on mobile and indeed users who know your site will welcome the fact they do not need to relearn where everything is on the page and the new navigation options. This is a strong argument for keeping the status-quo which is not receiving enough credence now that the dash for “mobile first” has been triggered in marketing departments.
So in conclusion beware of the bandwagon, think about the implications before you jump. If someone says “Mobile first” to you ask them what they actually mean and what they want to achieve.
If you would like any more information, please get in touch.
And as a special thank you for reading this far, I’ll now present a guide on how to optimise mobile sites for SEO in the form of a Shakespearean sonnet:
You’ve built two sites; one desktop, one mobile,
But now you’re concerned that your traffic’s split,
And now you’ve come to visit Datadial,
To fix your SEO a little bit.
There are two points that must be mentioned here,
Two tags to put in your HTML,
(On each version of the page – let’s be clear)
They are two tags, and they both start with ‘Rel’.
Rel=”alternate” on the desktop
Make sure it points to the mobile and all…
And pointing back, just so it doesn’t flop
On mobile: Rel=”canonical”
But other things cannot be avoided.
Like linking to mobile, just like I did:
So basically add some links in the HTML of each page that look like this:
Desktop: <link rel=”alternate” href=”http://m.example.com/page-example”>
Mobile: <link rel=”canonical” href=http://example.com/page-example>
March 19th, 2013.
Over the past few decades, businesses which engage in advertising, PR and marketing have increasingly turned to research in the cognitive sciences to inform their decision making. The hope is that greater insight into the psyche of the consumer will ultimately lead to more profit. In recent years, the rapidly developing field of neuroscience has come to the fore with organisations as diverse as PepsiCo, Intel, CBS, eBay and ESPN utilising ‘neuromarketing’ company NeuroFocus to test for various physiological and cognitive responses to commercials, branding and products.
There is a straightforward reason for making use of such complex science:
We need some understanding of who and what we are communicating with, if we want to have any hope of them understanding us. This is why it is worthwhile incorporating an understanding of cognitive science, whether psychological, philosophical or neuroscientific, into an outreach strategy. Even a cursory glance over the cognitive science page of Wikipedia will reveal that our gut instinct about both ourselves and others is more often than not, flat out wrong. A good outreacher needs to dig a little deeper.
Classic Study: Behaviourism – Skinner and the Rat
Psychologist B.F. Skinner devoted the bulk of his career to the understanding of human behaviour. Perhaps his greatest contribution to cognitive science was his theory of operant conditioning, which holds that behaviours can be learnt on the basis of positive or negative reinforcement.
Skinner demonstrated his theory with a device known as the ‘Skinner Box’, which featured little more than a small container, a hungry rat and a selection of levers. When pressed, one of the levers would release a small pellet of food. Quickly the rat learnt to only press this lever if it wanted to get what it desired. Reinforced by the reward of food, the rat would readily repeat this action over and over again.
But what does this tell us about outreach?
It tells us that well-rewarded behaviour will be repeated. For example, if a journalist has posted an infographic before, had good results, then they are likely to do it again. They know the operation and realise the benefits. This factor of repeatability means that outreach is more scalable.
However, this is not to say that we shouldn’t outreach to those who have never posted infographics before. It took Skinner’s rat some time to understand the process, but once the behaviour is learnt, it is likely to be repeated. This is where persuasion and information kicks in. We wouldn’t dream of entrapping potential clients in a cage to reap some reward: in the rat’s case this was a bag of food, in our case it will be the prospect of driving traffic and awareness towards their website, or just spreading the joy of infographics. Our positive reinforcement will be much harder to enforce. So we have to provide examples of previous successes, as well as building trust to get clients pressing the lever for content again and again.
Wisdom of the Ancients: Emotion and Reason
In the great philosopher Plato’s famous analogy of the soul, emotion was two horses pulling a charioteer, reason, in opposing directions. The harmonious soul would be able to keep both emotion and reason in balance. A strong outreach strategy should have a similar aim.
- Marketers must be able to reassure the logical characteristics in consumers. A tug-at-the-heartstrings ploy may go over some peoples’ heads, or worse still, invite cynicism.
How does this relate to outreach?
- While using emotional hooks is important for content you can’t rely on it for all methods of outreach.
- Know your market. Some markets will not mind their emotions being pandered to whereas others will see this as little more than fluff, prizing ‘the facts’ much more highly.
A more integrated approach between the emotional and the rational will maximise the effectiveness of the outreach.
Recent Study: Optimism Bias and the Effort of Rejection
Optimism Bias:- Research into human decision-making suggests that humans are naturally hard-wired to believe.
It requires greater cognitive resources to question an assumption. It is more effective to believe something than to reject it. By nature, we are trusting. This is why big institutions, popular brands and institutions are built on popular belief and trust. To constantly test and question stimuli would be too draining on our cognitive resources.
How is this applicable to outreach?
- Spend time outreaching to larger influencers. Your content/image/post/media will have greater longevity and far reaching effects- people trust household names.
- Engage in an initial conversation to build the relationship, assuring and informing your outreach target. Eventually, once the aims have been met, it will be far less likely that your request will be denied due to the cognitive efforts of rejection on the receiver’s part.
- Have a full proof strategy, that way you are prepared to respond to any queries.
- This can also be applied to persuasion, turning a ‘no’ into a ‘yes’. It’s like a mental tug of war, making the effort of rejection even more exhausting.
- Well-rewarded behaviour will be repeated.
- Emotion and reason come hand-in-hand. A conclusion (logic) usually results in an action (emotional impulse).
- Determine the market before taking the plunge, whether a more emotive or logical method should be applied.
- Have a full proof outreach POA so that any queries can be met with total reassurance, making rejection less probable.
- Use other brands and institutions where possible to enhance your own content.
December 7th, 2012.
There are a million and a half blog posts about how Online Retailers keep their drop-off levels down; but what methods do they have in place to make you loosen up with your spending.
Charities have been doing it for years. Getting you to put your hand in your wallet is their speciality. Just when you thought you would ignore their pleadings something tugs at your heart strings. A little niggle that says “do it now, you know you want to”. Anyone who’s watched Jeremy Kyle knows what I’m talking about. Right after the Foxy Bingo guy announces the break, you’re confronted with 4 minutes of hunger-ravaged children reaching out from the Plasma Screen. It’s emotional Blackmail.
But it’s effective…
Online retailers are getting in on the action too. They haven’t quite gone down the guilt road yet (though I’m sure they would if they could) but they are playing with your mind to get you to ACT NOW and not go elsewhere.
…Pulling on the purse strings if not pulling on the heart strings.
It’s even more difficult to create that sense of urgency online, especially when it’s so easy to check prices and offers on other retail websites. Even a website has the right product at the price you’re willing to pay; you would more than likely check elsewhere. So the only weapon left in the web retailers’ arsenal is the notion that if you don’t buy something there and then, you’ll lose it forever.
So let’s see what online retailers do to keep us from doing a wider search, making a coffee, talking to the wife, walking the dog, looking up trivia from The Godfather, looking up how tall Andre the Giant was, looking up the longest recorded flight of a chicken, sitting on Reddit for 2 hours and then going to bed having forgotten we wanted to buy anything in the first place!
1) Act Now to Avoid Dismemberment. I mean Disappointment
You’ve probably seen this on concert ticket sites especially. “only 2 tickets available at this price – book now to avoid disappointment.” Is this really true? Can it really be the case that every time I search for an airline ticket, only 2 seats are available on the flight that I wanted to take? It’s the travel-ticket equivalent of a Saw trap.
‘All your life you’ve enjoyed a leisure of choice when buying things online, but now you have 30 seconds to decide, or lose… everything!’
It’s incredibly persuasive and a panacea for retailers who are faced with an audience of fence-sitters and flip-floppers.
2) Safety in numbers
‘17 others are looking at this item now’.
’29 people are watching this item’
‘143,343,123 people are scrambling for their card details so they can buy this item and you can’t!’
Talk about putting the frighteners up! Nothing invokes a reaction like a bit of competition. Regardless of whether it’s true or not, these stats make you feel two things:
a) This product is in high demand and might run out.
b) This product is popular, so it must be good.
Suddenly certain things like price comparisons seem less urgent. I was going to go and see if I could get it cheaper elsewhere but I can’t risk losing out to other shoppers. I might never see a Self-Stirring Mug at this price again!
The painful things about these methods is that you actually have no idea if it’s true of not. It could just be automated. But does the risk outweigh the reward? Probably not.
3) What’s in a Name?
‘Wayne in Manchester also bought this item’.
Although this isn’t one of the sweat-inducing panic-purchase inducers we’ve come across so far, it could be the push needed to get you to click ‘buy’. Chances are, ‘Wayne in Manchester’ isn’t your friend or financial advisor, so why does his opinion matter? It’s possible he’s not even real! But the fact that someone bought the item is enough of an endorsement to tip even the most frugal shopper over the edge.
If you don’t believe me; think of all those times you’ve been looking at an item on Amazon and thought ‘Nobody’s interested. There must be some hidden catch I’m not seeing.’ Or you’ve been browsing Ebay and seen an item with no bids: rather than thinking ‘wow. I must have stumbled on a bargain’, you think ‘I must be missing something here!’.
Maybe this says something about mob mentality, maybe we just like to follow the herd. It works well all the same, and ‘Wayne in Manchester’ is presented as the spokesman of wise purchasers and his presence on the page alone is enough to egg you on to buy something.
4) Is that a ‘Buy’ Button on Your Page, or Are You Happy to See Me?
Basic as the big [BUY NOW] button seems, it’s the dominant feature of the page.
For those of us who have gotten to grips with Traffic Signals, Green means GO! GO, GO, GO! So it’s no mistake that the only colour on the page is green, and subsequently the whole page screams ‘BUY BUY BUY’. Psychologically, we’re hopefully still capable of exercising some decorum; we are free-thinking people after all. But with structured, thought-out tricks like this, turning away has never been harder.
Even as I write this I want to click on the screenshot image, just to do as I’m told. It really sucks you in like a blackhole (or maybe a greenhole?). You have no chance.
5) And That’s Not All!
As well as all the mind games and emotional turmoil these companies make us go through to convince us to buy things; occasionally they’ll throw you a treat to sweeten the deal. Like when I recently bought 77 Antique Globes. The Price-Tag of £60,830.00 seemed a little steep and I must confess I was in two minds about whether to click ‘Buy’. But when I realised that the company offered Free Delivery, I couldn’t help but go ahead with the purchase.
Now I’ll never be lost again. But I will spend the rest of my life cursing myself for falling for the ‘free delivery’ option. Other sales incentives (also known as ‘close incentives’ or ‘things that are so cheap we can give them away for free without affecting our profits’) include ‘10% off your next order when you buy now’ and ‘Free warranty up to 30 days!’.
So now we’ve identified the ways in which online retailers fishhook us into a sale, we can go back to shopping online with a renewed sense of freedom. There’s no way any of us will ever fall for those tricks again.