List of unsubscribed contacts from email

(1) Share

Report

Posted on by CU21081306-9

When I go inside a journey in Customer Insights, after selecting an email I can take a look at the analytics and see which users have unsubscribed:

I would like to find this table and display the entire list of contacts, not regarding a specific journey. Unfortunately, I have taken a look at all the tables I could find and none of them have this information.

Do any of you have any idea where I can find this?

Thanks in advance.

Screenshot.png

All responses (3)

Answers (0)

MikeC282 2,095 on at

Like (0)

Report

List of unsubscribed contacts from email

Analytics is actually not very useful. I mean they do have all the stats you need for email sends but to access them you either have to click into a journey and then select analytics (which is ok for always on journeys but horrible when we're doing one off EDM blasts). We do a lot of EDM blasts and each EDM blast creates a journey and from what I can see it also creates a series of one off cloud flows specific for that journey (this is funny as hell).

If you want to see aggregated stats for multiple emails or journeys/sends then your only option is the analytics area that combines all journey data together. But even that the formatting isn't what we want.

To build your own reports in Power BI. Out of the box method requires you to have either a Fabric capacity license or a Premium Capacity license from Power BI which costs a fortune. It basically auto-syncs the granular stats that are stored in the Managed Data Lake in the dataverse.

https://learn.microsoft.com/en-us/dynamics365/customer-insights/journeys/fabric-integration

If you need that data without paying for BI premium then you'll need to warehouse it somewhere (potentially your own datawarehouse) and then run BI reports off that. This is what we're doing but I'm really annoyed at this.

The other annoying thing is that the data is stored in a series of JSON files and in a new line delimited format as well......

I understand why this needs to be stored in a data lake (because you definitely do not want this in Dataverse as you'll run out of database capacity real quick with this) but I do wish there's better ways of extracting it out and being able to perform your own slicing and dicing.
mcrthomas 148 on at

Like (0)

Report

List of unsubscribed contacts from email

I agree with Pauline. There is no good way of pulling any meaningful metrics out of Real Time Journeys without building a segment. Even that only gives you a number unless like Pauline mentioned you are willing to build out Amey Holden's method. Amey's method is nice, but it's definitely not a no-code solution.

Microsoft needs to build a better system, but don't really seem dedicated to it because they are betting that AI will solve all our problems.
Suggested answer

PaulineKolde 624 Super User 2024 Season 2 on at

Like (0)

Report

List of unsubscribed contacts from email

Hi,

unfortunately I also have not found the perfect solution as this informtion seems to be not easily accessible.

What you could do as a workaround is creating a segment, e.g. with the following criteria:

To better display the result, Amey holden has created a great solution: Browse and Search Segment Membership in Customer Insights - Journeys — Amey Holden | Anything But Code | Dynamics 365 Marketing & Power Platform

You would also need to create a segment for leads, if you are using them as well.

Hope this helps! If yes, please select Yes under "Did this answer your question?". Thank you :)