Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Which tables in Dataverse store all the marketing activity from Customer Insights - Journey?

Posted on by 31
We are imlementing Customer Insights - Data, and want to pull in some of the marketing activity to see and analyze which contacts responds to different types of messaging and content. But I am struggling to find where all this info is stored in Dataverse. Does anyone have a link to a reference or an easy overview of what is stored where? Looking for who receoved, opened, clicked, etc,, primarily for emails, to analyse who responds to what content.
  • CU03091316-0 Profile Picture
    CU03091316-0 31 on at
    Which tables in Dataverse store all the marketing activity from Customer Insights - Journey?
    It seems the data are in blob storage outside dataverse. Does anyone have experience in retrieving it from there?
     
    I have also learned that the december release of CI-D will have a preview of a connector to these data.

  • CU03091316-0 Profile Picture
    CU03091316-0 31 on at
    Which tables in Dataverse store all the marketing activity from Customer Insights - Journey?
    Thanks for the link to all the material on Marketing Analytics, while this is all fine, it is not what I am looking for. We want to do some of the analytics on our own by loading some of the marketing interaction data into Customer Insights - Data and combine it with other information. So I am trying to find where the marketing interaction data resides. To be specific, this kind of data: Which emails have been sent to whom, which did they open , did they click on any links, etc. I am struggling to find which tables in Dataverse contain this information. The data is readily available to be integrated into the Timeline Control by adding a connector and ticking of 1-3 checkboxes, so It must be available somewhere. The question from me is where? I can't find anywhere in the CI documentation on Learn that points me in the right directon.
  • Suggested answer
    Muhammad.Affan Profile Picture
    Muhammad.Affan 4,442 on at
    Which tables in Dataverse store all the marketing activity from Customer Insights - Journey?
    Hi There,
     
    This link provides information on the access of analytics of various marketing activities:
     
     
    Thanks
    Affan
    If my suggested answer has helped, please mark it as verified.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans