QuickGuide #02: Data Integrity Process (DIP)

Answer

Data Integrity Process
Data Integrity Process (or DIP) is a mechanism to compare your IBM Digital Analytics Order data collection with that of your eCommerce back-end system.

Business Benefits:
a)?? ?To help establish confidence in the accuracy of Order reporting within IBM Digital Analytics
b)?? ?To aid as an investigation tool with potential order data collection issues

Key Details:
o?? ?DIP reporting is available within IBM Digital Analytics under Reports -> Custom Reports?
o?? ?DIP feature is not available in Test reporting
o?? ?DIP Participation is recommended not mandatory.
o?? ?If order accuracy to be investigated by Support then DIP Participation is mandatory.?
o?? ?IBM Digital Analytics Order data is expected to be in the range of 90% - 105% of your backend order data. If the order data variance lies outside of this acceptable range please contact Support to conduct a DIP investigation to identify and resolve discrepancies.
o?? ?DIP relies on unique Order IDs used on your website and reused Order IDs are not processed

Process:

1. Client to raise a Support ticket specifying the Client ID(s) for which DIP is to be enabled for
2. Support will enable DIP for the Client ID(s) and provide FTP credentials for daily a DIP file upload.
   DIP filename for a single Client ID must be in this format: "DIP_<client_id>_<YYYYMMDD>.csv"
3. The client will need to upload the DIP file specified as per format below