Every month, the same ritual: export lists from Magaya, move files between folders, open Excel, fix broken formulas, cross-reference data by operator, consolidate tables, and hope nothing breaks.
All of that just to answer one question: how is the operation performing?
The problem was never the report. The problem was that operational visibility depended on too much manual work.
Before automating any report, we solved something more fundamental: making sure what gets exported from Magaya is already clean data.
We implemented customizations, alerts, and quality controls inside the system so the source data doesn't need manual correction afterward. Without that, any automation just moves garbage faster.
The team spent hours every month on:
The result: slow reports, prone to errors, and decisions that came too late.
The workflow is this simple:
The macro takes all files from the folder, consolidates the data, removes duplicates automatically, and refreshes the dashboards.
It's not one generic dashboard. It's three specific views:
Volume Dashboard
Shipments and TEUs grouped by transport mode (air, ocean, ground), filterable by month.
Operations Dashboard
Productivity trends per employee: shipments moved, profit generated, hours worked, cost per hour, and a real productivity index.
Sales Dashboard
Target vs. actual per salesperson with fulfillment rate. Filterable by person, by month, or full overview.
All updated, all filterable, all without touching a formula.
Sometimes it means removing a repetitive task that should never have consumed that many hours. In this case, the solution was structuring what already existed and designing a workflow where Magaya feeds visibility instead of generating work.
When the operation is easier to read, decisions come faster.
Tell us about your operational friction and we'll show you if there's a simpler way to solve it.
Book a free diagnostic →Need something more robust? Explore Innobo Hub →