Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

How to Import Insights into Dynamics Marketing

(0) ShareShare
ReportReport
Posted on by 25

Hello. Our client needs to transform all his marketing data from external tool into Dynamics Marketing. We have the data in spreadsheets with us.

I am trying to figure out how to Import Insights data which includes Email Interactions (Opens, Clicks), Web Integrations, Blocked Email, Sent emails, Subscriptions, Unsubscriptions as all other Insights details into Dynamics Marketing. Which Entity should we select to import this data?

Can anyone please help on how to import All Marketing data into dynamics marketing.

  • cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: How to Import Insights into Dynamics Marketing

    Hi Abhishek,

    Do you mean that the error throws when you are importing event registration records?

    For example, you have imported two contacts before the import of event registrations, those two contacts have same name but different mailbox, let's say:

    Contact 1: Clofly Mao(Fullname), clofly1@outlook.com(Email)

    Contact 2: Clofly Mao(Fullname), clofly2@outlook.com(Email)

    And for the event registration records excel, it has two rows:

    Row 1: ER A123(Registration ID), Clofly Mao(Contact)

    Row 2: ER B123(Registration ID), Clofly Mao(Contact)

    However, due to there are two duplicate Clofly Mao, so it fails to set the lookup field during import process.

    Is the above the situation you encountered? 

  • Abhishek Dubey Profile Picture
    Abhishek Dubey 25 on at
    RE: How to Import Insights into Dynamics Marketing

    Hello Clofly,

    Thank you for you response. This really helped.

    Also when I imported a single contact into Dynamics it imported successfully and later I tried importing Event Registration record for this contact, it Imported successfully and its also showing under Contact Insights.

    But today I Imported another contact with same Name but different email ID and while importing Event registration record for the contact I imported later with other email ID and after mapping Contact lookup and Event name while importing when I am trying to import this it is failing as an error saying 'duplicate lookup reference found'. I understand its because of system is getting same contact name more than once but how we can import multiple Event registration data for same contact or for multiple contacts with same name as the data we have has multiple records of event registrations for same contact.

    Can you please help me here as well.

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: How to Import Insights into Dynamics Marketing

    Hi Abhishek,

    Yes, because there aren't entities whose name contains "Email clicked" or "Email sent" as keyword in Dynamics. Furthermore, other interactions such as "Contact subscribed" or "Contact unsubscribed".

    From technical perspective, interactions data are also entities actually, it can be said that interaction is non-open entity, but they are not listed in either customization menu or metadata browser.

    https://docs.microsoft.com/en-us/common-data-model/schema/core/applicationcommon/foundationcommon/crmcommon/solutions/marketing/interactions/overview#entities

    (In the screenshot, there is an entity InteractionForEmail, but from my test, no records are found by retrieving the entity.)

    pastedimage1614764746080v1.png

    In other word, we are not able to do CRUD operations on them as on other general entities, (Account, Contact or Marketing Email etc.) they are not open to us to get access to them except via Insights widget or Power BI.

    So please contact Support for interactions data migration.

  • Abhishek Dubey Profile Picture
    Abhishek Dubey 25 on at
    RE: How to Import Insights into Dynamics Marketing

    Hello Clofly,

    Thank you for your response. This means we CANT import Interactions data/insights like Email interactions (deliveries , Sent, clicks, opens, Blocked emails) and Web Interactions so we can view them under Contact Insights?

    We are trying to import data for a client in Dynamics Marketing. They were using some other tool previously and now they want to shift to Dynamics Marketing with all there data.

    We tried Importing some Event Interactions through Event Registration entity and they got imported successfully and showing under Contact Insights as well.

    But as what you saying there is no way to import Email Interactions or any digital events directly into Dynamics Marketing?

    Also we need to reach out to Microsoft support for tis kind of migration? Correct?

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: How to Import Insights into Dynamics Marketing

    Hi Abhishek,

    Unlike entities data, Interaction data is stored in the marketing-insights service database, we can't create these records nor view them directly.

    https://docs.microsoft.com/en-us/dynamics365/marketing/custom-analytics#data-sources-for-custom-analytics

    Please open a ticket and ask them whether they can help you do such migration at background.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans