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.
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,
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?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156