Manifest Journals

US Customs Data for International Trade Intelligence. If you knew the condition of the raw data that we get from US Customs, you would wonder how we can offer rollup/drill-down reporting and graphing. To rollup data, drill-down into data, and graph data, you must have consistent values in the fields that you are working with. US Customs sends us a file each day from the Automated Manifest System (AMS). The values in the US Customs AMS file are far from consistent. The root cause of the inconsistency is how data actually gets entered into the AMS. The Automated Manifest System is a free text entry system.(You can read the whole story here.) By law, US Customs can’t send us a cleaner file. They must send us an output of exactly what shipping lines and freight forwarders typed in the AMS. In fact, the data from the AMS is so inconsistent that we think your real concern ought to be how Manifest Journals prepares the data tables underneath the rollups, drill-downs, and graphs that you see in your browser. Read how Manifest Journals solves the 4 biggest problems in the US Customs raw data. Our solutions to these problems let us prepare the data tables for roll-up/drill-down reporting and graphing.