Skip to main content

Notifications

Announcements

No record found.

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

Marketing List - who added members to a static list ?

Posted on by 5

Is it a way to identify the users who added members in a static marketing list ?
I would like to have a view of all contacts that are members of a marketing list with the contact name, its company and the user who added the member.

The advanced find does not give me access to the List Member entity.
Therefore, I built a FetchXML based on following entities:

  • List
    • ListMember
      • Contact and Account
      • SystemUser (who created the ListMember)

<fetch count="50">
<entity name="list">
<attribute name="listname" />
<filter>
<condition attribute="listname" operator="begins-with" value="SQ" />
</filter>
<link-entity name="listmember" from="listid" to="listid" alias="lm" intersect="true">
<link-entity name="systemuser" from="systemuserid" to="createdby" alias="su">
<attribute name="fullname" />
</link-entity>
<link-entity name="contact" from="contactid" to="entityid" alias="c" intersect="true">
<attribute name="fullname" />
<link-entity name="account" from="accountid" to="parentcustomerid" alias="a">
<attribute name="name" />
</link-entity>
</link-entity>
</link-entity>
</entity>
</fetch>

The results are good.

Unfortunately, when I try to publish this view using the XrmTools View Designer, I can only see ONE record.

  • Philippe Parrys Profile Picture
    Philippe Parrys 5 on at
    RE: Marketing List - who added members to a static list ?

    Hi Amit,

    Thanks a lot for your useful and swift feedback.

    The Audit log is only providing detailed and punctual information.

    My objective is to get information about the participation of users (how many contacts have been added to a static marketing list by different users)

    I finally found a solution with PowerBI using the Memberlist entity (M-M)

    This way, for each static marketing list, I can see how many members have been added by each user.

    Kind Regards,

    pastedimage1675085794807v1.png

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 8,525 Super User 2024 Season 1 on at
    RE: Marketing List - who added members to a static list ?

    Hello User,

    Please enable auditing for the Marketing list. and it will show the operations performed on the marketing list.

    community.dynamics.com/.../date-a-contact-or-account-was-added-to-the-marketing-list

    learn.microsoft.com/.../audit-data-user-activity

    Thank you,

    Amit Katariya

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: Marketing List - who added members to a static list ?

    Hi PParys,

    There are no attributes of the marketing list membership stored, it is a direct many-to-many relationship between the list and the list member.  

    So, you can use CRM auditing feature to check who added members in a static marketing list.

    --Navigate to Settings > Global Auditing Settings, click on "Start Auditing" click OK.

    pastedimage1675049397216v1.png

    -- Settings -> Auditing window, click on Entity and Field Audit Settings, find Marketing List and click on "Auditing" check box

    pastedimage1675049469152v2.png

    Test:

    --Add some contacts to a Marketing List. then go back to Settings -> Auditing > Audit Summary View:

    pastedimage1675049711175v3.png

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans