Overview

What are cost markup and fees? Cost markup refers to the practice where an organization applies a percentage charge on top of media costs to cover the expense of managing media campaigns.  Fees refer to one time, monthly, or daily charges applied to total cost.  An example of a fee could be a marketing agency charging a monthly fee for managing a client's social media.

What is/isn't Supported?

• Markup and fees can be applied based on:
  • Client Name
  • Profile Name
  • Data Source (e.g. Google Ads, Facebook Ads, etc.)
  • Start/End Date
• InMarket currently does not support markup and fees based on:
  • Channel (e.g. Display, Video, Paid Search, etc.)
  • Any other additional dimensions that are more granular than data source, like campaign, ad group, creative, etc.

What does InMarket do?

InMarket will provide a Google Sheet that looks like the image at the bottom of this page.

• This Google Sheet will be in the "ChannelMix Source Files" folder within the Google Drive folder that is shared with you.
• The CMX Client Name, CMX Profile Name, and Data Source drop down fields will be populated automatically with all available client, profile, and data source combinations in your data.
• InMarket will automatically refresh the data from the "Markup & Fees" tab every 2 hours from 8:00 AM to 6:00 PM CT daily.

What do I do?

To Add Markup

1. Navigate to the Google Sheet and find the tab named "Markup & Fees".
2. Select the ChannelMix Client Name and ChannelMix Profile Name that you are targeting.
3. Select the data source that you are targeting (required for markup).
4. Enter the markup that you would like to apply as a percentage.
   • Note - The default formula used in the dashboards for applying markup is:
     • <media cost> * (1 + <markup percentage / 100>)
5. Enter start and/or end dates (if needed - not required for markup).
   • Using start and end dates for markup:
     • Start date and no end date - applies the markup daily from the start date into perpetuity
     • End date and no start date - applies the markup daily from the earliest date in the dashboard to the end date
     • Start date and end date are the same day - applies the markup on that date
     • Start date and end date - applies the markup daily for the date range

To Add Fees

1. Navigate to the Google Sheet and find the tab named "Markup & Fees".
2. Select the ChannelMix Client Name and ChannelMix Profile Name that you are targeting.
3. Select the data source that you are targeting (if needed - not required for fees). 
   • If you want the fee to be applied to a specific data source, select it from the drop down list.  If you don't want the fee to be applied to a specific data source, you can leave this field empty.
4. Enter the fee that you would like to apply as a USD amount.
5. If you would like the fee to be applied monthly instead of daily, check the "Monthly Fee?" box.
   • If a start date is provided, the fee will be applied on the same day of that start date every month.
   • If only an end date is provided, the fee will be applied on the same day of that end date every month.
6. Enter start and/or end dates (required for fees).
   
   • Using start and end dates for fees:
     • Start date and no end date - applies the fee daily (or monthly) from the start date into perpetuity
     • End date and no start date - applies the fee daily (or monthly) from the earliest date in the dashboard to the end date
     • Start date and end date are the same day - applies the fee on that date
     • Start date and end date - applies the fee daily (or monthly) for the date range