How Manifest Journals Transforms US Customs’ Import Data
We reveal the secrets behind the US Customs’ Import Data.
We introduce our name cracking technology.
We give the reasons why Manifest Journals is the choice of savvy users of the US Customs’ Import Data.

 
 
 
 
 
 
 
 
We now offer rollup/drill-down reporting and graphing. Click here for samples.

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.
How We Handle Multiple Versions of Foreign Manufacturers and US Importers Names: The Stats Behind our Name Cracking Technology
How inconsistent are the names of foreign manufacturers and US Importers in the raw data that US Customs sends us from the Automated Manifest System (AMS)?

Get the facts in the table below.

Consignee

2008

 
Final Consignee Names Category Count of Raw Consignee Names Count of Final Consignee Names Reduction in Raw
Names and Final Names
Total Bills for
Final Consignee Category
> 1000 25,181 595 97.7 % 1,453,821
500 to 999 21,210 996 95.4 % 673,148
250 to 499 35,594 2,390 93.3 % 819,865
100 to 249 73,310 7,754 89.5 % 1,184,165
50 to 99 75,765 12,012 84.2 % 830,763
20 to 49 122,124 28,166 77.0 % 871,068
10 to 19 102,508 34,004 66.9 % 461,684
5 to 9 110,949 50,305 54.7 % 330,228
1 to 4 458,323 399,703 12.8 % 598,074
 

2009

 
Final Consignee Names Category Count of Raw Consignee Names Count of Final Consignee Names Reduction in Raw
Names and Final Names
Total Bills for
Final Consignee Category
> 1000 15,835 328 98.0 % 768,497
500 to 999 13,937 607 95.7 % 417,186
250 to 499 21,394 1,397 93.5 % 477,245
100 to 249 45,334 4,762 89.5 % 724,421
50 to 99 51,495 8,029 84.5 % 554,636
20 to 49 85,611 19,911 76.8 % 611,406
10 to 19 75,367 25,180 66.6 % 342,258
5 to 9 84,606 38,760 54.2 % 254,386
1 to 4 357,002 311,260 12.9 % 466,904
 

Shipper

2008

 
Final Shipper Names Category Count of Raw Shipper Names Count of Final Shipper Names Reduction in Raw
Names and Final Names
Total Bills for
Final Shipper Category
> 1000 13,444 387 97.2 % 1,012,009
500 to 999 14,270 812 94.4 % 547,579
250 to 499 27,202 2,142 92.2 % 731,134
100 to 249 70,633 8,455 88.1 % 1,267,937
50 to 99 85,173 14,515 83.0 % 998,990
20 to 49 151,416 36,485 76.0 % 1,128,746
10 to 19 127,130 42,500 66.6 % 578,807
5 to 9 131,098 58,963 55.1 % 389,199
1 to 4 422,542 358,512 15.2 % 568,415
 

2009

 
Final Shipper Names Category Count of Raw Shipper Names Count of Final Shipper Names Reduction in Raw
Names and Final Names
Total Bills for
Final Shipper Category
> 1000 6,406 177 97.3 % 466,340
500 to 999 6,711 412 93.9 % 279,676
250 to 499 14,394 1,185 91.8 % 403,083
100 to 249 38,607 4,763 87.7 % 707,337
50 to 99 55,327 9,620 82.7 % 660,000
20 to 49 108,993 27,218 75.1 % 828,587
10 to 19 100,086 34,319 65.8 % 467,344
5 to 9 108,785 50,086 54.0 % 329,912
1 to 4 349,515 296,822 15.1 % 474,648
 

Note on Counts in Table

How to Read this Table from Left to Right:

1. In Final Consignee Names Category, you see the seven categories that we divided the final names into. In the 500 – 999 category, you are seeing those final consignee names that end up appearing on 500 to 999 bills of lading.

2. A raw consignee name is the version of the consignee name that appears in the raw US Import Data.

3. A final consignee name is the consignee name that Manifest Journals applies to the raw consignee name with our name cracking technology.

4. Reduction in Raw Names… is the percentage reduction between the raw consignee names and final consignee names after name cracking.

5. Total Bills for Final Consignee Names is the total number of bills of lading for the Final Consignee Names Category.

How We Fix the Four Big Problems in the Raw Data from US Customs
 
 
 
 
 
 
 
 
 
 
 
Copyrights © 2009 Manifest Journals | All rights reserved Privacy Policy | Terms & Conditions About us| Contact us