Hi,
I have a request where I need to determine the overlap between campaigns on a monthly basis, for a rolling 3-month window.
Let’s say I have 3 campaigns on a monthly basis, and I need to determine the overlap of those 3 campaigns and the previous 6 campaigns from the prior two months. So a total of 9 campaigns going in.
If my matching key is Full Address (Address, City, State and Zip), I need to determine the unique and overlapping counts for each campaign.
I’ve attached a sample report of 3 campaigns overlapping. It a pretty big / Spider Web workflow to create this and I don’t really want to expand this to cover 9 campaigns….
Is there a more optimal way to create a report like this and have it scale easier?
Thanks.
