Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Dynamic Marketing list Members Dashboard

(0) ShareShare
ReportReport
Posted on by 1,336

Hi I need a way to see a roll-up/ dashboard of all Members on a marketing list on a dashboard... several marketing lists that are Dynamic.

I have tried a roll-up and that won't work any suggestions?

Thanks

Justin

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,321 on at
    RE: Dynamic Marketing list Members Dashboard

    Hi,

    You can create a view with these flags and then use it to create a chart.

    I am afraid, you cannot do aggregations in a view directly, you have to use charts.

    Or, you can always build a SRRS report and use aggregations in FetchXML query.

  • Justin Wilkinson Profile Picture
    Justin Wilkinson 1,336 on at
    RE: Dynamic Marketing list Members Dashboard

    Hi I have currently 5-6 Y/N checkboxes against a contact.

    Is there a way to easily just create a dashboard off of those? rather than going through the Marketing list route and if so any chance of a breakdown

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,321 on at
    RE: Dynamic Marketing list Members Dashboard

    Hi,

    I thought about it and as per my opinion this is not a simple problem.

    You can get the count on update of a Marketing List.

    However, Actual time can change at anytime a new record is created, updated or deleted.

    Let's assume you create a Dynamics Marketing list targeting Accounts with following criteria:

    • Status Reason equals Active
    • State equals TX (Texas)

    When you create the marketing list, count was 10 records.

    Then another account from Texas is created and count is 11. However, marketing list is not updated, hence the count on the list is still 10.

    That means, you need to refresh the count every time a record is changed as per the criteria.

    If you need an estimate number of records, then it might work, but it is very hard to get the actuals when the dashboard/view is loaded.

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,321 on at
    RE: Dynamic Marketing list Members Dashboard

    Hi,

    Thank you for your query.

    Do you need to see the Member Count of Dynamic Marketing Lists in a View/Dashboard?

    It is not possible with any of the out-of-the-box features (including roll-up fields). The reason being, Dynamic Marketing List does not hold any records, its has a query (FetchXML) field which is executed to get the results (when needed).

    The only solution is to create a plugin to get and store the Member Count (probably in a new field) on the Marketing List.

    Basically, you should:

    • Run a plugin on create/update of a Dynamic Marketing List, get the FetchXML from the query attribute.
    • Execute this XML and get the Record count.
    • Update the Record count on Marketing List.

    Following post is old, but same should work or at least give you an idea:

    Get the total members count of a Dynamic Marketing List in CRM 2011. – Nishant Rana's Weblog

    Here is my recent blog on how we can manipulate Dynamic Marketing Lists (it does something different but it should give a glimpse how you can play with this):

    Dynamics 365 CE: Pre-filtering on Dynamic Marketing List | CRM Logs (wordpress.com)

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,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans