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?