- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Raul,
Not sure to understand.
nms:deliveryLogsStats stores global statistics only, key is (deliveryId, domain) so for instance all global counts for gmail.com domain and one specific delivery.
If you have to extract data related to specific or all recipients, you must use nms:trackingLogRcp and nms:broadLogRcp for equivalent information (detailed information).
The same for nms:trackingStats, consolidated stats of tracking data nms:trackingLogRcp, not per recipient basis.
But please notice that these high volumetry nms:trackingLogRcp and nms:broadLogRcp tables are cleansed automatically (nightly) by the technical process "cleanup", based on the purge data settings, typically, 3 or 6 or 12 months depending on customer choices on data retention.
(see xtk:option values of NmsCleanup_TrackingLogPurgeDelay and NmsCleanup_BroadLogPurgeDelay for your own instance), either in Administration/Platform/Options or in the Tools/Advanced/Deployment Wizard menu of Adobe Campaign classic version if you have admin privileges.)
Regards
J-Serge