Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Email Insight Reportin...
Customer experience | Sales, Customer Insights,...
Suggested answer

Email Insight Reporting and Data - Delivery and Interaction details

(1) ShareShare
ReportReport
Posted on by bilboswaggins23 6
Hello Everyone, 
 
I am trying to see if there is a way to get the analytics present in the 'Delivery and Interaction details' section of Emails in CI - Journeys. 

I am trying to get these details per email (maybe per segment? but not necessary). Right now the only way to do this seems to manually go through each newsletter we have sent and manually write down the metrics.

I can't even seem to identify the table that these interactions are stored on so I could merge some tables together... 

Any thoughts or ideas?

Image of the Delivery and Interaction details window:

  • Suggested answer
    Daivat Vartak (v-9davar) Profile Picture
    Daivat Vartak (v-9d... 6,051 Super User 2025 Season 1 on at
    Email Insight Reporting and Data - Delivery and Interaction details
    Hello bilboswaggins23,
     

    You're right, manually collecting these email interaction details from the Customer Insights - Journeys UI is inefficient for any significant volume of emails. The good news is that this data is stored within Dataverse (the underlying data platform) and can be accessed programmatically or through reporting tools.

    Here's a breakdown of how you can access this data and some potential approaches:

    Understanding Where the Data is Stored:

    The "Delivery and Interaction details" you see are aggregated views of various interaction events related to your sent marketing emails. These events are stored in several Dataverse tables. The key tables you'll be interested in are:

    • msdyncrm_emailopens (Email Opens): Records each time a recipient opens the email.

    • msdyncrm_emailclicks (Email Clicks): Records each time a recipient clicks on a link within the email.

    • msdyncrm_emaildeliveries (Email Deliveries): Records successful email deliveries to recipients.

    • msdyncrm_emailhardbounces (Email Hard Bounces): Records permanent delivery failures.

    • msdyncrm_emailsoftbounces (Email Soft Bounces): Records temporary delivery failures.

    • msdyncrm_emailunsubscribes (Email Unsubscribes): Records when recipients unsubscribe via the email link.

    • msdyncrm_emailsent (Email Sent): Records each attempt to send an email to a recipient.

    • msdyncrm_emailforwards (Email Forwards): Records when recipients forward the email.

    • msdyncrm_emailrenderings (Email Renderings): Records when the email content is rendered by the recipient's email client.

    • msdyncrm_emailspamcomplaints (Email Spam Complaints): Records when recipients mark the email as spam.


      •  

    Key Linkage:

    The crucial field that links these interaction records back to the specific sent marketing email is often a lookup field to the msdyncrm_marketingemail entity (Marketing Email). You'll need to filter these interaction tables based on the specific Marketing Email record(s) you're interested in.

    Ways to Get This Data:

    1. Using Advanced Find (for basic, manual extraction):

       

      • Go to Advanced Find in Dynamics 365.

      • Look for each of the interaction entities listed above (e.g., "Email Opens").

      • Use the "Regarding (Marketing Email)" field to filter records related to a specific Marketing Email. You'll need to know the name or ID of the email.

      • You can then export the results to Excel.

      • Repeat this process for each interaction type. This is still manual but allows you to get the raw data.

        •  

    2. Using FetchXML Builder (for more structured queries):

      • The FetchXML Builder is a tool within the XrmToolBox (a free community tool) that allows you to build complex FetchXML queries against Dataverse.

      • You can create FetchXML queries that:

        • Retrieve the msdyncrm_marketingemail entity.

        • Use linked entities to join the interaction tables (e.g., msdyncrm_emailopens, msdyncrm_emailclicks).

        • Aggregate the counts of each interaction type for each email.

          •  

      • You can then export the FetchXML results to Excel or use it in other reporting tools.


        •  

    3. Using Power BI (for interactive dashboards and reporting):

      • Connect Power BI to your Dynamics 365/Dataverse environment using the Dataverse connector.

      • You can then:

        • Bring in the msdyncrm_marketingemail entity.

        • Bring in the various interaction entities.

        • Create relationships between msdyncrm_marketingemail and the interaction entities using the "Regarding (Marketing Email)" lookup.

        • Build measures and visualizations to display the delivery and interaction metrics per email. This is the most scalable and user-friendly approach for ongoing analysis.

          •  

    4. Using the Dynamics 365 Web API (for programmatic access):

      • If you need to automate the extraction of this data for integration with other systems, you can use the Dynamics 365 Web API.

      • You can query the msdyncrm_marketingemail entity and use $expand to retrieve related interaction records. For example:

        • Replace [YourOrgURI] with your Dynamics 365 instance URL.

        • Adjust the API version as needed.

        • The $select parameter specifies the fields from the Marketing Email entity you want.

        • The $expand parameter retrieves related records from the interaction entities and uses $count=true to get the number of records for each interaction type.


          •  

    5. Using Azure Data Lake Storage Gen2 (if configured):

       

      • If you have configured Customer Insights - Journeys to export interaction data to Azure Data Lake Storage Gen2, you can access the raw data files there and use tools like Azure Synapse Analytics or Power BI to query and analyze it.


        •  

    Getting Details Per Email:

    All of the above methods allow you to filter or group the data by the msdyncrm_marketingemail entity, effectively giving you the analytics per email.

    Getting Details Per Segment (Indirectly):

    To get analytics per segment, you would need to link the msdyncrm_marketingemail entity to the msdyncrm_segment entity. The primary link here is usually through the Customer Journey. A Marketing Email is sent as part of a Customer Journey, and the Journey targets a specific Segment.

    You would need to:

    1. Identify the Customer Journey that sent a particular Marketing Email. The msdyncrm_marketingemail entity has a lookup field to the msdyncrm_customerjourney entity.

    2. The msdyncrm_customerjourney entity has a lookup field to the msdyncrm_segment entity (Segment).

      3.  

    You can then join these entities in your queries or reports to analyze the email interaction data based on the segment the Journey targeted.

     

    In Summary:

    The data you see in the "Delivery and Interaction details" section is stored in various Dataverse interaction entities linked to the msdyncrm_marketingemail entity. You can access this data using:

    • Advanced Find: For basic, manual extraction.

    • FetchXML Builder: For more structured queries and exports.

    • Power BI: For interactive dashboards and ongoing analysis.

    • Dynamics 365 Web API: For programmatic access and integration.

    • Azure Data Lake Storage Gen2: If configured for data export.


      •  

    To get analytics per segment, you'll need to join the Marketing Email entity with the Customer Journey and then the Segment entities. Power BI is generally the most powerful and user-friendly tool for this type of multi-entity analysis and reporting.

     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.
     
    My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.
     
    Regards,
    Daivat Vartak
  • Scott Moore Profile Picture
    Scott Moore 17 on at
    Email Insight Reporting and Data - Delivery and Interaction details
    Has anyone tested or confirmed one way or another whether the blob storage still receives interaction data in the real-time version?  I will populate the msdyncrm_cdsaconnectorconfiguration with the necessary info to see but wanted to find out if someone else had tried this already or knew for sure whether it would work.
  • bilboswaggins23 Profile Picture
    bilboswaggins23 6 on at
    Email Insight Reporting and Data - Delivery and Interaction details
    Siraj Abou Said, 
     
    Thank you for your response. I had seen that there more metrics available via Fabric but was hoping to avoid that cause we already pay quite a bit for dataverse / customer insights. 

    A little frustrating that this data exists in our environment but can't really be interacted with in the same way you might interact with other tables to build customized dashboards and whatnot.  
     
     
  • Suggested answer
    Siraj Abou Said Profile Picture
    Siraj Abou Said 41 on at
    Email Insight Reporting and Data - Delivery and Interaction details
    Hello, if you need to see a detailed report of the interactions in CI-J, then yes they are only available per each email, and not per the parent journey.
     
    However, if you need to view a high level metrics and KPIs per journey, you can view them from "Analytics" reports, where there are couple charts for Delivery success and Delivery issues you can rely on (especially under Chanel analytics), where you can filter by your journeys.
     
     
    If you want a full access to marketing interactions data, you have to do this via Microsoft fabric (previously it was via managed data lake) which you can consider as a backend data processing and management platform, and you also need a Power BI which will be the front-end analytics tool to build reports and dashboards from that data.
     
    For more details, check the latest Microsoft documentation here.

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

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,120 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans