Daily Logistics Performance Tracker

Automate daily logistics performance tracking and reporting via Slack.

About
This workflow automates the process of tracking and reporting logistics performance metrics. It retrieves data from BigQuery to analyze shipment delivery statistics, including total deliveries, on-time deliveries, and active companies over the past three months. The results are then formatted and sent to a specified Slack channel as a daily report. This tool is ideal for logistics managers and teams who need to monitor performance and ensure timely deliveries. By providing automated insights, it helps in making informed decisions and improving operational efficiency.
How to use this template
  1. Ensure you have access to the necessary BigQuery and Slack accounts.
  2. Configure the BigQuery query to match your dataset's structure, if necessary.
  3. Schedule the workflow by setting the desired time in the cron expression (default is 4:30 AM daily).
  4. Specify the Slack channel ID where the report should be sent.
  5. Deploy and activate the workflow.
  6. Monitor the Slack channel for daily updates on logistics performance metrics.