Skip to main content

Notifications

Customer Insights - Journeys forum
Unanswered

List of unsubscribed contacts from email

Posted on by
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.
  • MikeC282 Profile Picture
    MikeC282 2,075 on at
    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.
     
     
    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.
     
  • AdmWombat Profile Picture
    AdmWombat 144 on at
    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 Profile Picture
    PaulineKolde 584 Super User 2024 Season 2 on at
    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 :)

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans