Entries Tagged 'Marketing' ↓

7 Quick and Easy VBA Macros & Tips for Excel

With large PPC customers comes large problems! Manipulating keywords and producing new combinations is great when you have 50 keywords, when working with 50,000 keywords the PPC professional needs to make a choice between getting RSI and getting their macro on!

With very little knowledge you can brute force a lot of simple problems using macros, here is a quick introduction to macro semantics and some functions that PPC has called for!

Continue reading →

18 Simple Tweaks To Get More Clicks From Your Organic Rankings

icanhastitleoptimisashon

How To Create The Perfect Page Titles & Meta Descriptions

If you’ve been working in search optimisation for any length of time you’ll have heard how important it is to properly optimise your page title tag. Chances are you’ll also have heard that the meta description is also important, but on a lesser scale.

I agree wholeheartedly: getting your onpage SEO dialed in is critical. It’s much easier to rank a site that ticks all the onpage boxes, but that’s not to say it is impossible to rank a poorly optimised site through sheer brute force. However, I would rather make a job easier in the long run and so before I start trying to build links into a site I like to get the basics sorted.

Getting your titles and meta descriptions done properly is a painstaking and at times arduous task, which is something I can attest to. However, when you see the fruits of your labour, ie. ranking higher, then it can actually be a rewarding endeavour. So here we are: 18 tips to help you optimise your page title and meta description.

Continue reading →

Rails: ‘Has_many through’ Association Across Databases

So recently I had the challenge of creating a ‘has_many through’ relationship across two databases.

“Why would you do this?” you may ask. Well quite simply I am in a team building a new data management system to sit on top of a legacy system with its legacy database. All the new code is new, shiny and streamlined and the old code is… well… crap but we have to keep both systems running concurrently so we have various tables in the legacy database we need to access from the new system. As it happens we need to access the legacy users table in a ‘has_many through’ from the new ‘orders’ table.
Continue reading →

7 Reasons Why Guest Posting is Integral to Any Linkbuilding Campaign

Chain LinksThere are many ways to build backlinks. There are many ways to waste your time building backlinks too. Anyone who has ever been involved with a prolonged linkbuilding campaign will tell you that it’s hardly the most glamorous of jobs, nor is it particularly inspirational. Days go by in a blur of emails and weeks tend to endlessly slide by in a blaze of IM chats, forum PMs and phone calls. All this and it can still take months before the fruits of your labour are manifested in better organic rankings.

Let it be known: building links is not easy. Therefore, it makes sense to invest your time and effort in something that just works. And for me, that means guest posting.

Continue reading →

PPC Optimisation: 5 Ways To Track Phone Sales From PPC / AdWords

Old TelephoneHow do you measure the true return on PPC ad spend when phone leads or phone sales are not being taken into account?

If we take a typical e-commerce store as an example, up to 35% of sales can be taken over the telephone. Accurately attributing these sales can make a big difference to how you optimise your PPC campaigns, and have an effect on the overall ROI from paid search marketing.

Most web analytics solutions do a great job of tracking where sales come from, be it from organic search traffic, direct type-in traffic or PPC traffic. However, the source of telephone orders is one area that site owners often choose to ignore because it’s difficult to track.

Here’s a few ways to track PPC traffic that generates orders over the phone.

Continue reading →

How To Linkbait E-commerce Stores: 15 Tips For Success!

Linkbait HookI’ve seen all manner of overtly commercial sites trying their luck with linkbait, only for it to flop. You see, linkbaiting your e-commerce store is a difficult thing to do and unless you have built your brand from the ground up to infiltrate integrate on social media sites, successful linkbait and the bounty of oneway goodies it affords may continue to be nothing more than a dream.

I suppose in one way it is our own fault for perpetuating this fallacy of marketing. Reading through the plethora of posts about linkbait makes this particular technique seem like some crazy next-generational solution to marketing any site. The reality is, however, very different. You’ve got to work incredibly hard to make linkbait on a commercial store work and be prepared to sustain your efforts even though many of your baits get no traction and go precisely nowhere.

