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?
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
Was this reply helpful?YesNo
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.