T-stats and appeal results

Hello,

I was wondering if anyone else has figured out a way to get true results from a direct mail appeal. Until last year I was using the appeal report but I found that it wasn't giving me a true picture of all the people who purchased tickets that received the direct mail piece. I'm sure a part of that is because many of the patrons purchase tickets online and thus doesn't go into the correct appeal. Anyway, to solve this, I had our IT director pull a report of the different segments that are shown by their source numbers and how many tickets they purchased to the production. Including dollar amount as well. This gave me a better picture of what segments performed best from the direct mail piece. I was last week if there was a way to do this in T-Stats and I got pretty close but I know the results aren't correct as I had our IT director pull it also and they didn't match up. 

The way I did it was to put my appeal on the filter/slicer then put measures on the right including number of tickets and paid amount. On the bottom I put the production as well as ticket appeals source name to see their segment. The report pulls fine but the numbers are much lower than the real ones. What am I missing? 

Any help would be greatly appreciated! 

Jennifer Lee
Marketing Manager
Vancouver Opera