Check Missing Files: Ensuring Your Data Integrity in Optimove

💡Basic Definition
Check Missing Files is a checkpoint in the ETL (Extract, Transform, Load) process that ensures all necessary files have been uploaded for the Daily Process. The client determines the criteria for Check Missing Files (CMF) during the onboarding phase.

What is Check Missing Files?

Check Missing Files acts as a safeguard in Optimove’s ETL process. It verifies that all client-specified files, which are required for the Daily Process, have been successfully uploaded. If any file is missing, the system responds according to the client’s pre-defined settings. This feature ensures that data integrity is maintained and the system functions as expected.

How Does Check Missing Files Work?

The Check Missing Files mechanism relies on a list of expected files specified by the client during onboarding. Every day, Optimove checks if all these files have been uploaded. Depending on the client’s configuration, the system takes one of two actions when a file is missing:

1. Fail the Daily Process: The process stops immediately, and the client is notified.
2. Notify Only: The client is alerted, but the process continues.
   This flexibility allows clients to prioritize their workflows and ensure critical files are handled appropriately.

Customizing Check Missing Files Settings

You can configure how Check Missing Files handles missing files by defining one of three settings for each file:

1. Fail and Notify
   • The Batch Data Process halts immediately if the file is missing.
   • An email notification is sent to the client, and the missing file must be uploaded before the process can proceed.
   • Clients can respond to the notification email to alert Optimove’s support team once the file is ready.
2. Not Fail and Notify
   • The process continues without the missing file.
   • The client receives an email notification, ensuring they are aware of the issue without interrupting data loading and campaign execution.
3. The file is Not Included in the Missing Files Check
   • Optimove skips checking this file and does not notify the client if it is missing.
   • This option is ideal for files that are not critical to the Daily Process.

   Examples of File Configuration

   To better understand how these settings work, here’s an example configuration:

• “Customers” file → Fail and Notify

If the "Customers" file is missing, the process stops, and the client is notified immediately.

• “Games” file → Not Fail and Notify

If the "Games" file is missing, the process continues, and the client is notified.

• “Game_types” file → Not Included in Missing Files Check

If the "Game_types" file is missing, the process continues without notification.

Key Takeaways

• Check Missing Files ensures critical files are accounted for in the Daily Process.
• You have full control over how missing files are handled, with flexible settings to suit their operational needs.
• By defining these settings during onboarding, clients can safeguard data integrity while maintaining the smooth execution of campaigns.

For more information or assistance with configuring your Check Missing Files settings, contact your Optimove Customer Success Manager or support team