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 :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Location of email interactions in dataverse

(0) ShareShare
ReportReport
Posted on by
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?
I have the same question (0)
  • Suggested answer
    ManoVerse Profile Picture
    690 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
     

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 131 Super User 2026 Season 1

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 46 Most Valuable Professional

#3
NeerajPawar Profile Picture

NeerajPawar 41

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans