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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Which tables in Datave...
Customer experience | Sales, Customer Insights,...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by CU03091316-0 170
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.
Categories:
Dynamics 365 Customer Insights - Journeys
I have the same question (0)
  • Suggested answer
    Muhammad.Affan Profile Picture
    Muhammad.Affan 4,620 Super User 2025 Season 2 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.
  • CU03091316-0 Profile Picture
    CU03091316-0 170 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.
  • CU03091316-0 Profile Picture
    CU03091316-0 170 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.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 228

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 156 Super User 2025 Season 2

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 149

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans