Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Dataverse Corresponding Tables of Timeline and Insights data

Posted on by 30

Does anyone know which corresponding dataverse tables the Timeline and Insights data resides?

Timeline card (under summary Tab) has the email, appointment, etc activities.

Insights has the interactions on email, event, marketing form interactions.

I'm curious on how they are stored backend as we want to do additional analysis using these data.

  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    RE: Dataverse Corresponding Tables of Timeline and Insights data

    Hey.

    The link you've pasted is for OnPremise.  for Online, the documentation points to docs.microsoft.com/.../activitypointer   You'll see a field "ActivityTypeCode" which would point to the other entity (for example the ID of Email entity).

    Regards,

  • MiltonC Profile Picture
    MiltonC 30 on at
    RE: Dataverse Corresponding Tables of Timeline and Insights data

    Thanks and greatly appreciate your response.

    Using https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/entities/activitypointer?view=op-9-1 as reference, is my understanding correct that ActivityPointer can be mapped/joined by the other activites (Email, PhoneCall, etc) by ActivityId?

  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    RE: Dataverse Corresponding Tables of Timeline and Insights data

    Hey!

    The timeleine is not a table but a Control that pops up information from

    - ActivityPointerBase (the list of activities - emails, notes, calls - handled)
    - Each one of the previous tables, in order to get the details (Email, Annotation, PhoneCall tables)

    Insights are usually stored into a different set of tables (usually ending in "*-analytics".  This is documented on https://docs.microsoft.com/en-us/power-platform/admin/capacity-storage#what-are-tables-ending-in---analytics-in-my-capacity-report but I'm not sure if you can retrieve this data for processing.

    Regards

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans