All of our email test data lives in a giant spreadsheet, and all the data in hand-keyed by me :) I do this about 2-5 times per row of data, as we often have to refresh results over time, so I probably spend about 5-7 minutes per row of data in a given campaign.

In Q1-Q2 of FY14-15 we sent 365 different email segments, so 365 rows of data. That came about to 30-40 hours of my time. Our list has almost doubled in size since last FY, so I'm estimating my time spent could double too.

Here's that Q1-Q2 data for reference: https://docs.google.com/spreadsheets/d/1lzBDN_PIcS8gOlPdqPsuen6Mr2MNqpMcs3utn_90V-U/edit#gid=0. We now collect 15 more data points from ecom than we did before, so time spent on this has increased.

@awight mentioned he wrote some code for Zack a couple of years ago which spits ecom data real-time into a Google spreadsheet. He also says it's possible to use Silverpop's "very good API" (his words, not mine :D ) to import the open and click data I need from their side.

It would be awesome, both for my time, but also for our European colleagues who don't want to have to wait for me to update data, to use this script. If we don't have a tool like this in place by 2016, I'm planning on recommending a few proprietary tools to use instead.