Use this spreadsheet to design and implement triggered email sequences
- Created by: Dave Chaffey and reviewed by Tim Watson
- Last updated: April 2012
- Format: Excel spreadsheet designed to help you summarise and plan the sequence so it can be implemented by a technical team
About the Email contact strategy spreadsheet
Research shows that behavioural email marketing is a powerful technique to automatically follow-up online customer actions to help increase conversion to sale at a low cost. However, the technique is still used by relatively few companies. One barrier to setting up these event-triggered email sequences is the time it takes to specify the sequences if it’s a new approach to the company or agency.
This spreadsheet provides a template for marketers to create a messaging sequence that supports their business for the range of potential event-triggered campaigns including:
- Welcome sequence for a new subscriber or lead to an email list
- Welcome sequence for new customer (onboarding)
- Reactivation of customers or subscribers who lose engagement
- Abandoned shopping cart follow-up emails
- Shoppers browse or search on a site but don’t buy follow-up
- Time to repurchase or replenishment emails
Who will find the spreadsheet useful?
The spreadsheet will help collaboration between a range of people who may be involved with setting up and reviewing behavioural email campaigns including:
- Marketing or Ecommerce managers responsible for creating communications strategy
- Email marketing execs
- Email or digital marketing consultants
- Agency or email service provider consultants
What does the spreadsheet include?
This example template was developed for an event-triggered “Welcome” email sequence based around a brochure download. It’s a classic inbound/permission marketing lead generation approach which can be used for B2C or B2B campaigns where access to content or a trial service is given in return for an individuals details. The template includes 3 worksheets including:
- A grid showing a row for each message in the sequence with 16 columns (some optional) for defining communications requirements, targeting, trigger rules and messaging. 3 Example fields are shown for an email sequence
- Read me explaining how to use each field with an example of how to lay out the creative
- A template of 8 other campaign control issues that must be defined including tracking, testing, unsubscribes and message suppression
You can read more about how to plan email sequences in this introduction.
What our members say about the Email sequence contact strategy template
Smart Insights has helped us take the right decision on a variety of occasions and we actively use its content to justify our marketing initiatives and spend.
Joao da Costa, Marketing Officer at Southbank International School
We are at the early stages of our digital marketing journey, Smart Insights templates and tutorials help us check and learn as we go.
Stuart Sykes, Digital Marketing Manager
Smart Insights is one of the best digital ‘tools’ on the internet today. It has been a great asset as a channel of advice and insight, helping me to deliver an all-encompassing digital strategy.
Jennifer Law, E-Communications Manager, National Pharmacy Association
You can access this advice if you are a Smart Insights Expert-level member.
Smart Insights Expert Members get "at your desk access" to in-depth advice to improve their online marketing skills and capabilities:
- In-depth Ebooks
- Online training
- How to
- Marketing templates