0

Our client's SFMC Contacts count is overage, and before we can perform the contact deletion to reduce the contacts count, we would like to know the contacts count trend over the past 6 months.

I wonder if we have any approaches to find out that.

My very rough idea is using the Mobile filter list workaround to get all subscriber keys in All contacts list, then mapping with _Subscribers , _MobileAddress, and _PushAddress data views to get the CreatedDate field then use it to filter out. However MC contact data model is complex with many layers and not all data views using subscriber key but contact ID for mapping so I am not sure how this idea is going to work.

Improve this question
1

1 Answer 1

Reset to default
1

If you just need to know your contacts count trend over the past 6 months, you can simply run the Contacts Count report in your ENT Business Unit:

enter image description here

Where you should select a custom date range to cover 6 months:

enter image description here

It will display the billable contact count by week, and additionally break it down by the contact source, e.g. MobileConnect:

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .