How do I enter non-integrated sales data through my Configuration Sheet (Sales tab)?
Background
Even if Source Medium doesn’t currently support one of your sales platforms — e.g. wholesale or retail data — you can still account for this sales performance and include it within SM! Use the following guide to find out how.
Steps
- First, ensure that you have accurate records of the sales data in question
- typically a direct export from the platform is the best solution
- Open your Source Medium Configuration Sheet and navigate to the Sales tab
- The structure of this sheet is fairly straightforward
channel
- This is where you select the sales channel to attribute the following performance to
- Options are: Online DTC, Retail, Wholesale, Amazon, Draft Orders, Exchanged, Partners / Affiliates, & Excluded
- Most likely you will be using either the Retail, Wholesale, or potentially Online DTC channels
sub_channel
- This is the sub-channel you wish to attribute these sales to
- This value is NOT relevant for reporting purposes, as sub-channel is not surfaced in the Executive Summary data.
- purely for internal tracking & organization of costs within the Sales tab
date_start
- This is the date to start attributing the following values on. E.g. if you set a
date_start
= 9/1/22 and enter $1000 ingross revenue
, $1000 will start being attributed to 9/1/22 - if a date_end value is entered, the metric value will be evenly amortized across all dates in the range of
date_start
throughdate_end
(inclusive of both dates) - e.g. if
date_start
is 9/1/22 anddate_end
is 9/10/22, agross revenue
value of $1000 would be amortized evenly at $100 on 9/1/22 - 9/10/22 - if
date_end
is left blank, the full metric value(s) will be attributed todate_start
- e.g. if
date_start
is 9/1/22 and nodate_end
value is present, agross revenue
value of $1000 would be attributed in full to 9/1/22 date_end
- Metric-specific columns -
gross_revenue
,net_revenue
,orders
,primary_product_units
(only relevant for brands with a flagship product),discounts
,refunds
- This is where you enter the exact value(s) for any combination of metrics you’re wanting to report
- These are currently the only metrics supported by the Sales tab
- Reach out to the SM team if you have a need that isn’t covered by these metric options, we’ll do our best to come up with an alternate solution, or we’ll add it to our R&D queue
- Enter data into the sheet using the the schema explained above.
- If you’re using the Sales Tab for the very first time, you’ll just need to reach out to the SM team to enable the feature. After the feature has been enabled by the SM team, data and updates will be picked up and routed to your report automatically every hour