can we create email and country as a unique key in Marketo? We have done first name and email earlier but want to check the possibility with the country or any other field. also, can we create 3 attributes as the joint key or its restricted to just two?
It's 2, but in theory you can extend it to an unlimited # of fields by using a delimited String field as the 2nd one. Just make sure to use a non-colliding delimiter. (For example, the pipe | cannot work to separate fields if one of the fields may have a pipe in it, which is true of Company name.)
HOWEVER.... having a compound key is almost always a bad idea. It's impossible to automatically enforce everywhere in Marketo and inevitably leads to the proliferation of (business-level) duplicates. Can you explain your business case for a multi-field compound key?
(P.S. First Name and Email Address breaks when parent and child share an email address and have the same name, so it really isn't a solution to households sharing email addresses, if that's what you're going for.)
... View more