List overlap tally | Community
Skip to main content
Level 3
July 17, 2023
Question

List overlap tally

  • July 17, 2023
  • 2 replies
  • 1830 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Darshil_Shah1
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 17, 2023

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.

ayaspanAuthor
Level 3
July 17, 2023

Appreciate the response. Will look into this and report back.

SanfordWhiteman
Level 10
July 17, 2023
I'd do it by importing lists into SQL and running a pretty simple window function on 'em. That's likely outside your current skillset but it's worth a blog post imo. Will work on that this week.
ayaspanAuthor
Level 3
July 18, 2023

Very cool, looking forward to it! And thank you!