In this article we discuss Shipping Costs
Requirements
- Inserted shipping costs on the Financial Cost - Shipping tab on the configuration sheet
Background
Keeping track of shipping costs is crucial for your business. It is a significant expense that directly affects your profitability on an customer, order and product level and is included as part our COGS (Cost of Goods Sold) and Gross Margin metrics.
Steps
- Input your Shipping Costs within your Configuration Sheet
- Go to the Financial Cost - Shipping Tab
- Enter the below:
- category = Financial
- channel (e.g. Online DTC, Amazon)
- expense_channel = Shipping Cost
- region
- fixed cost/order - This is your shipping cost per order
- date_start
- date_end
Note: date_start and date_end can be used to capture changes in shipping costs over time. You will be able to change these date fields historically and in the future in case of updates to shipping costs and our data model will update accordingly. It is imperative to make sure you include a date_end date as the row will not be included if there is not date_end included.
- Please let the Source Medium team know that you’ve inputted the shipping costs and we will enable costs to be picked up automatically moving forward. Historical data can be inputted into this sheet to update the costs of prior orders as well.
How and where these costs surface in the dashboard?
Tables where these costs are currently available:
- Executive Summary
- called
shipping cost - LTV & Retention
- called
allocated shipping cost / cumulative allocated shipping cost - Orders
- called
shipping cost - Product Performance
- called
allocated shipping cost
FAQs:
It is imperative to make sure you include a date_end date as the order/row will not be included if it does not have a date_end date.
Questions? Reach out on Slack or support@sourcemedium.com