There is no single place where one can find complete email performance data. Silverpop holds the sent, bounces, blocks, unsubscribes, and opens data. The pgehres on lutetium database holds clicks. Contribution tracking has the donation data.
Having some data exist in Silverpop only is bad for 3 reasons:
- They only hold our data for 450 days. That means all email templates, all historic opens, unsusbcribes, everything goes away after a year and a half
- It's really hard to so more sophisticated reporting when the data is this siloed. Trying to pull lists based on email behavior alone right now is too complicated to justify the effort (i.e. a list of people who opened the last email we sent but did not click). If I could query the data all from the same place (joins notwithstanding), so many of my reporting needs would be resolved.
- Donor Services and Major Gifts are missing a ton of visibility on what any single donor's experience has been, because they don't know what emails they've received.
I know @Ejegg started looking into Silverpop's API calls to integrate data about 2 years ago, and then Worldpay happened. What would it take to make this a priority this year?