Under The Bonnet Of DotMailer’s Databases

Over the last weekend we performed some important database maintenance.

In short we’ve changed the way we store our data. In particular, we want to give our API users, and our CRM connector implementers (See our year of the connector blog post!), the ability to retrieve changed data from campaign reports, enabling deep and detailed integration

So, rather than asking the API for all your campaign recipients, you’ll now be able to ask for anyone who has interacted with your campaign since a certain date. This will make it much easier to get quick catchup exports into your CRM system.  We made the database change last weekend, and subject to testing, the API methods will follow shortly.

We’ve also changed how some of the underlying data storage is laid out in our database.

dotMailer has a lot of powerful database features including email client analytics, geomapping, over 400  custom data fields, not to mention storage of microsites, surveys and SMS.

We need robust and future-proof storage for all that new data. So we’ll be moving a lot of data around our storage silos to get better performance and room for growth.

As usual, you don’t need to do anything – just sit back, relax, and leave the heavy lifting to us.

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…

Top five content trends for 2021

Indeed, a recent Accenture poll concluded the average consumer has “dramatically evolved”, while a YouGov survey found 27% of consumers say that item cost is now a more important factor when shopping as half of workers have…

Customer experience: how to improve key customer touchpoints

How to improve customer experience has been at the top of marketers’ minds for years. We know that customer conversion and retention are based on the experiences we deliver. As brands grow, we start looking for new…

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.