Hello All,
I just came across something that I wasn't expecting in T-Stats. I wanted to use Appeal as one of the criteria in my report, but the Appeal I wanted to use wasn't in the pick list. Long story short, I found out that if there aren't any "Successful Contacts" in your Appeal (or Source for that matter) that Appeal won't come up in your pick list. I've never tried to use Appeal in T-Stats, but we do use Appeals to keep track of several non-response type efforts (such as a postcard about an upcoming exhibit opening) so I was wondering if there anyone out there knows of a way to make Appeal usable by Successful Contacts and, separately, Contacts?
Many thanks!
Jenny O'Neill-Englund
Hi Jennifer,
What you're describing is expected behavior. In T-Stats each cube has a specific focus, for example everything in the Contributions cube revolves around contributions, the Tickets cube, all tickets. In order for an Appeal to be visible in a particular cube it has to be associated with that focus of the cube. So the only appeals available in the Contributions cube are appeals that have been used in at least one contribution. The only appeals in the Tickets cube will be those associated with either a ticket lineitem or a ticket order. Consequently if an appeal or source has not been used in the context the cube is reporting on, you won't see that appeal or source in the list because there would be no results for that appeal in that cube.
If your goal here is to report on constituents who were promoted a particular source (or the appeal associated with it) but purchased a ticket or made a contribution using a different source or appeal, then Jared's suggestion should allow you to cross reference those constituents associated with the appeal or source in question, and see what they actually purchased/contributed. If your goal is to do a more source-centric analysis, of all sources and appeals independent of their "success", that would probably be better suited a custom cube.
I hope that clarifies a bit for you!