Extracting campaign data

Have just inherited a CM install which has 100+ campaigns loaded, each with a separate list – i.e. one list, one campaign. The recipients will each exist on many lists. What I’m looking for is a campaign / subscriber export which will give me subscriberemail, openY/N, opendatestamp, clickY/N for each of the campaigns.

Firstly, can opendatestamp be exported with Open Y/N and Click Y/N for each subscriber?

Secondly, can multiple campaigns be rolled up into one extract?

Any thoughts / advice, etc greatly appreciated.

roshodgekiss roshodgekiss, 6 years ago

Hi robainnes, welcome the the forums! Sounds like you've got a lot of data on your hands here.

What you ultimately need to do us export the 'Recipient Activity' campaign report for each of these campaigns. This will give you a list of subscriber email addresses, plus open and click stats, however it won't provide timestamps for these events.

You can't export event timestamps for individual subscribers at this time, however we're happy to note your interest in this and consider it for a future update.

Also, it isn't possible to download multiple reports in one go via the app, but potentially our dev team could help you with exporting multiple recipient activity reports. No promises here, but kindly get in touch with our support team and provide your account and campaign details and we'll do our best to help. All the best!

Get in touch with us on Twitter: http://twitter.com/campaignmonitor
We're also on Facebook: http://facebook.com/campaignmonitor
robainnes, 6 years ago

Hi Ros, thanks for the reply and the suggestions. I do hope that exporting event timestamps can make it into a future release - could be very helpful.

See why 200,000 companies worldwide love Campaign Monitor.

From Australia to Zimbabwe, and everywhere in between, companies count on Campaign Monitor for email campaigns that boost the bottom line.

Get started for free