Hi all,
I'm trying to report on revenue generated from email promotions. We use Wordfly to send our emails. Wordfly primarily promotes sources to individual cust_types but ticket orders and contributions are typically processed at the household level. A ticket order or a contribution will then create a new record in T_PROMOTION for the household with 'Trans Processed' response. This complicates reporting because we have, in some cases, multiple records per constituent or constituents in a household. It looks like dl_no in T_PROMOTION might be able to be used to identify records that were added during transactions.
To complicate things further, sometimes we email organizations or individuals who do not belong to a household. In these cases a transaction is processed at that level and the response is updated in T_PROMOTION for the record that was already there.
The goal is to report on the following metrics per source:
Has anyone already come up with a solution for this type of reporting?
Thanks,
Mike Rose