There’s little doubt in my mind that Digg et al have moderators and systems in place to identify commercially motivated linkbait, and even if they don’t, the community itself definitely doesn’t want to see our ’spam’. The good old days of pushing ‘10 Cooking Tips From Holywood’s Hottest Celebs’ to help promote some recipe book store are long gone.

Don’t get me wrong: linkbait is here to stay, but we must progress. The broader SEO community may have only recently caught on and crowned linkbait as the white-hatted linkbuilding prince, but we’re only getting started down the road of punchy titles, angles and hooks compared to our friends in the traditional mainstream media.

So if you are responsible for marketing an e-commerce store and want to try linkbait, be prepared to work harder than you have before to create unique, interesting, timely and resourceful content that real people actually care about and want to read.

Here at Setfire Media we specialise in building online stores. So as ‘Head of Search’ I’ve been in the trenches for long enough to hone the process of linkbaiting an e-commerce store and can say with surety that there are things you can do to help improve your success rate on social media sites - a checklist if you will.

Here are a few things I’ve learned that you can apply and hopefully find more success.

Continue reading →

9 Tips to Help Your Website Cope With Huge Traffic Spikes

There are times when your website might experience short periods of very high traffic. This could be the result of TV exposure, or your linkbait just hit the front page of Digg. The worst thing that can happen at this point is that your site can’t cope - this becomes a huge missed opportunity.

Here are some tips to help you plan to stay online and available.

Continue reading →

Email Marketing: 15 Essential Tips for Increasing Sign-ups to Your Mailing List

Email marketing to a subscribed list gives businesses a fantastic return on web marketing spend. A quality email list partnered with a targeted, well written email can out perform SEO, PPC and just about any other marketing activity every time.

The key to successful email marketing is building up your list of newsletter recipients. The equation is simple, the more people you email the more sales, and response you’re going to get. Every subscriber counts, and if you’ve got your analytics rockin’, and measure the sales you get from email marketing, you can attribute a per subscriber value to your list.

Here are 15 ways you can increase the number of people signing up to your mailing list:

Continue reading →

Social Media Epic Fail: How to Build Links to Linkbaits That Don’t Go Viral

Epic Fail

Linkbait is widely regarded by many SEOs as the premier weapon in their quiver of marketing and promotional tools, and justifiably so. When linkbait is successful it can be incredibly powerful, driving an initial spike in (arguably entirely useless) traffic and links, followed by a long and steady stream of backlinks.

That’s the best case scenario. But what happens when your linkbait just doesn’t cut it? Digg, which is the granddaddy of social media sites, is where most linkbait gets peddled. Digg is also subject to random system maintenance and drastic algorithmic changes. Other popular social media sites such as Reddit and StumbleUpon can also be hit and miss: what works one day might have no hope the next.

Of course, it isn’t all dependent on where you distribute your linkbait. It may well be the case that your ‘101 Reasons For Choosing Acme Exhaust Manifolds’ just doesn’t appeal to the crowd and is destined to fail, even if it does get 275 diggs and all manner of thumbs up.

So what if this is where you find yourself? What should you do if your linkbait, on which your client has spent good money and you’ve invested copious amounts of time, goes nowhere? Well, for what it’s worth, here’s what I would do.

Continue reading →

Introducing the New Froogle Performance Dashboard

Google have finally released a new Froogle Performance Tool which shows a host of useful data about your Froogle impressions, clicks and feed items. You can find it by logging into your Google Base account and clicking on the new Performance section.

Optimise your froogle feed

Google Product Search, or Froogle as it’s far better known, is a price comparison site with a big difference – it’s completely free. This makes is an attractive channel to reach your customers; all you need is a product feed.

Like so many other digital marketers, I’ve been waiting on this tool to optimise Google Product Search for ages – I’d even gone as far as to previously develop a dirty Excel hack that queried Froogle data. The new froogle performance tool now provides all this data in a choice of slick graphs or CSV downloads.
Continue reading →