This Weekend I Got To Alpha Test DotMailer’s New ‘Drag & Drop’ Database Query Tool

Almost a year ago to the week, I posted a blog on here entitled ‘I think I just saved myself half a day of work’ (yes I was younger then but my memory’s still good)

I’d just put together my very first campaign using dotMailer’s brand new beta release of our drag & drop EasyEditor, and I was feeling a glow.

Everyone who’s used our drag & drop EasyEditor since its beta release last year will recognise that glowing feeling. It’s just so nice… and quick… and easy to use.

The big query

So a year on, and a group of our Developers have been working cleverly to apply the speed and ease-ability of our new email template editor, to database query building (no such word as ‘ease-ability, I know, but hey – there was no such word as ‘unfollow’ 2 years ago!)

The objective: to make it really nice and quick and easy for email marketers to query and segment their data for super-targeted email campaigns.

This weekend I got to try out the new drag & drop query builder in dotMailer. It’s in closed alpha testing at the moment, but I got myself a special login so I could start playing and testing.

And guess what – I’m glowing again.

“Give me everyone who…”

Be honest now. Building database queries for targeted email marketing can be a bit stressful.

It takes a certain kind of mind to visualise logic statements and recreate them in query tools (remembering where and when to put your ‘ands’ and ‘ors’ and your ‘nests’). The query tools in some apps I’ve used have frankly made this a hopeless task.

The good news is that this new drag & drop query builder is going to make all that stress go away.

Check this out: As a starter I set out to build this database query in our new query tool;

“Give me everyone who is a current Platinum client, has purchased in the last 10 days, has not been sent any of this month’s January Sale promotions, or hasn’t opened any of our email campaigns in January”.


Quite a complex and tricky query by everyday standards, but it took me less than 5 minutes to build in dotMailer, just by dragging the elements of the query onto the page, and customising them.

I love this because the new query tool takes a highly visual approach to segmenting data.

It makes query building much more intuitive than traditional query tools, and so much less like a Maths exam.

If you’re interested in helping us test and hone dotMailer’s new query builder then you can apply to become a dotMailer Test Pilot.

Watch this blog for more news of the drag & drop query builder, and news of the full, out-of-beta release of our drag & drop EasyEditor.


dotdigital Hack Week 2020

This is our yearly challenge to our software engineers, product designers, deliverability consultants, and systems administrators to come up with forward-thinking hacks and put them into practice, ready to demo at the end of the week. Not…

How to write the perfect email marketing copy

Email marketing requires you to wear many hats – you have to be a designer, a data analyst, a workflow expert, and more. And, after all of that, you’re left with one of the hardest jobs of all:…

The 5 don’ts of email marketing design

Thrashing out a few friendly words in plain text might be fine practice for your average email to a friend or business colleague. However, when it comes to your email marketing campaign, your design strategy ought to…

This site uses cookies to improve your user experience. By using this site you agree to these cookies being set. To find out more see our cookies policy.