Through our extensive travels around multiple email platforms we have noticed that whilst they all do the basics really well, sometimes there is just that missing bit of key functionality that you long for, or it just doesn’t quite work how you want. So, you find yourself doing things the hard way and dreaming of a day where all you need to do is push a button and it all magically happens. But how can you fill the gap?
Well, we thought “why not do something about it?” and came up with our own solutions that anybody can take advantage of. Fortunately, most email platforms provide their own API integrations so these solutions, where required, should be adjustable to suit each platform.
Fill the gap scenario 1: list splitting
You may have a list held in your platform and for whatever reason you need to split it into 2 or more chunks. In theory this is possible with A/B testing but not if you need it for some other purpose.
The hard way: download the data, stick it into a database, run some SQL on it to output however many chunks you want, reimport.
The easy way: use a tool which lets you enter a list identifier, what you want to call the new lists and how many splits you want and it will run the downloading, SQL and reimporting for you whilst you eat that biscuit.
Demo
Here’s a demo of how a tool to split files could work (since it’s a demo we’re restricting to a 1 column file, txt or csv only, and we’ll only split out 100 records):