Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

Sales insights tables (email-analytics and activityparty-analytics) consume too much space

(0) ShareShare
ReportReport
Posted on by 25

Hi all,

Some time ago we turned on Sales Insights (basic version) on our production instance, and on the next day I saw two new tables email-analytics and activityparty-analytics, and they were 120Gb total.

I believe they contain some data for sales insights.
We indeed have lots(millions) of emails, 99% of it is Customer Support related messages, which we definitely do not need to to analyze and deleting them is not an option.

I didn't find any switches or settings to change such behaviour, or turn off Sales Insights.
I only disabled all assistant cards.


Any thoughts on how to clean the database?
1222.2020_2D00_11_2D00_09-09_5F00_34_5F00_23_2D00_Window.png

2570.2020_2D00_11_2D00_09-09_5F00_34_5F00_14_2D00_Window.png

  • Priyesh Profile Picture
    7,396 User Group Leader on at
    RE: Sales insights tables (email-analytics and activityparty-analytics) consume too much space

    Hi,

    Pardon me for bringing this thread back.

    I'm having similar issues in seeing the File storage ballooning because of the <entity>-Analytics table and not finding where this data is actually stored.

    Wanted to confirm if deleting the solution is the only way? In my case, I can't see any Insights application installed on the environment.

    Kindly advise. :)

    Thanks in advance!

  • Suggested answer
    Carolina Mogas Profile Picture
    on at
    RE: Sales insights tables (email-analytics and activityparty-analytics) consume too much space

    Hello Andrei,

    Email-Analytics and Activityparty-Analytics are tables which will be created after Sales Insights is deployed in an environment.

    You can verify what are the entities currently enabled for Azure Data Lake Services integration by accessing the following entity through an API request:

    https://[organization URI]/api/data/v9.0/entityanalyticsconfigs

    All entities retrieved in this request that contain "isenabledforadls":true can potentially create a table for Analytics.

    In order to reduce the consumption, the solution that contains this functionality should be uninstalled (in this case Sales Insights) and the tables should be cleaned up automatically in 48h.

    However, before proceeding with this action, please raise a case with Technical Support so we can investigate this further for your specific environments.

    Thank you!

    Carolina


    Thank you for using Microsoft Dynamics 365 Communities!

    Carolina Mogas, Support Engineer
    Dynamics 365

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,289 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,068 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans