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
You can export people and use vlookup to find the people who are common to the lists. I think that’s the solution that most users are using for now. If you plan ahead, there’s a unique solution on managing the number of “interesting lists” a person is member of in a scoring field using the Add to List/Removed from List triggers, i.e., increase this scoring field’s value by 1 when a person gets Added to List, and decrease it by 1 when a person gets Removed from List.
Appreciate the response. Will look into this and report back.
Very cool, looking forward to it! And thank you!