How do I include marketing spend through the cost tab of the configuration sheet?
Requirements
- Access to Configuration sheet to input custom marketing spend
- If this is your first time using the Cost tab:
- Once all steps have been completed, reach out to the Source Medium team in Slack (or via email) letting us know you'd like to enable the custom costs feature
Background
You can use the cost tab in your configuration sheet to include any marketing spend that is outside of your integrated platforms. Any spend that is added to the configuration sheet will then be included in the Executive-level and the Marketing Overview modules.
Video Walkthrough
Steps
- Open your configuration sheet (find the link in
pinned messagesin your Slack channel) - If not in Slack, email our team for access to your configuration sheet
- In the
Costtab, select the appropriate values for each column category- select ‘Marketing’channel- select the channel where you’re expecting to see returns on this spend (Online DTC, Wholesale, etc.)sub-channel- select the sub-channel that the spend is associated with (new sub-channels can also be added within theConfigurationtab)- Any
sub_channelcontaining the following terms (not case sensitive) will be pulled into the Sponsorships & Influencers module: influencerpodcastnewsletteraffiliatesponsorshipvendor- select the specific platform related to the spend (can add additional values inConfigurationtab)- Enter your marketing spend in the
costcolumn and applicable dates date_startanddate_endwill amortize the cost for that spend across the range ofdate_starttodate_end- e.g. $1,000 spend from 10/1/2021 to 10/10/2021 would tack on $100 spend for each day. If no date_end is provided, all cost is attributed to
date_start
