I would like to understand the concept of List manager in Sitecore. Where is the data stored in Sql database of List manager. Showing list details:

enter image description here

Trying to understand where exactly the data is stored (Tables). And if we would like to delete the recipient count, then what would be the steps?

  • Which version of Sitecore? May 3, 2021 at 12:30
  • Sitecore Version 9.1.1
    – User7864
    May 3, 2021 at 12:34
  • Recipient count is calculated? Why do you need to delete it? May 3, 2021 at 12:35
  • I have deleted contact manually from Sql server now all contacts are deleted but List manager list still showing count.
    – User7864
    May 3, 2021 at 12:37
  • I believe indexing will do the trick in your case May 3, 2021 at 12:41

2 Answers 2


List Manager in Sitecore uses the "collection" database to store the values. It basically creates a contact in xDB whenever an email is added in the list manager, where the contact identifier will be "ListManager". You can directly query against your shared databases in SQL to get the contact id. If you will delete the contact from the List manager it will automatically update the recipient count once the XDB index will rebuild. you need to make sure your XDB index rebuild is working fine or you can try by manually run the XDB index rebuild - https://doc.sitecore.com/developers/91/sitecore-experience-platform/en/rebuild-the-xdb-index-in-solr.html


Your first question, the list data: List membership is stored in the xDB contact objects themselves, in the contact's ListSubscriptions facet.

Your second question, the recipient count in List Manager: At least in Sitecore 8 when I worked with it, the count in List Manager was stored separately and was not automatically synched if you programmatically added or removed contacts. You had to explicitly modify the count in List Manager; sorry, I no longer remember exactly how I did that.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.