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.