We are currently trying to run some reports that connect donations made at the time of ticket purchases. It seems that they are not connected after the gift is made. Has anyone else had this issue, and how did you amend this issue? We are trying to determine which shows generate the most donations and are unable to run a report with this information. In order to do this, we have to do a ton of manual manipulation of the data and guessing.
Thank you for your assistance! Angela
Ah, the joy of online donations!
I'm unsure of what you mean by "not connected after the gift is made". The joy of these sort of contributions is that they actually appear in two places - in the Contributions tab of the constituent (from the record in T_CONTRIBUTION) and in the order itself (from the record in T_ORDER_CONTRIBUTION).
For the kind of analysis you're looking for, I suspect this is some work you will need to do in-house - do you have in-house SQL/SSRS/InfoMaker skills? I'd be happy to help if you need some assistance.
Oh - bear in mind that if the order in which the contribution was created has more than one product in it, determining which show was the driver for the donation can be difficult. The source number might offer a nice alternative?
Martin
Our contributions are not on the contributions tab of the ticket purchase when they come my was in development. They are placed “on account “ by the box office for processing by the development team. So, I actually never see the contribution on the order records. I have to go in to the donor account to see if there was a ticket purchase in order to determine whether the $$s are from a ticket purchase (matches transaction date with ticket purchase ) or if they were sent an appeal. There is also some residual code on the order note field which is another clue. I then batch those gifts in order for them to appear on constituent contribution tab.
Looks like we have some thinking to do.
If you don’t mind, I would like to ask you about some best practices in this regard.
Best!
Angela