How to see which contact data has been changed in SAP Marketing Cloud?

[SCHNEIDERT]

Hi Experts,

is it possible to create a report in Marketing Cloud that shows which data of which contact has been changed since a specific timestamp?

Use Case: We send an email to a contact which guides him to a prefilled landing page. There the contact changes his mobile phone number. But in SAP Sales Cloud there is still the old mobile phone number maintained for the same contact.

So the best would be to sync that data automatically with Sales Cloud. But if that is not possible we would like to see which data for which contact changed so that we can adapt the data manually.

Does anyone know a solution or workaround for that problem?

BR

Tobias

[hakan_kose · Accepted solution]

Hi Tobias,

This kind of functionality is now only available for Marketing Plan objects: Marketing Plans, Programs and Campaigns.

You can check details right here

I hope SAP will expand this functionality for new business objects in upcoming releases

Kind Regards,

Hakan Köse

[SCHNEIDERT · Accepted solution]

Thanks Hakan,

yes it would be really great to have that functionality also for contacts.

Best Regards

Tobias

[former_member226]

Hi Tobias,

You can fetch all the records based on timestamp using API as shown:

https://myXXXXXX.s4hana.ondemand.com/sap/opu/odata/sap/api_mkt_Interaction_CONTACT_SRV/InteractionCo... gt datetime'2018-10-22T12:00'&$top=100

It will give top 100 records which have been changed since 22nd Oct 2018.

Note: You might get an error regarding token invalid at so and so position, Hence after coping to url replace the inverted commas accordingly.

Thanks

Saurabh

[SCHNEIDERT]

Hi Saurabh,

but that would not show which data of the contact hast been changed.

Do you know a way to find that out?

Even better would be to get a message if contact details have changed. But so far I haven't found any solution for that.

BR Tobias

[former_member226]

Hi Tobias,

Sorry but I am not aware of any such functionality in marketing cloud.

Thanks

Saurabh

[SCHNEIDERT]

kabras thank you anyway.

One more question regarding the API you mentioned above:

If I enter the URL in my browser I get redirected to our IAS for authentication. But if I enter the user credentials for my admin user I'm not allowed to see the data.

E.g. for CUAN_IMPORT_SRV I can use an Inbound Communication User that I created e.g. for the C4C-Integration. But for the API_MKT_INTERACTION_CONTACT_SRV that does not work because it asks for a user who has acces to the IAS.

What am I doing wrong?

Kind regards

Tobias

[former_member226]

Ohk..So in order to launch the API you need to use URL as:
https://myXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/api_mkt_Interaction_CONTACT_SRV/Interacti... gt datetime'2018-10-22T12:00'&$top=100 .

Prior to using it you need to make sure that you have configured communication arrangement SAP_COM_0207 and use the same inbound user for testing the URL from Postman.

Note: If you use the URL within browser then you need to append saml2=disabled as URL parameter and new URL would look like:

https://myXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/api_mkt_Interaction_CONTACT_SRV/Interacti... gt datetime'2018-10-22T12:00'&$top=100&saml2=disabled

Thanks

Saurabh