Export replicated Account data from SAP Marketing cloud!

[anwar96]

Hi Experts,

We replicate custom data from Sap Sales cloud to Sap Marketing Cloud, and we want to export Contact and Account IDs From Marketing CLoud.

How can I get this IDs from the system?

Any ideas?

If you have the aswer please let me know.

Thank you

Best regards.

[SCHNEIDERT · Accepted solution]

Hi Anwar,

do you only need the IDs?

Then I think the easiest way would be to make the fields visible in Segmentation (by using segmentation configuration) and export a CSV file from there.

For example for the Contact IDs you could first use the attribute ID Origin and filter for "SAP C4C - Business Partner" and then use the ID attribute. In the preview you could then download a CSV with all of the Contact IDs.

If you need the Contact and Account ID (maybe together with other attributes) in one table like for example

Name, Email, Contact-ID, Account-ID

then you have to build a target group with all of your needed Contacts and export the data from the target group.

Let me know if you need further assistance.

Best Regards

Tobias

[anwar96 · Accepted solution]

Hello Tobias,

Thank you for your answer. However, we are already tried to build a target group. But i want to know if there is other ways to do it.

N.B: we need the Contact and Account ID with the attribute NAME.

Thank you.

Best regards.

[SCHNEIDERT · Accepted solution]

Hi anwar96,

I'm not aware of any other way within SAP Marketing Cloud UI.

Of course you can do OData Requests (one to API_MKT_CONTACT_SRV to get the Contact data via ContactOriginData entityset and one to API_MKT_CORPORATE_ACCOUNT_SRV to get the Account data via CorporateAccountOriginData entityset) and use $filter and $select parameters to get the data of your choice (e.g. via Excel OData adapter) and after that do an VLOOKUP in excel between the two sheets using the CorporateAccountUUID which you have in both sheets.

But as per my knowledge the easiest way is the one using target groups.

Kind regards

Tobias

[MarkusGrant]

Hello,

I'd suggest to use the Browse Contact Origin Data app in the Data Stewardship app group.

There you can filter the contacts and accounts based on the origin of the contact as Tobias mentions above.

In this app it's also pretty simple to select the columns required and export to Excel.

Cheers,

Markus

[anwar96]

Thank you

[former_member1277]

Hello anwar96

May be you can consider a running a campaign and export an File on a regular basis.

Consider creating an export definition(with the needed fields) and use it for the File Export in the Campaign.

Hope this helps !

Cheers

[MarkusGrant]

You can also just create a target group and from the target group member list (either Contacts or Accounts depending on your segrmantation object) export based on export definition. No actual campaign is required.

[anwar96]

Thank you for your answer