Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Unsubscribed date stamp for Contacts Growth report

(0) ShareShare
ReportReport
Posted on by 30

Hello,

We are trying to build a user growth over time  Power BI report via CDS.

For that, we will need to know when a contact has unsubscribed as that affected the count of contacts and which entity/table we can fetch that data from

We are aware that data is being captured in the Audit History that shows updates " do not allow bulk email" field. but we haven't been able to find that specific data in CDS.

Any insights from where can we fetch it from? or any other idea on how to count unsubscribed contacts?

 PIc1.png

  • Suggested answer
    Nya Profile Picture
    Nya 29,058 on at
    RE: Unsubscribed date stamp for Contacts Growth report

    Hi,

    As I noticed that you have created a separate post, please refer to my reply in that post.

    (+) Where is the transactional data from Subscription Center is stored in CDS? - Dynamics 365 Marketing Forum Community Forum

     

    If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

    Best Regards,

    Nya

  • Nory Profile Picture
    Nory 30 on at
    RE: Unsubscribed date stamp for Contacts Growth report

    Hi Nya,

    We are able to find a column for that field with Option set: Allow, Does not allow. However, what we need is a date stamp of when that field was updated, so we know by when the contact unsubscribed.

  • Suggested answer
    Nya Profile Picture
    Nya 29,058 on at
    RE: Unsubscribed date stamp for Contacts Growth report

    Hi,

    The name of the fields shown in Power BI is not the display name of them.

    pastedimage1618993927315v1.png

    Please try to find the “donotbulkemail” field in Power BI.

    pastedimage1618993939561v2.png

     

    If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

    Best Regards,

    Nya

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans