Easily track the rise and fall of your top customers

Ever wonder who the movers and shakers of your database are? Finding out who your top customers are and then showing them your gratitude can help build longer lasting and more prosperous relationships with them. Equally, rooting out those that have become less interested over time is another avenue to explore to find ways to bring them back into the fold. To illustrate the point, we developed the “Top Customers Chart” (updated on a monthly basis) which would highlight the risers and fallers in your database and from which you can easily pick out the customers that need special consideration as your follow their journeys over the months. Top 100 Customers of All Time To get started we need to…

Trend analysis for insights into your email marketing

Analysing all your data, whilst massively rewarding with the insights you gain, can be a painful exercise and may leave you feeling like you’re drowning. Spotting trends is a great way to see what is going on with your email marketing – are your opens, clicks and conversions rising / falling, how is your deliverability, which are your best performing campaigns? This can end up being a huge task with potentially gigabytes of data to trawl through, and with platform limitations restricting how far back you can go, your insight may be limited to platform specific timeframes. Since we love to go the extra mile, we developed our own system agnostic reporting suite (hosted online) which pulls data month by…

Profile your data for smarter marketing

We’re in an age where knowing as much as possible about your target audience is essential if you want to get the most out of your direct marketing as possible. Personalising your email marketing will likely increase opens, click-throughs, sales and revenue. This is where making a profile database can come in handy – collecting as much information about each of your users as possible to assist in sending relevant content at the best times. So, what are the nooks and crannies you can delve in to procure this valuable insight into your data? Profile: Sign-up One easy area where you can gather useful information is during the sign-up process for such things as creating a customer account. Here, without…

Counting domains the easy way

If you ever want to know the breakdown of domains for a list of emails without the rigmarole of having to import them into a database first, then here is a simple but handy JavaScript tool to do just that (which means you don’t need any special software to use it – any web browser should do the trick). Step 1: Create your input form First create your form which will have a textarea to input the list of emails, an input for the number of domains you want to output, a run button and a reset button. <form name=”form1″> <table> <tr> <td><h3>Input Emails:</h3> <fieldset> <textarea rows=”30″ cols=”40″ name = “TextAreaInput”></textarea> </fieldset>   <fieldset> <strong>No. Domains to Count:</strong> <input type…

Try reactivation before inactivation

Experience shows that many companies struggle with the concept of culling old data as they naturally want as big a pool as possible to target with their email campaigns, which is of course very understandable. However, as data ages there is no denying it becomes old and tired. Addresses may no longer be valid, they may stop engaging altogether and the risk of spam traps sneaking in increases, all of which will do your reputation no favours and may ultimately hurt your chances of delivering to your fresher, more engaged data. It is therefore very advisable to follow a hygiene process and be willing to get rid of old and unengaged data before it starts doing more harm than good.…

Choosing the right way to build up your email database

There are a few ways to build up a database – you can encourage people to sign up via your website or in-store, you can collect addresses through industry trade shows and exhibitions or you could even obtain data from list rental companies for people that have indicated they are willing to receive third party emails. We’ve actually tried all three methods over the years which gives us the perfect opportunity to find out which of these methods is likely to yield the best results to help shape future email marketing strategies.   Database Retention So, one key identifier toward the quality of each data source is the database retention i.e. what percentage of the database is still active for…

Time waits for no man…or email campaign

A question that bugs many an email marketer – is there a best day and/or time to send a campaign? You’ll probably find lots of sources telling you that Wednesday is definitely the best day, or 9am is always the best time, but it is hard to imagine one size fits all and engagement simply must be reliant on other factors than simply what time you press go. All you can do is analyse your own data to see if there is an obvious pattern. I thought I’d give analysing a 3-month dataset, which includes campaigns sent throughout the week and at various times in the morning and evening, a whirl to try to tease out any nuggets of insight.…

Dynamically created graphs for easier trend interpretation

One of the best ways to see how your data is performing is to analyse trends. You may have, for example, a nice, easy to interpret worm wiggling its way upwards on a line graph which obviously shows your metric is increasing over time. However, some forms of data cannot necessarily be displayed in such a flat format, and may be better viewed dynamically. For example, say you were looking at which email devices and browsers were being used to actually open your emails. The best way to show it is probably in a pie chart to see which devices have the biggest shares, but if you wanted to look, say, month by month to see if any device was…

Top 5 Tips for Script Writing

Due to the nature of my job a lot of script writing (SQL in my case) is done on the fly and is often written in an ad hoc fashion. This is fine for my personal use (that is until I look back an indeterminate time later and have to decipher my own work whilst trying to remember my reasoning) but if a bus that has my name on it were ever to strike me down my successors would undoubtedly struggle with some of my scripts. So, here are my top 5 tips on how to check and maintain the integrity of scripts and to make them accessible for other people to read, run and adapt if necessary.   1.…

Big Data is great but don’t forget about the small data as well

Big Data is definitely in vogue at the moment with companies looking to find ways to improve sales and operational efficiency through analysing huge volumes of data searching for industry and commercial patterns. Whilst the expense of such an endeavour may be a little off-putting for some smaller companies, this doesn’t mean you should forget about the potential in your own data and those nuggets of insight you can glean from in-house analysis by getting caught up in the Big Data wave. Understanding your own customer behaviour is a great way to figure out where your customers are most likely to become disengaged (or disappear entirely) allowing you to target them more effectively to see if you can encourage them…