Data Validation
      Back to home
      1. Wicked Help Center
      2. 4. TROUBLESHOOTING
      3. Data Validation

      API Order Validation Checklist

      Use this document to validate the quality of your API order data

      Order Validation Checklist:

      This is a series of yes or no questions designed to help validate the quality of your API order data. This is not an exhaustive list, but will certainly prepare you with general coverage.    

      1. Do you have all the required key-value pairs? And, do they have the correct format?
      2. Are you using the correct conditional fields? (ContactID vs ContactEmail). ContactEmail is the recommended choice.
      3. Have you reviewed the optional key-value pairs? And, do they have the correct format?
      4. Verify your CreateDate:
        1. For your CreateDate value, are you certain you've converted it into a UTC+0 timezone?
          1. Note: If you're sending data via HTTP post or Zapier, this does not apply to you because Wicked does the conversion for you. However, all other data must be converted into UTC+0 before being passed into Wicked Reports.
        2. For your CreateDate value, are you certain you've formatted it correctly?
          (YYYY-MM-DD HH:MM:SS). It must be down to the second.
          1. Note: If you enter a false value here, your attribution will be inaccurate. 
      5. Verify that you are sending unique orders to Wicked on an immediate or daily basis:
        1. Are you certain you're sending a unique SourceID? (i.e. no duplicates SourceIDs)
        2. If you are sending IP Address, are you certain that you're using a unique IP Address per ContactEmail (or ContactID)?
      6. If your business has subscriptions, then you must verify your SubscriptionID:
        1. If your business utilizes subscriptions, did you include the SubscriptionID key-value pair?
        2. If your business utilizes subscriptions, are you certain you're using a unique Subscription ID?
      7. If you need to filter your reports by Product Information, then OrderItems and ProductData are required. Run Steps #1-5 to verify your OrderItems and ProductData.
      8. If you need to process Payment Status (e.g. refunds), then OrderPayments is required. Run Steps #1-5 to verify your OrderPayments

      If you've answered yes (or N/A) to all these questions, then you can feel confident that you've done your very best to validate the quality of your data. If you've answered no to any of these questions, then please rectify it and turn that no into a yes.

      If you need further assistance in validating the quality of your data, then please reach out to us at support@wickedreports.com.