Campaign ROAI Calculator

Reset
Campaign ROAI & Breakeven Calculator
The Marketing Campaign ROAI Calculator(return on advertising investment or sometimes called the ROMI (return on marketing investment) Calculator will help you learn immediately if your product(s) made money or can make money via the media used. The advertising investment is your total spending for all promotional / advertising costs supporting the campaign.
Campaign Revenue
Total Revenue from Campaign
Total Campaign Orders
Average Shipping & Handling Charge Billed To Customer
Note: If the sales do not involve shipping the orders to the customer, you can leave the "Average Shipping & Handling Charge" billed to customer blank.
Campaign Costs
Merchandise gross margin % %
Cost of goods (total)
Returns % (Enter campaign average returns %.) %
Bad Debt % (Enter campaign average bad debt %.) %
Credit card discount rate (Enter discount rate %.) %
Credit card processing fee (Enter the processing fee %.) %
Fulfillment costs per order $
Postage/shipping costs per order $
Total product and sales related costs
Enter total of all marketing (promotional / advertising costs) $
Total campaign costs (including marketing, product and sales related costs)
Note: If there are no postage / shipping costs or fulfillment costs, you can leave these cells blank.
Campaign ROAI
Gross Profit on Sales (before marketing costs)
Shipping & Handling Revenue
Total Gross Profit
Campaign Net Profit (less total marketing investment Costs)
Net profit per order
Campaign ROAI (ROMI)
Reset
Instructions
In the section labeled “Campaign Revenue,” enter the projected revenue and number of orders for the campaign.

In the section labeled “Campaign Costs,” enter the product gross margin %, returns %, bad debt %, credit card processing fee %, total fulfillment costs (pick and pack, warehousing, order processing, etc.), and the total postage and shipping costs for delivering the order to the customer. If a variable doesn’t apply to your campaign, leave it at “0.”

Also enter the total marketing (promotional / advertising) budget (or expenses) you have for this campaign...all creative, production and media cost in the field labeled "Total of all marketing (promotional/advertising costs)." This would include any direct marketing, sales promotion expenses, public relations expenses, telemarketing, media, lists rental, and the cost of content and collateral creation and production, etc.

Once you have entered these variables, you can view the marketing ROAI and profit projections in the section labeled “Campaign ROI.” You can run different “what-if” scenarios by changing the variables in the “Campaign Revenue” and “Campaign Costs” sections.
(c) 2015 DWS Associates. All Rights Reserved.