Best practice - CSV into a Segment

(1) Share

Report

Posted on by PB-08011220-0

Hi,

I am looking for the best way to migrate multiple historic contact lists from an existing Marketing Automation Platform into Customer Insights Journeys, in order to keep historic data on form submissions.

Ideally these would be held in a Segment as a Static Snapshot so as to reference them in future sends. I have seen a way of doing this by uploading a list into the Dataverse with a field for 'upload purpose', however as this field would be over-written for any contact in more than one list, it would mean only working on a single list at a time.

What would be the best approach for this to allow the team to upload multiple static lists into segments as we migrate our data over?

Any advice greatly appreciated!

Thanks,

Phil

Categories:

Dynamics 365 Customer Insights - Journeys

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Muhammad Shahzad Sh... 2,606 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Tag Contacts with Unique List Identifiers

Add a multi-value-friendly field in Dataverse:

Create a custom many-to-many relationship between Contact and a new "Contact List" entity, or

Create a multi-select choice column, or

Use a text field that stores a list ID or name (if lists are mutually exclusive per contact).

Import each list with a unique list identifier:

During import, associate each contact with the corresponding list (either via relationship or tagging).

Create a static segment for each list:

Use a Dataverse segment query like:
"Contact List contains [List A]"
or
"Tag field equals 'List A'"

This allows multiple contacts to belong to multiple lists without overwriting each other.

Was this reply helpful? Yes No
PB-08011220-0 13 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @Muhammad Shahzad Shafique

That's very useful.

Best,

Phil

Was this reply helpful? Yes No

Join the conversation

Community site session details

Best practice - CSV into a Segment

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Best practice - CSV into a Segment

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates