Sunday, December 27, 2009

Grieben vs The List Rental

I think back to college and my direct marketing class and one of the first things they taught us is that a list rental or purchase can be a fast and cheap way to build a mailing list on short notice. In practice however, the general consensus is that the purchased list is the quickest way to waste a truckload of budget.


It makes sense though, I mean think a bout it if you were a vendor, in general you get paid by the name and are motivated to include more names not less which is a recipe for garbage data. Anyone who has been responsible for a Customer database also knows how quickly that data can become stale. A list rental makes things even more complicated because it has a limited use period attached to it.


Sometimes however that quick and cheap aspect can be too attractive to turn down. About a year ago one of the Marketing Coordinators I was supporting found such a list rental that would work great for their needs and jumped at the chance.


We had a number of challenges when this list showed up at our door. To start it was huge, I mean really huge. So big we had an issue just loading it. Our existing corporate policies dictated that before anything entered our CRM(which was required for mass marketing to the list) it had to be run through our de-dupe solution. The existing solution could process limited numbers of records per batch which meant that we would effectively render it inaccessible for two weeks based on the size of the list we had rented. That effectively put a stop to the upload of this list, at least that was until Eloqua was implemented.


Eloqua allowed us to batch upload this enormous list and quickly de-dupe it. It also however allowed us to handle the issue of managing the list rental extremely easily. Below I’m going to outline how.


The main issue is that you need to on a timely basis filter your rental list into at least 3 basic sub groups. First, pre existing contacts in your system, second are new and responsive contacts, and third unresponsive contacts. For this I used Eloqua’s program manager to create a automated program that sent a series of emails to the list to identify and attempt to engage contacts by promoting a library of content.


Its important to not here that the main objective of this program was to identify new contacts and get a response to qualify them for continued marketing before the rental period expired so this program could have become allot more complicated but in this case it was a get in get the response get out situation.


Below is a sample of the workflow I set up to handle the list. I didn't include screenshots because, anyone who has used Eloqua knows getting a complete picture of your program visible on one screen is near impossible, and anyone who hasn't used it probably wouldn't know what they were looking at. If you would like to see a diagram feel free to email me and ill put something together in Visio as an example for you.


Step 1. Was a starting holding step that fed the first decision rule.


Step 2. Was a decision rule to identify existing contacts and new contacts. The criteria I used was the creation date(today or before) of the contact to split this group into existing and net-new contacts.


Step 3. was another holding step for the two resulting groups of existing and net new contacts. From this point onward the program was almost identical but split into 3 parallel branches.


Step 4. This step triggered an identical email batch send. This email drove the recipient to a specific piece of on-demand collateral a white paper or recorded webinar.


Step 5. This step in the program was a decision rule that waited 2 weeks and evaluated each contacts activity. In both groups if the contact had a hard bounce or unsubscribed they were added to our opt out list and moved to the final step of the program where they were held.


Step 5A. If they were in the existing group and submitted the download form, they were removed from this program and added to our Global Lead Scoring program.


Step 5B. If there were a member of the net new group they could one of two things happened, either they opened the email or they didn’t. If the email opened the were moved to a third parallel program. If they submitted a form the were bounced to the Lead Scoring program. If they opened but did not submit they were moved to the next email promoting content and another two weeks and another activity evaluation.


If they didn't open the email they were also sent another batch email promoting another piece of content and another two weeks and another activity evaluation.


This continued until contacts in the list opted out, submitted a form, or time on the rental almost ran out. At the end of this period we were left with 2 groups a group of contacts who have never opened an email and a group that opened emails but never submitted a form. These two groups are the contacts we had no previous interactions with, or we were not able to generate interest with and because of the rental agreement had to now remove from our system.


Using the Eloqua program builder we were able to build a program that de-duped a large list, identified contracts with interest, and cleaned both list data and existing contact data by initiating a form submit. and because it was all automated we were able to set and forget the program until it came time to remove the non responsive contacts from the system


Saturday, December 26, 2009

Grieben vs The Introduction

Welcome to this my inaugural post...


As cheesy as it my be, I thought this fist post should be autobiographical in nature, to serve as both an introduction and a way to establish(or discredit as the case may be :P) myself as a subject matter “expert” in the area of marketing and sales operations.


I say expert with some apprehension because I have always been a firm believer that, regardless of how good you are at something, there will always be someone better. With that in mind, I would like to use this blog as a place for myself and others like me to share tips and tricks they have learned on the job to help deliver on some of those harder to deliver request from people up the management chain.


So on to my background. I have been a marketing professional for the past 2 years. I started my training in marketing in night school. This was because prior to this I had been under the misguided belief I should be a Plumber. After quickly learning the error of my ways I started taking night school, and transferring into the full time class as soon as possible.


A college certificate in Marketing and Bachelors of Commerce later and I was working in marketing. I started as a marketing assistant at a small software company based in Victoria BC. There I learned my way around Salesforce.com while doing some data quality work and contact acquisition. It was a great environment where I had the freedom to explore the CRM while conducting my daily duties and got to learn some of the associated tools like the Data loader and excel connector. My time there came to an abrupt end during some downsizing but ill never forget my time out there, working 30hrs a week while also going to school.


The downsizing however worked out for the best, it freed me up to to return to Ontario and take a position as Field Marketing Data Coordinator. I’ve worked with a great sales ops team and a number of tools including ExactTarget, RingLead and part evaluation of a marketing automation system and subsequent global implementation of Eloqua.


This has all been a great learning experience and I wanted to try and share some of that knowledge with other marketers and ops people out there. I want to invite any readers to contact me about any posts or suggestions for future topics and ill try to helps solve any issues out there in the community or help get in touch with the people who do.