- The Marketing Activity entity is a technical entity, to store information about metadata published to D365 from marketing services.
- Data older than 1 week can be deleted.
To free up storage, I was going through all D365 organizations and looking for potential candidates of information that can be deleted. In doing such, I discovered a new entity called Marketing Activity (msdyncrm_mktactivity). It is used for storing details from metadata sync process of D365 Marketing service user. This user is performing internal tasks like segment updates (adding new members to the segment based on filter criteria). The result of each internal task is stored as a marketing activity. Based on the number of active marketing elements like segments, customer journeys and marketing forms, it can grow up in a very short time period - noticeable.
Microsoft Support is in demand
Before creating a new support request, I performed a quick search on the internet and found a forum entry about this topic. The solution of the Microsoft Support is easy to implement:
To reduce the msdyncrm_mktactivity table, you can run a bulk delete job (or schedule it to run periodically) to delete data that's older than a week. We currently don't have any system jobs that will automatically clear this table, however we will have it in the future; but we don’t have the exact date though.
Therefore, I decided to create a flow using Power Automate to delete successfully completed marketing activities older than 1 week. Other activities in a different status will be deleted, if they are older than 4 weeks. This gives us the possibility to have a better overview of failed internal tasks - actually there aren't any :).
Flow has a few advantages over bulk delete jobs
I will write in my next article about the created flow to delete any data from D365. I prefer the Power Automate service over bulk delete jobs, because
- it has a better error handling,
- it can access more entities such as activities
- and it allows you to include the components like flows into a solution (CI/CD).
#Dynamics365Marketing #MarketingActivity #Storage #PowerAutomate