Converting between AAM UUID and ECID | Community
Skip to main content
L
Luke80
August 6, 2021
Solved

Converting between AAM UUID and ECID

  • August 6, 2021
  • 1 reply
  • 2301 views

Hi,

I have an external dataset that I need to join to Analytics data in a warehouse. Unfortunately the external dataset is keyed by AAM UUID, whereas my data is keyed by the ECID/MID field, which is preventing me join these together.

How can I convert the UUID to a ECID?

The ID documentation from the AAM suggests that the ECID can be calculated from the UUID by combining with our organisation ID, but it doesn't provide the function to do this and I can't find this anywhere.

Is there a simple function or formula available to do this? (is it something like salting the UUID with the org ID and hashing again?)

Thanks in advance

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

From what I know, these IDs are built independently from each other, it's not possible to get one by hashing the other.

 

 

1 reply

Andrey_Osadchuk
Andrey_OsadchukAccepted solution
Level 10
August 9, 2021

From what I know, these IDs are built independently from each other, it's not possible to get one by hashing the other.

 

 
L
Luke80Author
August 10, 2021

Thanks for the answer Andrey!

If that's the case, then that's a shame, although I have seen a number of different pieces of Adobe documentation and 3rd party content that suggests that a ECID/MID can be consistently recalculated from the UUID and Organisation ID.

One example: https://experienceleague.adobe.com/docs/audience-manager/user-guide/reference/ids-in-aam.html?lang=en

"Experience Cloud ID. The Experience Cloud ID (ECID, legacy abbreviations MID or MCID) is derived mathematically from your Organization ID and the Audience Manager Unique User ID. As long as these IDs remain constant, generating the right ECID for a specific user is simply a math problem. With the same Organization ID and Audience Manager UUID you get the same ECID value every time."

 

Second example:

https://experienceleaguecommunities.adobe.com/t5/adobe-audience-manager-questions/onboarding-with-mid-ecid-mcid/qaq-p/313385

(Shows that you can onboard ECID based records into AAM, although this isn't an option for me at the moment)

 

I've seen a few more examples from both Adobe and 3rd party docs similar to the above.

Terms & ConditionsAccessibility statement

Loading footer...