Expand my Community achievements bar.

SOLVED

Importing data from SFMC (Sales force mareting Colud) is showing no records

Avatar

Level 2

Hi everyone, 

has anyone tried the importing data through SFMC.

We were able to sucessfuly migate the data through FTP but the data isn't showing any records. 

We are facing some fomatting issue but we are not able to reolve this.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@yogitabistacc 

Yes,  it should be either of these methods. Either use mbox3rdpartyId or use experience cloud ID service.

Glad to know that it's worked for you. 

@Amelia_Waliany 

View solution in original post

8 Replies

Avatar

Community Advisor

Hi @yogitabistacc - What's your use case, are you importing data from SFMC to Adobe Target or AEP? From your question this is not clear. 

Avatar

Level 2

In Adobe Target and what would be the process to maps the SFMC ID to ECID or profile parameters ?

We are using GTM i think we need couple of custom codes in order to make it happen

Avatar

Level 2

@Gokul_Agiwal  Thanks a lott for the help on this. 

We have completed the data import from SFMC into customer attributes. 

What we are facing challenge with is Part 2 : Which is mapping SFMC IDs to ECID that too through GTM. 

And there is something missing in the help links. 

Have you guys done it before and if yes, please help share the steps post importing the data into customer attributes. 

 

Avatar

Community Advisor

Hi @yogitabistacc  

setCustomerIDs (customer ID synchronization) is required by customer attributes and core services functionality. Target requires Visitor.AuthState.AUTHENTICATED for Customer Attributes to work and you need to pass alias Id in Customer Attributes to track data. 

This Alias ID can be pass like as below  

 

visitor.setCustomerIDs({
    "mapSFMCID":{
        "id":"", // PASS YOUR SFMC ID here
        "authState":Visitor.AuthState.AUTHENTICATED
    }
});

 

 

Once above steps done - pass the mapSFMCID as Alias ID in Customer attribute like below 

Gokul_Agiwal_0-1698060944441.png

 

If all works well, you can able to see in network call payload like below  as CustomerIds object and the integrationCode will be mapSFMCID

 

Gokul_Agiwal_1-1698061188903.png

Here is more info https://experienceleague.adobe.com/docs/id-service/using/reference/authenticated-state.html?lang=en 

Hope this helps. 

Avatar

Administrator

Thanks for posting your question @yogitabistacc! And thanks @Gokul_Agiwal for your thoughtful step-by-step guidance here on the thread! @yogitabistaccplease feel free to update this thread if you have any follow-up questions! If you were satisfied with the direction that @Gokul_Agiwal provided, please click on the "Correct Reply" button at the top left of the most helpful reply to close out this question. Thanks again for contributing to the Adobe Target Community!

Avatar

Level 2

@Gokul_Agiwal 

 

For us : 

stitching the SFMC ID with with the mboxthirsparty Id in target page params worked. 

We had to pass the sfmc id in GTM variable 
like below 

function targetPageParams() {
return [
"mbox3rdPartyId" + {{sfmc_id}};
]
}

Avatar

Correct answer by
Community Advisor

@yogitabistacc 

Yes,  it should be either of these methods. Either use mbox3rdpartyId or use experience cloud ID service.

Glad to know that it's worked for you. 

@Amelia_Waliany