AnsweredAssumed Answered

Permanent Random Number

Question asked by Michael Florin on Aug 21, 2018
Latest reply on Aug 24, 2018 by Sanford Whiteman

Hello Community!


I'm looking for a good way of stamping all records in our database with a permanent random number. I would use this number for splitting flows and long term observation.


I had done this in the past by creating a new field in Marketo and running all new records through a campaign that assigned a number between 0 and 9 by using random sample. That worked somewhat okay, but that Smart Campaign was pretty busy at times when we had a couple thousand new records flowing in. Also, doing that backwards for a multi million database took a pretty long time.


Does anyone have a better idea? Probably an already existing field - one of the ID fields? - which is truly random somehow?