Smart List Filter "Ends With" | Adobe Higher Education
Skip to main content
Liz_Davalos
Level 4
March 20, 2018
New

Smart List Filter "Ends With"

  • March 20, 2018
  • 4 답변들
  • 8741 조회

I don't know why anyone created filters for "Starts with", but not "Ends Width". This is silly because a lot of typos commonly happen at the end and I could fix them if I could filter with "Ends With."

4 답변

SanfordWhiteman
Level 10
March 21, 2018

Never gonna happen that quickly (the idea exists elsewhere, too).

Add a formula field that's the email field followed by the standard end of line character $.

Then do

  Contains ".de$"

etc.

Of course this isn't going to find everyone in the EU. Hope your legal understands that!

Liz_Davalos
Liz_Davalos작성자
Level 4
March 21, 2018

Yes, I'm aware it won't find everyone and thank you for the suggestion. We are doing other things to identify them, however it is less than 1% of our list since our products only apply to the US market. I'm just doing my part.

Antonia_L
Level 2
November 25, 2019

Follow!
Adding "ends with" option could have multiple useful applications.
For example I would like to implement two different campaigns based on evens and odds booking numbers: with this option "ends with" available it comes easy by extracting the last number.
I cannot find other solutions to divide a group of numbers between odd and even if not using ends with...

SanfordWhiteman
Level 10
November 25, 2019

An interesting use case, but unless your booking engine ensures absolutely no gaps within your population, that's not the same as round-robin. To do real round-robin you need a webhook.

Antonia_L
Level 2
November 26, 2019

Yes Sanford, I'm sure that my booking engine has no gaps, also because the list is daily updated and use by differents applications. That's why I need a solution that every day add the new booking in the campaigns.

Any example of round-robin solution? 

It cannot be random, I need to present a ratio behind my activity. I've think about use alphabet letters but it will be far from divide into equal parts.

SanfordWhiteman
Level 10
November 30, 2019
Yes Sanford, I'm sure that my booking engine has no gaps, also because the list is daily updated and use by differents applications.

I'm talking about gaps in the integer series.

It's almost impossible in the real world to be sure this isn't happening, especially when a system is used by different applications.

When a database assigns auto-incrementing IDs (AUTOINCREMENT in some databases, SEQUENCE in others) the only guarantee is the numbers will be unique across a database table at any given point in time.  There's no guarantee at all that there's an equal number of odds and evens. Deleting a row and reinserting the same data gives you another number. It's possible to have a healthy table where every single value for the auto-incrementing ID is an odd number!

In sum, it would be a very curious environment -- and one which presumably was built for this express purpose, not accidental -- in which auto-incrementing IDs were always completely balanced between odds and evens, all the time.

In any case... the way to do actual round-robin in Marketo is via a webhook. You call the webhook-compatible service, it increments a shared counter, then returns you the result modulo <number of buckets>. This gives you an exact 1-2-3-1-2-3-1-2-3 distribution (if number of buckets is 3) or 1-2-1-2-1-2 (if number of buckets is 2).  We have webhooks set up like this in many instances.

February 4, 2020
No text available