eCommerce Shipping Solutions: Finding the Best – Part II
This is the continuation of the Choosing an eCommerce Shipping Solution: Part I and expands the selection criteria to analytics and reporting from integrations and data flow.
Shipping Software: Analytics and Reporting
Your shipping data holds enormous power for your overall business, so the ability to analyze it and report against it is a critical capability of any shipping platform.
Here are the critical data elements you will want your shipping solution to be able to report on:
- Ship Date: Date the shipment enters the mail stream (should match the date on the shipping label)
- User: Which user created the shipping label
- Order Date: Date the customer placed the order on your website
- Order Total: The total amount your customer paid to you including item cost, shipping charge and taxes (should match the Order Total on your website)
- Store: The website that the order was placed from
- Order Number: Unique order identifier (should match the order number on your website for quick recognition)
- Ship From: The Return Company/Name on the shipping label
- Ship From Address: The Return Address on the shipping label
- Recipient: The Ship To name on the shipping label
- Purchase Billing Address: The Billing Address associated with the payment method for the order
- Recipient Shipping Address: The Ship To Address on the shipping label
- Email Address: The email address is typically associated with the recipient to receive the shipment confirmation email
- Carrier: The shipping carrier transporting and delivering the package
- Rate Provider: Which postage account or carrier account the label postage was charged to
- Service Type: The carrier service of the package (typically determines how quickly the shipment will be delivered)
- Package Type: The package option selected for the shipping label (should match the actual package of the shipment)
- Confirmation Option: If you pay an additional fee for extra delivery confirmation (e.g., Signature Confirmation), will list the add-on
- Quantity: Number of items shipped in the order
- Weight (oz): The weight (in ounces) of the shipment (helpful for accurate postage cost, but also for future reference to understand the items in the package)
- Zone: The Zone relates to the distance between the origin and delivery address (the smaller the zone number, the closer the delivery; the larger the number, the farther away)
- Destination Country: Helps to distinguish between domestic and international shipments (can be useful to determine the percentage of shipments you send out of the country)
- Tracking Number: Great reference to determine delivery status of a particular shipment
- Shipping Paid (By Customer): How much your customer paid to you for shipping
- Postage Cost: How much you actually paid for the shipping label
- Insurance Cost: If you added insurance, will list the amount you paid (directly relates to the declared value for coverage)
- Total Shipping Cost: The cost of the shipping label plus any insurance and additional confirmations
- Shipping Margin: The difference between how much your customer paid you for shipping and the amount you paid for the shipping label: Did you make or lose money? (This helps to determine how much you should charge on your website.)
- SKU: Unique identifier of your items (helps to determine your most popular items and can be used to manage inventory)
What do you do with all of these data elements?
A good shipping platform allows you to aggregate or segment shipping data by customer, geography, carrier, service level, product type, distribution center or other shipping parameter. This is especially powerful if you sell on multiple stores—as a shipping platform can help you aggregate and segment data across all of them—but even with a single store, a shipping platform can provide unique views by aggregating shipping and sales data.
Here are some of the most common analyses you should expect your shipping solution’s reporting to enable:
- Shipping costs/margins: Determine whether you are making a profit, losing money or breaking even on shipping. Compare the total shipping paid by your customers versus total shipping cost incurred for a set of orders.
- Geography/Service level/Carrier: Free shipping is popular; fast shipping is impressive. A Geography/Service Level/Carrier report allows you to determine which service gets the order to its destination fastest (impresses the customer) and cheapest (im presses your boss). For example, USPS Priority Mail Regional Rate may be the fastest and cheapest for zones 1-4; but USPS Priority Mail Flat Rate may be the fastest and cheapest for zones 5-9.
- Oldest unshipped orders: Find out how long your customers have been waiting and how much earned revenue you’re missing out on by not getting these orders out—not to mention social media backlash if orders are taking too long to ship. In most situations, customers expect to see shipments go out within two to three business days of purchase (unless otherwise specified).
- User reports: Evaluate the efficiency/workload across different users of the shipping platform (by login). Find out which user is generating the most labels. Adjust each shipping station so they’re all as efficient as the best shipper. Also, if you’re getting reports of inaccurate deliveries (undelivered, postage due on delivery, etc.), you can check to see which user shipped the package and retrain that user accordingly.
- Store reports: If you sell on multiple stores, having aggregate shipping data in a shipping platform allows you to report on each store’s relative performance (versus downloading data from each store, consolidating it, and analyzing it in a spreadsheet). Compare your stores to see which one is the most popular/profitable. Notice what’s different about the stores so you can ensure that you’re selling the most product and making the most profit. Cross-promote one store to customers who frequent another.
- Order value or products bought vs. geography: determine your most profitable areas of the country and target your promotions and advertising accordingly.
- Order value or products bought vs. season (or other temporal construct): use this report to determine your most popular products at various points in the year. You can use this information to run promotions during those times.
- Order history: Analyze past customer purchases to target customers with promotions (especially if you’re selling on multiple platforms, but be sure to run platform-agnostic promotions).
- Daily shipped orders report: use this to update inventory and tweak production or replenishment processes on a daily basis.
- Daily unshipped orders report: use this report to build or replenish inventory based on demand. You’ll want to be able to select all orders you’re going to ship the next day. The report will include SKU, item description and total quantity to allow you to ensure that you have enough product in stock to ship out all orders.
- Shipped orders report: export a CSV of all of the items you’ve shipped in a given time frame. The report should include SKU, item description and total quantity so you can manage your inventory (for example, by deducting the number of items shipped) and look at longer-term inventory trends.
These analyses represent some of the more common ways to use a shipping platform to deliver valuable business insight. If you’re not currently leveraging the reporting ability of a shipping platform, we recommend you start with the most interesting reports from the above list and begin working with them; you will soon find opportunities to customize them to be more specific to your business, and come up with new analysis/reporting ideas you’ll want to test out. The key is having a shipping platform with robust data collection, analytics, and reporting capabilities.
Related Articles & Resources
- Choosing an eCommerce Shipping Solution: Part I
- Choosing an eCommerce Shipping Solution: Part III
- Choosing an eCommerce Shipping Solution: features and benefits
- Choosing a Shipping Solution: download vendor evaluation tool
- View ShippingEasy integrations
- Shipping process flowchart: advanced process with weight in selling platform
- Shipping process flowchart: advanced process without weight in selling platform
This article is from The Definitive Guide to eCommerce Shipping