SFMC - How to Get Contact ID based on Contact Key/SubscriberKey
SFMC websites that you should bookmark:
ampscript.guide
mateuszdabrowski.pl
Must-have SFMC chrome extension:
sfmc-companion
Tutorial of today:
1.Create DE "ContactIDandContactKey Staging"
Column1: ContactID (Type: Text)
Column2: ContactKey (Type: Text)
------------------------------
2.Create DE "ContactIDandContactKey"
Column1: ContactID (Type: Text)
Column2: ContactKey (Type: Text)
------------------------------
3.Create Automation - "ContactIDandContactKey"
------------------------------
4.Create SQL Step 1
Get new customers who have not got ContactID and populate "ContactIDandContactKey Staging" DE
Select c.Customer_number as ContactKey
from [Customer] c
left join [ContactIDandContactKey] as x on x.ContactKey = c.Customer_number
where x.ContactKey is null
------------------------------
5.Create SQL Step 2
Update "ContactIDandContactKey" DE
Select ContactID,ContactKey
from [ContactIDandContactKey staging]
where ContactID is not null and ContactID != '' and ContactID != '0'
and ContactKey is not null and ContactKey != '' and ContactKey != '0'
------------------------------
6.Activate Automation
------------------------------
7.Re order the automation steps
1.SQL Step 1
2.journey entry
3.wait 1 minute
4.SQL Step 2
------------------------------
8.Create Journey - "ContactIDandContactKey"
Entry:ContactIDandContactKey Staging
Run Schedule: Automation
Step: Update MobileConnect Demographics
DE: ContactIDandContactKey Staging
Attribute Value: ContactID = {{Contact.Attribute."Contacts"."Contact"."Contact ID"}}
------------------------------
9.Activate journey