I'll teach you to send better emails...

Join over 4,700 other subscribers.

This is a guest post by Tzvi Balbin. Read more about Tzvi after the post! Big data is changing the way we sell our products online. Once only at the fingertips of companies like Amazon, a new era is upon us. It’s easy to get caught up in the buzz words but, back in reality, how can you actually put the concepts behind big data to work in your campaigns? Despite the fact that, for most of us, true big data analytics is still a long way off, sending powerful personalized email campaigns is certainly possible. In fact, it’s been possible from day one! It’s been right under your nose: you just need to think outside the box. This following campaign is one that I recently used to create a true viral effect and drive revenue from outside our list. Let’s break it down step-by-step.

1. How to send targeted emails like a big data pro

Initially working with a client to improve their deliverability, I was doing some research into the ISPs that were represented in their marketing list. I asked the simple question “What ISP’s are our subscribers using?” To do this I used a simple formula in Excel: by removing everything before the “@” symbol I got a list of every domain represented in my client’s subscriber list. Here’s the formula: Advanced email marketing personalization Here’s the result: a list of email addresses in one column and their associated domain in the other. My results looked a bit like this: Advanced email personalization Using an advanced filter I then did a count on each of the unique domains in the list before exporting the result and graphing it on two axes: X representing the domain name and Y showing the count for that domain. The result was similar to this graph: Email marketing long tail This is when things start to get interesting. You will notice that this graph looks similar to a long-tail search report: the majority of customers fell into obvious domains like @gmail.com or @live.com but a huge portion fell into other, more specific domains. This got me wondering: how can I take over the world using that long tail? That needs a little bit of investigating Watson! At scale the breakdown for most lists will be divided into four sections:

  1. Major ISPs: Gmail, Hotmail, Yahoo
  2. Smaller ISPs: Bigpond, iinet (these are Australian mid size ISPs)
  3. Big corporations with large head count: CommBank, JPMorgan, MinterEllison, Allianz Insurance, Walmart, etc.
  4. Small businesses: Bob’s Plumbing, Tim’s Accounting, those sort of businesses.

…buckets three and four are the true long tail here. This is where I discovered a golden opportunity for some unorthodox, personalized email marketing. What if I used the domain name that they subscribed with to personalize an email?

2. The nuts and bolts: what we did

Using each of the domains in the list, we added a new column to our email marketing database called “company”. For example, if I worked at Qantas my email might be user@qantas.com and my “company” value would have the entry Qantas. If I worked at Coca Cola and my email was user@coke.com my company column would read Coke and so on. We decided we were going to send out a ‘special offer’ for each of these companies so we created a coupon code for every single company mentioned in the ‘company’ column. My thought process was that customers at individual businesses and corporations would respond positively to a personalized coupon code: a code that looked like it was just for them. At work people sit in close proximity. The idea was to exploit this phenomenon and get people to share and talk about the discount they had just received because they worked at Qantas. I wanted to test the theory that they’d share this email within their place of work. The email we created used the dynamic coupon codes twice in the email: once in the subject line and once in the actual email. It was a bit like this: Dynamic email marketing personalization Awesome…and kind of spooky! Picture this: Rachel receives our email and leans over her cubicle to Matt Rachel: “Did you get that discount from [insert your brand name]?” Matt: “Nope, what’s the discount?” Jimmy overhears Jimmy: “It’s a discount on [insert products here]. The code is [insert dynamic coupon], just head to domain.com to grab the deal.” …let the viral spread begin! In general, and especially at work, people feel validated when they share good information: it puts them in a position of “power” or “aloofness”. As such Rachel and Jimmy should be happy to share the personalized deal because it is a way of saying “without me you wouldn’t have received this discount”. It’s just human nature.

3. Show me the money: measuring the viral effects

Next morning I logged into Google Analytics to see how the campaign went. It went really well. Christmas-came-early well! Here are some results:

  • Open Rates: increased by 32% over our regular statistics
  • Click-through rates: increased by 55% over our regular statistics
  • Average Order Value: increased by 13% over our regular statistics
  • Conversion rates: up by 86%!

Google Analytics specifically measured the clicks and the associated revenues the email had generated…but I went a little further and ran a query on our database to display all of transactions that had used one of the coupon codes from the email campaign. I discovered that the total revenue figures were approximately 35% higher than what Google Analytics was reporting. Why? Then it hit me: database revenue minus Google Analytics revenue was essentially equal to the viral effect of our campaign – in cold hard cash. The difference represented those who hadn’t received the email but whose colleagues told them about the discount. In most instances Google Analytics recorded these customers as direct visits and attributed the revenue to that channel, whilst the people who actually received the email and clicked it had the revenue attributed to that correct email campaign tag. An extra 35% revenue thanks to customers sharing your campaign? Yes please! On the back of this success we started sending this campaign monthly. Even better, there might even have been a flow-on effect? Assume for a moment that the many of the customers who ordered on that day got their products delivered to their workplace. After their orders are dispatched not only do they arrive on the same day but all at the same time. Imagine you’re at work and 10 people get parcels, but you don’t. You’re bound to ask “What’s going on?” And inevitably one of your colleagues will tell you “there are monthly discounts from [insert your company name] just for us. Subscribe with your work email and they will send you one.”

