Hello,
Has anybody got any experience of counting the number of elevated events attended by a constituent our list of constituents over a certain period of time?
Thanks in advance,
Kyle
(NT)
Hi Kyle,
Try inserting these values in TR_QUERY_ELEMENT in system tables in order to create an Output Set element:
Description: Elevated Events - No of Events
Category: (Select the appropriate category)
Data Select: count(distinct campaign_no)
Data From: tx_event_extract
Single Row: Y
Create an Output Set and run on a list from List Manager, I hope it works for you.
Cheers,
Kevin