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.
|
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 |
|
|
 |
|
 |
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.
|
|
 |
|