List overlap tally
Hello,
Forgive me, I've searched for other topics that have discussed this and have come close but not quite.
I want to tally the number of folks who overlap among my main lists. I have 10 main opt-in list categories I use in Marketo. I could easily run a report all the combinations of two different lists (I count 42 configurations), but once we get to more than two, it gets tricky, we could be talking hundreds of thousands of permutations of someone being on from one to ten of these individvuals lists.
The most practical bird's-eye way of looking at this is I could do a distribution of tallies, so like --
List 1:
37 people on 9 other lists lists
3320 people on 8 other lists
5723 on 7 other lists
...
Lather, rinse repeat, for each individual list. Maybe do it in bar-graph form rather than listed out like this, but basically that's the most stensible way of doing it as far as I can tell.
Anyone able to tell me specifically how to go about creating such a tally? How to have Marketo tally up combos of specified lists?
One other idea to address this question in a less specific way was to maybe justs do one overall distribution tally -
38 people on all 10
60 people on 9
etc etc etc - the key is I'm not necessarily anchoring this to any specific lists, each would have to be weighed the same
Much less helpful but I'll take what I can get! Any idea on what the process of such reports would be?
Cheers,
Alan