Campaign Monitor is a SaaS email marketing platform that enables businesses to create, send, and manage branded email. The product includes a drag-and-drop builder, visual journey designer, and real-time performance metrics. It offers list management tools to help organizations build segmented lists based on their own criteria, and optimization tools to help users track the effectiveness of their campaigns.

Amazon S3 (Simple Storage Service) provides cloud-based object storage through a web service interface. You can use S3 to store and retrieve any amount of data, at any time, from anywhere on the web. S3 objects, which may be structured in any way, are stored in resources called buckets.

You can use Campaign Monitor's RESTful API to get data about clients, campaigns, lists, and more into your data warehouse. For example, to get a campaign summary, you could GET GET /campaigns/{campaignid}/summary.{xml|json}. The final parameter specifies whether the data is to be returned in XML or JSON format.

Here's an example of the kind of response you might see when querying a campaign summary and specifying that the data returned should be in JSON format.

{
    "Recipients": 1000,
    "TotalOpened": 345,
    "Clicks": 132,
    "Unsubscribed": 43,
    "Bounced": 15,
    "UniqueOpened": 298,
    "SpamComplaints": 23,
    "WebVersionURL": "http://createsend.com/t/y-A1A1A1A1A1A1A1A1A1A1A1A1/",
    "WebVersionTextURL": "http://createsend.com/t/y-A1A1A1A1A1A1A1A1A1A1A1A1/t",
    "WorldviewURL": "http://myclient.createsend.com/reports/wv/y/8WY898U9U98U9U9",
    "Forwards": 18,
    "Likes": 25,
    "Mentions": 11
}

To upload files you must first create an S3 bucket. Once you have a bucket you can add an object to it. An object can be any kind of file: a text file, data file, photo, or anything else. You can optionally compress or encrypt the files before you load them.

Now what? You've built a script that pulls data from Campaign Monitor and loads it into your data warehouse, but what happens tomorrow when you have new campaigns?

The key is to build your script in such a way that it can identify incremental updates to your data. Thankfully, Campaign Monitor's API results include fields like Date that allow you to identify records that are new since your last update (or since the newest record you've copied). Once you've take new data into account, you can set your script up as a cron job or continuous loop to keep pulling down new data as it appears.

S3 is great, but sometimes you want a more structured repository that can serve as a basis for BI reports and data analytics — in short, a data warehouse. Some folks choose to go with Amazon Redshift, Google BigQuery, PostgreSQL, Snowflake, Microsoft Azure Synapse Analytics, or Panoply, which are RDBMSes that use similar SQL syntax. If you're interested in seeing the relevant steps for loading data into one of these platforms, check out To Redshift, To BigQuery, To Postgres, To Snowflake, To Azure Synapse Analytics, and To Panoply.