The error in the File Drop Automation is due to the filename pattern not matching exactly because of additional seconds and milliseconds in the filename. To resolve this issue:
* Modify the Import File activity to use the %%FILENAME_FROM_TRIGGER%% personalization string. This ensures that the Import File activity dynamically accepts the filename exactly as it is uploaded to the SFTP location.
* Update the filename pattern in the automation setup to avoid hardcoding the date format and instead rely on the filename that triggered the automation.
* By using %%FILENAME_FROM_TRIGGER%%, the automation becomes flexible and will correctly handle any file name that matches the initial pattern triggering the automation, regardless of additional timestamp details.

Explanation
The Email Send Report in Analytics Builder is the best place to view the total number of emails sent across all business units in the last calendar year. This report provides a summary of email performance metrics such as sends, opens, clicks, bounces, and unsubscribes for a specified time period.

To configure multiple business units in Marketing Cloud to use the same SFTP directory, the most efficient method is to copy the parent SFTP user credentials into each child business unit. This approach ensures all business units access the same SFTP directory for file transfers, maintaining consistency and simplifying management of file access across the business units. This setup avoids the complexity and maintenance of separate SFTP users for each business unit, streamlining operations.

Datorama is a marketing intelligence platform that can integrate data from various sources, such as Marketing Cloud, Google Analytics, Facebook Ads, and DoubleClick Bid Manager, and provide insights and analytics to optimize marketing campaigns.