We use Analytics to track our appeals, including the responses to each source.
However, I don't see any Analytics option of No. of Contacts from Appeals and Sources promoted to each source. Is it really not included in any of the cubes? Without it, we are not able to use Analytics to evaluate our success against each promoted source segment of our mailings and other efforts—we cannot see what we sent out and can't do average gift per piece sent, etc.
As far as I can tell, num_contacts is in TX_APPEAL_MEDIA_TYPE just like source name and number which do get pulled into Analytics into all cubes except Plans. I would like them!
Am I overlooking where they live or are they really not available in Analytics?
Why not just use Revenue by Source and Appeal? Because people like Analytics!
This is in Seats and Tickets, yeah? The problem is that No. of Contacts is a total being calculated and applied to the source, while the data in Analytics is all effectively tied to a sub lineitem. So an SLI can have its source number and its source name attached to it, but if you add the No. of Contacts then every SLI with that source would then have 2300 or whatever attached to it. I think in Analytics you'll need to compute your own contacts.