Post-Flight Progress Extract
Overview
Includes all data related to automated post-flight updates, such as flight status changes and carrier-provided updates, to support operational visibility after departure. This extract specifically indicates when the automation retrieved post-flight information for a booking.
Extract Data
| Column | Description |
|---|---|
| master_airwaybill | Airway bill of the carrier that the post flight automation ran on |
| carrier_id | Id of the carrier used on the booking |
| total_time_ran | Number of times the post flight automation ran on the booking. The post flight automatically runs when the user accesses the post flight information on the booking. |
| failed_count | When the automation encounters any errors which include the site being down, or unable to retrieve data |
Example Calculations
Automation Time Saved (Post Flight)
To estimate the time saved by the post-flight progress automation, follow the steps below:
- Subtract the number of failed automation attempts (
failed_count) from the total number of times the automation has run (total_time_ran). This is because failed runs do not result in any time savings. - Multiply the result by 5 minutes, which is the average time it would take a user to manually retrieve and enter post-flight information into QMS.
(total_time_ran - failed_count) * 5 = total minutes saved
You can further expand this analysis by using the carrier_id field to break down the automation activity by carrier. This allows for more detailed reporting and insights into which carriers the automation is running on, helping to identify trends or areas for improvement.