Seriously viral

The following two tabs change content below.
Tzvi Balbin Tzvi Balbin is an experienced digital marketer previously heading up online marketing at CatchOfTheDay, one of Australia's fastest growing online retailers (raising $80m in 2012), improving their conversion rates by over 25%. He now runs his own conversion-optimization consultancy, Userlicious and shares his wisdom with eCommerce stores the world over. You can find him via @tybalbin and on .

Want to write your own killer emails?

This email marketing 10-step Cheat Sheet will help you dominate your campaigns

  • Keiron

    Great article. Shanks for sharing this!

    • http://twitter.com/chexton Chris Hexton

      Tzvi is a boss Keiron, glad you liked his story. Am sure he’d be more than happy to share a bunch of other great campaigns he’s used in the past if you get in touch. Hope all’s well!

  • http://twitter.com/dfguo Dafeng

    Great sharing! Looking into applying the techniques!

    • http://twitter.com/chexton Chris Hexton

      Let us know how you go Dafeng!

      • http://twitter.com/tybalbin Tzvi Balbin

        Looking forward to hearing about the results. The example that I used was for a retail client, would love to hear what vertical you apply this too.

  • Shai

    Great work Tzvi! Love the sharing!!!

    • http://twitter.com/chexton Chris Hexton

      Thanks Shai, super awesome post eh.

  • http://twitter.com/jasonpschulz Jason Schulz

    Unreal! Love how you broke down the process into practical steps Tzvi!

    Certainly a unique approach you were able to find.

    • http://twitter.com/chexton Chris Hexton

      Totally agree with you Jason. The detail gives a real insight into how to build and measure a successful campaign.

      Thinking outside the box is always a big part of the challenge though :).

    • http://twitter.com/tybalbin Tzvi Balbin

      Thanks Jason – Sharing is caring :)

  • http://seorewind.com/ Chris Countey

    Super actionable. Thanks for sharing!

  • Slava Rybalka

    what a great case study! Thank you Tzvi!

    My only question is – aren’t these emails officially classified as “spam”?

    • http://twitter.com/chexton Chris Hexton

      Hey Slava – as long as you have the customer’s permission it’s not spam. In this instance the list Tzvi was using was the company’s in-house opt-in list. Everyone had given permission to receive special offers and this was just a clever example of personalization to really nail the execution!

      • http://twitter.com/tybalbin Tzvi Balbin

        Spot on Chris. And thank you for the feedback Slava!

  • Matty

    Apologies for the somewhat amateur enquiry but I’m an excel novice!

    Once I have all the domain names separated in another column…how do I group those similar domains together rather than count through the list and individually mark.

    • http://twitter.com/chexton Chris Hexton

      Sure thing, I can’t recall how to do it in Excel but Google Docs has this awesome ‘unique’ function: http://drops.getvero.com/image/3m0J341T1N2v.

      Then just do a =COUNTIF(A:A, B1) in the third column to get the counts to do your graph!

  • http://twitter.com/ishfuseini ish

    Great insights! There seems to be many opportunities right under our noses. I’ll have to give this a try and see how it performs.

  • Pingback: Search Engine Weekly Round-up #26 - Wow Internet Blog

  • http://twitter.com/JeanCarloHim Jean Carlo Him

    This is the most awesome thing Ive see in email marketing. Great Job. ( We dont need marketers… we need creative people) KUDOS!

  • Pingback: Viral marketing

  • Pingback: Viral Marketing: The Short Story Of A Targeted Email Campaign That Went Viral | Bethesda Emedia Marketing

  • Pingback: 3 Secrets Of List Segmentation | Vero Email Marketing Blog

  • Octavia

    This is brilliant! Well done Tzvi and thanks for sharing! I will try this bit of creativity in our next email campaign.

  • Pingback: What Selling B2B To Millions Teaches You About Email Marketing | Vero Email Marketing Blog

  • Pingback: How To Send The Newsletter That Made 35% More Revenue | Vero Email Marketing Blog

  • Pingback: The 9 Best Email Marketing Tips From 2013 | Vero Email Marketing Blog

  • Pingback: 5 Ways To Kick Start Your Email Marketing This Year

  • Pingback: Email Like A Pro: 20 KILLER Lifecycle Email Campaigns From 2013 | Vero Email Marketing Blog