Home | Subscription Management | Displaying All Members Subscribed to a Subscription List

Displaying All Members Subscribed to a Subscription List

Want to see at-a-glance how popular all your subscription topics are? Real-time reporting for subscription lists is achievable in a few quick steps.

Before we dive in, please note that this blog post will go through some simple customizations to your Dynamics environment. Also, this method will assume that all members of your marketing list have opted in to receive your emails and that you maintain your lists by removing anyone who opts-out. If you need help with maintaining your marketing lists, take a look at this help article, which covers this process in more detail. Finally, this method is only compatible with static marketing lists. That’s because dynamic marketing lists do not populate a value for Member Count, which is crucial for this process.

Note: This article involves creating rollup fields. Rollup fields were introduced in Microsoft Dynamics CRM 2015. If you require any assistance with configuring these fields or any of the native CRM reporting functions (charts, dashboards, etc.), please contact your CRM administrator or partner.

To start, create a rollup field on the subscription list record to display the total number of people on each marketing list associated to the subscription list. To create the new field, open the form editor for the subscription list entity:

Next, create a new field by clicking the New Field button in the bottom right corner in the Field Explorer section:

Then, give the field a name and set the Data Type as Whole Number and the Field Type as Rollup, as shown below:

Then, set the criteria for the rollup field by clicking the Edit button:

The criteria above will reference the member count value of each marketing list associated to the subscription list and will display the sum of these values:

Once this field is set up, it will auto calculate the total number of members each time someone is added to or removed from a marketing list.

With a numerical count of how many people are currently subscribed to any given topic, we can start to build out visual representations of this data with charts, such as this one:

To create this chart, navigate to your view of subscription lists. Click on the Charts pane on the right side and click the plus to add a new Chart:

In the chart designer, set the Series to Number of Members and Sum, then set the Category to Name. This will produce the following result:

Click the Save button and you’re done! You can even add this chart to a dashboard to create your own subscription center.

Happy Marketing!

2018-11-08T11:33:43+00:00 By |Subscription Management|4 Comments

About the Author:

mm
Emma D'Arcy is a ClickDimensions Product Consultant.

4 Comments

  1. Gosia December 11, 2018 at 9:04 am - Reply

    Could you clarify something.
    In that Number of Members sum, do you include record which didn’t confirm subscription to specific subscription list?

    We did that logic and it show normal marketing list members (summed up of leads and contacts). We would like to know, how many people from that 2 marketing list are actually subscribed.

    • mm
      ClickDimensions Marketing December 11, 2018 at 3:19 pm - Reply

      Thanks for your question! The blog post assumes you keep your marketing lists clean using either campaign automation or via workflow. The roll up fields are simply adding up everyone on your marketing lists because it is assumed that everyone on the list has opted in. If someone opts out via subscription management, it is recommended that you utilize a method to remove them from the list, thus keeping the numbers as accurate as possible.

  2. Henrik December 20, 2018 at 5:38 am - Reply

    Is there no way to count the number of subscribers, if you do not keep marketing lists clean, as this post assumes?

    We use Marketing Lists broader than that. Basically someone who has a specific interest, but haven’t necessarily opted in to a subscription. To be honest I don’t know why we would keep Marketing lists clean that way, when we know the Subscription list already handles that.

Leave A Comment