I am using Customer Insights Journeys - Real Time
I want to create a report using Power BI . I want the report to show a list of the different Marketing emails which have been sent for the week, ideally the report columns should be the email subject followed by the aggregated recipient interactions for each email such as unsubscribes, click rates, opens and so on.
The problem I am having is that I do not know which table contains the email interactions. I have done some digging online and it states that the correct table which holds marketing email interactions is "msdyncrm_marketingemailinteractions" however when I look at the Dataverse tables through Power Platform I do not see this table. I do see the msdyn_email table, however that holds the email metadata which is not what I require.
Does anybody know the correct table to use?
