How does it handle weight unit discrepancies?

It features a critical weight validation step that checks for common errors, such as using per-item weight instead of total shipment weight or confusing ounces with pounds.

What shipping platforms are supported?

The skill includes native mappings for ShipStation and FreightClub exports, but it can be adapted to any CSV/XLSX shipping data with user-provided column mapping.

What are the primary outputs of the analysis?

The skill generates an 8-sheet analysis covering Profile Summary, Weight Distribution (aligned to rate cards), Zone Distribution, Destination Footprint, DIM Exposure, Carrier Mix, Operational Patterns, and Data Quality.

Does this skill provide savings estimates for customers?

No. Following the 'Discovery Before Solutions' philosophy, this skill provides factual data analysis for internal rate teams and avoids premature savings projections.

Shipping Data Analyst Expert

Name: Shipping Data Analyst Expert
Author: WalkerVVV

byWalkerVVV

•

数据科学与机器学习

Analyzes logistics exports to provide structured rate preparation intelligence and shipping profile discovery.

关于

The Shipping Data Analyst Expert is a specialized discovery tool designed to transform raw shipping exports from platforms like ShipStation and FreightClub into actionable internal intelligence. By focusing on 'Discovery Before Solutions,' this skill meticulously validates weight columns, maps complex data fields, and generates comprehensive reports on weight bands, zone distributions, and DIM exposure. It is specifically engineered for logistics rate teams to build accurate pricing models based on factual historical data rather than estimates, ensuring high-confidence handoffs in the sales pipeline.

主要功能

Critical weight validation logic to prevent unit-of-measure and per-item errors
Data quality auditing with confidence scores for weight, zones, and dimensions
1 GitHub stars
Multi-sheet analysis including weight distribution, zone footprints, and carrier mix
Automated column mapping for ShipStation, FreightClub, and standard PLD exports
Xparcel rate card alignment for precise tier-based pricing analysis

使用场景

Preparing internal rate prep summaries from prospect shipping data exports
Auditing historical parcel data for DIM weight exposure and billable weight gaps
Normalizing disparate shipping data into a standardized format for rate teams

关于

主要功能

Critical weight validation logic to prevent unit-of-measure and per-item errors
Data quality auditing with confidence scores for weight, zones, and dimensions
1 GitHub stars
Multi-sheet analysis including weight distribution, zone footprints, and carrier mix
Automated column mapping for ShipStation, FreightClub, and standard PLD exports
Xparcel rate card alignment for precise tier-based pricing analysis

使用场景

Preparing internal rate prep summaries from prospect shipping data exports
Auditing historical parcel data for DIM weight exposure and billable weight gaps
Normalizing disparate shipping data into a standardized format for rate teams