web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Import contacts and their opted subscriptions from external platform

(0) ShareShare
ReportReport
Posted on by

I have a list of contacts with their opted subscriptions (eg. newsletter, whitepaper, etc.) in Excel format. How can i import this into Dynamics 365 Marketing. When i use the import wizard, i am unable to map the subscribed options to any field because the subscription list does not have a field to match. So how can i import the data and ensure that all the contacts' subscriptions are captured and populated under their names as usual. 

I have the same question (0)
  • Suggested answer
    Nya Profile Picture
    29,060 on at

    Hi,

    It is recommended to create a custom field in Contact entity to record the opted subscriptions.

    Then create several dynamic marketing list to filter out the contacts based on the field.

    pastedimage1652949845180v1.png

    Dynamic marketing lists can be copied to static ones.

    pastedimage1652949941393v2.png

    As we know, subscription list is a kind of static marketing list.

    After the copy, the "Locked" field will be set as Yes and the "Subscription" field is shown as locked.

    So change the field "Locked" to No.

    pastedimage1652950197412v3.png

    Change the field "Subscription" to True.

    pastedimage1652950310426v4.png

    At last, save the list. It will turn into a subscription list.

    pastedimage1652950331274v5.png

  • GraceC Profile Picture
    on at

    Hi Nya, how do i filter out the contacts. First i import them but how do i add them to the marketing list?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 57 Super User 2025 Season 2

#2
Satyam Prakash Profile Picture

Satyam Prakash 24

#2
Eugen Podkorytov Profile Picture

Eugen Podkorytov 24

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans