Platform: Enolytics DTC
Summary:
What it shows: This ready-made report displays your average shipping costs broken down by destination state and order size (number of bottles). It includes (1) only orders with actual shipping destinations (excludes local pickup/delivery), and (2) only orders with shipping costs of $0 or more. No setup needed — just open and analyze.
Who should use it:
• Operations managers optimizing shipping strategies
• Finance teams analyzing shipping cost patterns
• Fulfillment coordinators planning logistics
When to use it:
• Evaluating shipping rates across different states and order sizes
• Identifying opportunities to adjust shipping policies or thresholds
• Analyzing how bottle quantity affects shipping economics by region
Questions this report answers:
• "How do I see average shipping costs by state and bottle count?"
• "Where can I find shipping cost patterns across different order sizes?"
• "Can I get a breakdown of what we're spending on shipping by region?"
• "How do I compare shipping costs between states for different bottle quantities?"
• "Where do I find data to optimize our shipping rates and policies?"
Tip: Use the Bottles In Order column to spot opportunities for volume shipping discounts — states with high shipping costs on small orders might benefit from free shipping thresholds that encourage larger purchases.
Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.
📂 How to Access This Report
This is a public bookmark — a pre-built report ready for you to use. You don't need to create it from scratch.
To open it:
Click the Bookmarks icon in the left sidebar
Look under Public Bookmarks
Open the folder: Business Reports/Shipping
Click Avg Shipping by State and Bottle Quantity
Quick Stats:
2 filter(s) applied
2 dimension(s) displayed
1 measure(s) displayed
Report Page: Build Beyond Limits | Advanced Reporting
⚠️ Date Picker Required: This report uses time-sensitive measures that respond to the date picker. The bookmark does not save date picker settings. Please adjust the date picker to ensure the report shows the data for your desired time period.
Filter Behavior: When you select this bookmark, your existing filters will be replaced with the bookmark's saved filters.
📝 Original Description
Average shipping costs report broken down by destination state and order size in bottles, excluding pickup orders and negative costs.
Filters Applied
The following filters narrow down the data in this bookmark:
Dimension Filters:
Ship To State is not one of: None
Measure Filters:
Avg Shipping CP ≥ 0
📋 Columns Displayed
Dimensions:
Ship To State — Abbreviated state code of person shipment is being sent to
Bottles In Order — The total number of bottles that made up the order. These are any size bottles (not recalculated to 750ml bottles)
Measures:
ℹ️ Additional Details
Bookmark ID:
94941539-2cfb-40ac-8167-07fd32f6c13c