I have a situation in a marketing report where I have to select people to target for different campaigns every month.
Currently there are situations where the same campaign selections may need to be rerun multiple times during the same month, which has led to duplicate/incorrect counting if I sum by month.
Below is an example of how the data may come to me:
Campaign Unique ID
In the above example for TestGroupA I need to capture the 1/29/19 selection for January while ignoring the selection for 1/1/2019, but capturing the revenue. And, I need to also capture the 2/1/19 selection for February as a seperate data point compare to January.
Does anyone have any advice on how I would accomplish that? Thank you.