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,... / Identify the table whe...
Customer experience | Sales, Customer Insights,...
Suggested answer

Identify the table where Marketing emails are stored

(3) ShareShare
ReportReport
Posted on by Daivat Vartak (v-9d... 7,833 Super User 2025 Season 2
Hello Team,
 
I have been using Customer Insight Journey for the last few days. The email that we have trigger from Customer Insight - Journey are visible on timeline on contact page. 
 
 
I am trying to identify the table where this email is stored so that We can generate different charts and display them on dashboard. 
 
I have already tried with Marketing Emails but that didn't work out for me. 
 
Regards,
Daivat Vartak
Categories:
Dynamics 365 Customer Insights - Journeys
I have the same question (0)
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,351 Super User 2025 Season 2 on at
    Identify the table where Marketing emails are stored
    My response was crafted with AI assistance, tailored to provide detailed and actionable guidance for your Microsoft Dynamics query.
     

    In Dynamics 365, the emails triggered by Customer Insights - Journeys are typically stored in the "Email Messages" table. However, the exact table where marketing email data is stored depends on the functionality you are using and how it's configured. Since you're using Customer Insights - Journeys,

    1. msdynci_customerjourneyemail (Customer Journey Email Table):

      • This table specifically stores information about emails triggered through Customer Insights - Journeys.
      • It is linked to the corresponding Customer Journey record and contains metadata about the emails sent (e.g., template, journey name, etc.).

    2. activitypointer (Activity Pointer Table):

      • Since emails are activities, a record is created in the activitypointer table. This is a system table that tracks all activities (emails, phone calls, tasks, etc.).
      • You can filter activitypointer records where the ActivityTypeCode corresponds to "Email" (value: 4202) and verify the relevant emails tied to journeys.

    3. email (Email Table):

      • This is the primary table where email messages (including marketing and transactional emails) are stored. Each email will have fields such as subject, to, from, statuscode, etc.
      • Emails triggered from journeys should appear here with links to contacts or leads via RegardingObjectId.

    4. msdyncrm_marketingemailinteraction (Marketing Email Interaction Table):

      • This table tracks interactions (opens, clicks, bounces) for marketing emails sent via journeys. It may not store the actual email itself but is useful for metrics.

    How to Identify the Right Table for Your Use Case:

    1. Check Timeline Entries on the Contact Page:

      • Open a contact record where the journey email appears in the timeline.
      • Use the Advanced Find or Dataverse Query Tool to identify the related entity for this timeline entry.
      • This will help you pinpoint whether the email record resides in the email table or a custom table like msdynci_customerjourneyemail.

    2. Use Power Platform Tools:

      • Go to Advanced Settings > Customizations > Developer Resources and use the Dataverse Search feature.
      • Search for the keywords related to the email (e.g., subject, journey name) to determine the table where the record is stored.

    3. Inspect Email Activity Links:

      • Emails are often linked to contacts, leads, or accounts through the RegardingObjectId field. Check the RegardingObjectId in the email table to identify relationships.

    Creating Charts for Dashboards:

    Once you identify the table (likely email or msdynci_customerjourneyemail), you can create charts or visualizations using the following steps:

    1. Go to Advanced Find and filter the table by the desired criteria (e.g., RegardingObjectId is a specific contact or journey).
    2. Save the view and use it to build a chart in the Chart Designer.
    3. Add the chart to a Dashboard for visual representation.

    Troubleshooting:

    If you're still unable to locate the correct table:

    • Verify if your environment has any custom entities or configurations related to Customer Insights.
    • Use XRM Toolbox tools like Metadata Browser or FetchXML Builder to explore all available tables.
  • Daivat Vartak (v-9davar) Profile Picture
    Daivat Vartak (v-9d... 7,833 Super User 2025 Season 2 on at
    Identify the table where Marketing emails are stored
    Hello Saif Ali Sabri, 
     
    Thank you for sharing the details. Unfortunately, I am unable to locate any table similar to msdynci_customerjourneyemail and the OOTB activitypointer the table does not have information about emails triggered by the Customer Insight - Journey App. 
     
    I am looking forward for more specific information. 
     
    Regards,
    Daivat Vartak
  • cd09 Profile Picture
    cd09 16 on at
    Identify the table where Marketing emails are stored
    We are facing the same issue. The msdynci_customerjourneyemails and msdyncrm_marketingemailinteractions tables mentioned below do not exist in our clients orgs and the customer journeys emails that were sent are not found within tables: emails, activitypointers nor the timeline for the Contacts. How can we query a list of all the emails that were sent from a journey email? Thank you for any insight.

    Not found: orgUrl/api/data/v9.2/emails?$filter=contains(subject,'subject of the email sent')
    Doesn’t exist: orgUrl/api/data/v9.2/msdynci_customerjourneyemails
    Not found: orgUrl/api/data/v9.2/activitypointers?$filter=activitytypecode eq ‘4202’ and contains(subject,'subject of the email sent')
    Doesn’t exist: orgUrl/api/data/v9.2/msdyncrm_marketingemailinteractions
  • Suggested answer
    Hamza H Profile Picture
    Hamza H 1,800 on at
    Identify the table where Marketing emails are stored

    The emails triggered by Customer Insights Journeys are stored in Customer Insights Journey tables like EmailDelivered, EmailOpened, and EmailClicked (in Fabric/OneLake), not in standard Marketing Email tables. For timeline activities in the contact record, data is in the UnifiedActivity table in Dataverse. Use these tables to build charts and dashboards.

  • Suggested answer
    Gus Profile Picture
    Gus 218 on at
    Identify the table where Marketing emails are stored
    These are email interactions, clicks, open, delivered, etc. that are stored in virtual tables so you are unable to access that way.  There is an analytics report on the menu in CIJ for basic query.

    At this point, customization for reports on CIJ interactions are through Fabric Integration but that is a bigger lift and costly to setup as well as monthly fees if the current analytics is not sufficient. Hope that helps. 

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 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 186

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 130 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans