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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Location of email inte...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Location of email interactions in dataverse

(1) ShareShare
ReportReport
Posted on by CE-15121502-0 16
Hello!
 
I am looking to create some new tables, analysis and summaries based on the email interactions and statistics we have. It will be based on the information you can see within emails in customer insights journeys and the insight tab. We want to act and see email send outs, email opens, email link clicks and so on, but in the table and raw data where they are stored. We have not been able to identify where this is. Does anyone know?
Categories:
Dynamics 365 Customer Insights - Data
Dynamics 365 Customer Insights - Journeys
I have the same question (0)
  • Suggested answer
    ManoVerse Profile Picture
    ManoVerse 1,125 Super User 2026 Season 1 on at
    There is no Dataverse table containing email opens/clicks from Customer Insights Journeys. Dataverse only contains email definitions , journeys and triggers , templates , activity records with limited metadata.
    All marketing interaction data (send, open, click, bounce, link‑click details) is stored in the Marketing Insights interaction data lake(Fabric) ,to analyze this data, you need to 
    • Enable Marketing Analytics in Fabric
    • Export CI‑Journeys interaction data to Fabric
    • Build Power BI reports directly from that exported dataset
    Regards,
    Manoj
    ✅If this answer helped you, please consider marking it as Verified, it really helps others in community
     
  • Suggested answer
    11manish Profile Picture
    11manish 649 on at
    Email Interaction Data Is Stored

    The data behind email sends, opens, clicks, bounces, etc. is stored mainly in these Dataverse tables:
     
                    
    Event Type Table Name Description
    Email Sent msdynmkt_emailsend One record per send event
    Email Open msdynmkt_emailopen Tracks when a recipient opens the email
    Email Click msdynmkt_emailclick Tracks link clicks
    Email Bounce msdynmkt_emailbounce Hard/soft bounces
    Email Unsubscribe msdynmkt_emailunsubscribe Unsubscribe events
    Email Delivery msdynmkt_emaildelivery Delivery confirmation
    Marketing Email msdynmkt_marketingemail Email definition
    Journey msdynmkt_journey Journey that sent the email
     
    Where to Explore These Tables
     
    You can easily inspect them using:
    • Power Apps Maker Portal
    • XrmToolBox
    • Advanced Find (if tables are enabled)
    Search for tables starting with:
    • msdynmkt_
  • Suggested answer
    ManoVerse Profile Picture
    ManoVerse 1,125 Super User 2026 Season 1 on at
    11manish
    Thanks for outlining the Outbound interaction tables.
    just for clarity: those tables only apply when Outbound Marketing is still active. Real‑Time Journeys uses a separate analytics architecture, so the legacy msdynmkt_ interaction tables won’t populate in RTJ environments.
    Microsoft began removing the Outbound Marketing module after June 30 , 2025, and as of 2026 the product is in its final removal phase. Microsoft states that Outbound is being gradually hidden, disabled, and removed from all environments, and existing customers must transition immediately because Outbound capabilities and APIs will stop working without further warning. 
    I think this is already deprecated and no longer functional unless a customer previously received a rare, approved temporary extension. Even in those cases, the module is being phased out and will stop working entirely once Microsoft completes the removal process later in 2026.
     
    Just adding this clarification so readers can distinguish between Outbound and RTJ behaviors. 
     
    Thanks,
    Manoj
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 151 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 134

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 55 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans