Filter Guide
Reference for Power Query search filters across all ImportYeti datasets — what each filter does, how to use it, and when it is most useful.
Showing 38 of 38 filters
| Label | Description | Example | What is it good for |
|---|---|---|---|
| Company | Searches shipments by the importing company name entered in the field. | Enter: walmart | Great for narrowing down shipments from specific entities, e.g. seeing all of Walmart's shipments |
| Company Total Shipments | Filters companies by their total number of shipments in the selected period. | Set: >= 500 shipments | Great for understanding the number of BOLs a customer has. Good for narrowing down market segments between enterprise, mid-level, and smaller customers |
| Company Address | Searches using the company address (street, city, or partial address). | Enter: Los Angeles | Great to find where headquarters are located. Useful if trying to do face-to-face visits or identifying where decision makers are |
| China Concentration | Shows what share of a company's sourcing volume comes from China. | Set: > 70% | Great for understanding potential risks of a company, as tariffs or other international events may occur |
| Company Manifest Confidentiality | Filters companies by the confidentiality level of their manifest records. | Select: Confidential | Useful to understand how much shipment data is visible. Non-confidential companies will have more accessible data for analysis |
| Company SCAC Codes Diversity | Measures how diverse a company's used carrier SCAC codes are. | Set: high diversity | Shows how many different companies they use to move their international freight. The higher the number, the more providers they use and the higher likelihood you can get in as a new provider |
| Company First Shipment Date | Filters by the date of the company's first recorded shipment. | Select: after 2022-01-01 | Great to see companies new to international shipping |
| Supplier | Searches shipments by supplier (exporter) name. | Enter: foxconn | Useful for finding specific suppliers and narrowing down sourcing relationships |
| Supplier Total Shipments | Filters suppliers by their total shipment count. | Set: >= 1000 | Great for identifying high-volume suppliers and key exporters |
| Supplier Address | Searches by supplier address. | Enter: Shenzhen | Great to find companies in areas you are strong at picking up from, e.g. if you specialize in certain regions |
| Supplier Country | Filters suppliers by country. | Select: China | Great to narrow down originations. If you have a strong network in a region, you can find companies sourcing from there |
| Present in Alibaba? | Shows whether the supplier has a presence on Alibaba. | Select: Yes | Useful to identify more publicly visible / easier-to-source suppliers vs private manufacturers |
| Value in USD (CIF) | Filters shipments by declared CIF value in USD. | Set: > 50000 USD | Useful for identifying higher value shipments that may require better service, insurance, or priority handling |
| Destination Port | Searches by U.S. port of entry. | Enter: Long Beach | Great for identifying specific ocean lanes and U.S. entry points |
| Departure Port | Searches by origin/departure port. | Enter: Shanghai | Useful for finding ocean lanes and analyzing foreign origin points |
| Carrier SCAC Code | Filters by carrier SCAC code. | Enter: MAEU | Great to find other freight forwarders you know you have better pricing or service than |
| Shipping Container | Filters by container type (e.g., 20GP, 40HQ). | Select: 40ft | Can help determine what mode of transportation the goods will need once in the U.S., e.g. reefer or special handling |
| Weight | Filters shipments by shipment weight. | Set: > 10000 kg | Useful for identifying heavy cargo patterns and freight cost drivers |
| TEU | Filters by shipment volume measured in TEU. | Set: >= 2 TEU | Great for segmenting customer size into enterprise, mid-market, or smaller shippers |
| Vessel Name | Searches by vessel name used for transport. | Enter: Ever Shine | Great to identify which ocean line their existing FF is booking with |
| Internal Shipments | Flags internal shipments between related entities. | Select: Show | Indicates shipments coming from a parent or related company |
| Final Clearing Destination | Filters by the foreign port of destination for T&E (62) and IE (63) in-bond entries. | Enter: Toronto | Useful for tracing where in-bond shipments are cleared outside the U.S. |
| Container ID | Searches by unique container identifier. | Enter: MSCU1234567 | Tracking a specific container |
| Service Type (Drayage Responsibility) | Filters by container service type. | Select: HH | Understanding how involved their current FF or SSL is. Also helps identify who pays for drayage |
| Quantity | Filters by product quantity in the shipment. | Set: >= 1000 | See how goods are packed. Helps identify if transloading or pick and pack services are needed |
| Container Booked With | Shows who booked the container (SSL or freight forwarder). | Select: Freight Forwarder | See if they go directly with an SSL or use a freight forwarder |
| Product Description | Searches by textual product description from shipping records. | Enter: cotton | Useful for finding products that require additional service or higher insurance |
| Industry | Filters by industry inferred from HS classification. | Select: Apparel | Useful for quick industry segmentation |
| HS / HTS Code | Filters by HS/HTS tariff code. | Enter: 620342 | Useful for identifying specific product types and compliance requirements |
| ALL | Runs a broad search across multiple fields at once. | Enter: samsung | Useful as a fast first pass when the exact search field is unknown |
| Company, Supplier or NP | Searches across company, supplier, or notify party names. | Enter: unilever | Useful for finding entities across the full supply chain |
| Phone Number | Filters results by phone number found in available records. | Enter: +120* | Search by phone number or part of a phone number |
| Email Address | Filters by email address captured in shipment documentation. | Enter: *@ikea.com | Useful to find domains and potential contacts |
| Notify Party Name | Searches by notify party entity name. | Enter: DHL GLOBAL FORWARDING | Great to search for customs brokers, warehouses, and DCs |
| Notify Party Address | Searches by notify party address. | Enter: Miami | Great for searching final destination areas and outbound freight opportunities |
| BOL Number | Searches by unique Bill of Lading number. | Enter: MAEU123456789 | Search by specific BOL number |
| BOL Bill Type | Filters by Bill of Lading document type. For In-Bond Regular or In-Bond Master, you can further filter by in-bond movement type (IT, TE, or IE). | Select: In-Bond Regular → 61 - IT | Useful for analyzing house vs master BOL, in-bond shipments, and specific customs movement types |
| Rail Ramp (Destination) | Filters shipments by inland rail ramp destination. | Enter: Chicago | Useful for finding rail ramps and inland intermodal routes |