We are trying to run the Revenue by Source and Appeal report to see both contributions and tickets that were processed with a particular source. When we run the report, we are getting nothing for the source. If we run the Appeal Response report, we get ticketing money. I can't figure out why the money won't show up in the other report. We actually have orders and contributions that were processed with the source, but the money isn't showing up. Any ideas of what we are missing with this report?
Hi Teresa,
The campaign you select when you run this report determines which products (i.e. performances, packages, and fees) are included in the report based on the campaign to which they products are assigned. It does not affect which appeals and sources are included in the report. After it selects the products based on the campaign you selected, all sources used for sales of those products are listed. For example, if I select my 2011 Single Ticket campaign, all sales of performances in that campaign will be included in the report broken out by the sources used for those sales. Does that make sense? It sounds like you are selecting a campaign that has not been assigned to any products. This all works the same for contributions, too. The campaign you select controls which contributions are included in the report and then the contributions are broken out by the sources used.
Kevin Sheehan
Senior Documentation & Learning Resources Specialist
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com