Is there any way to export all campaigns and analytics into one Excel spreadsheet?

  • 0
  • 2
  • Question
  • Updated 5 years ago
  • Answered
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Outdated

We would like to put together a list of all of the emails we sent in 2013 and in 2014, with campaign name and the number of people the email was sent to. Is there any way to mass export this? Thanks!
Photo of Alpha Gamma Delta

Alpha Gamma Delta

  • 20 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 0
  • 2
Photo of Matt Olsen

Matt Olsen, Champion

  • 117 Posts
  • 43 Reply Likes
Unfortunately not. You'll have to export each email one-by-one. What I typically do is just record the results of each campaign in an ongoing spreadsheet. That way, if I do need a summary, I already have the data and don't need to set aside a bunch of time to pull historical data.

Another option that might help is to click on the Compare Mailings button. You can select up to 5 reports at a time and it'll export a comparison table. This might be a quicker way to get the data you need instead of exporting each email's complete results one at a time.
Photo of Brandi Leath

Brandi Leath

  • 531 Posts
  • 67 Reply Likes
That's a GREAT IDEA Matt!!!!!! I just started pulling campaign comparisons not too long ago, and I am going to start doing that! (ongoing spreadsheet)
Photo of Brandi Leath

Brandi Leath

  • 531 Posts
  • 67 Reply Likes
Hi there! I've never tried exporting ALL for one year, not even two, but I do a monthly report for our managers that show each campaign sent for the specific month along with charts and a summary of the analytics.  The response analytics show how many people the email was sent to along with the click to open rates and what links were clicked on and how many times, etc.

I'm not sure if this will work for you, and I don't know if there is a limit to the number of mailings you can compare, but maybe it's worth a try.

Here is an example of the response mailing comparison I pulled from emma with no editing or formatting:


And here are my edits and formatting changes:



Hope that helps!!!
Brandi