Hi @dishasharma ,
It's important to note that instead of manually inserting or updating records in these tables, which could lead to more significant issues, it’s better to focus on resolving the root cause of why opens are not being tracked. Fixing the underlying issue ensures long-term stability and accuracy in your tracking data.
Though for your query on manual data insertion, you are right, the @type attribute you mentioned is not in the nms:trackingLogRcp schema but rather in the nms:trackingUrl schema. This attribute is an enumeration field, and its possible values are defined in the nms:trackingUrlInfo table. example: value "2" represents an open, "1" represents an email click. Also, to manually update open tracking logs with some sample data, it is crucial to ensure that the information in the nms:trackingLogRcp table is updated along with its linked tables, such as nms:trackingUrl, to maintain the integrity of your tracking data. Any inconsistency between these tables could lead to inaccurate reporting and other issues.
Best regards,
MEIT MEDIA (https://www.meitmedia.com)
Find us on LinkedIn
Contact Us: infomeitmedia@gmail.com
