Customer experience | Sales, Customer Insights,...

Unsubscribed date stamp for Contacts Growth report

(0) Share

Report

Posted on by Nory

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?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Nya 29,064 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

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

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

Was this reply helpful? Yes No
Nory 30 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Nya 29,064 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No