Ecommerce Business

profileAarav02
DigitalMarketing-ROICalculator.xlsx

Sheet1

DIGITAL MARKETING ROI CALCULATOR
GENERAL AND START UP INVESTMENT Estimated annual cost
Website Development $20,000.00
Mobile App Development
Website maintenance $5,000.00
Staff (e.g. work on website updates, maintenance, social media activities, research) $10,000.00
Other expenses $5,000.00
DIGITAL MARKETING CAMPAIGN INVESTMENT Estimated annual cost Expected Traffic Conversion rate (%) Number of orders (traffic X conversion rate) Average Order ($) Sales (number of orders X average order) Cost of goods sold (%) Contribution margin per order (sales X (1-% of cost of goods sold)
E-mail marketing $2,000 20000 0.75% 150 $200.00 $30,000.00 40% $18,000.00
Social media content marketing (posting on social media) $5,000 20000 0.75% 150 $200.00 $30,000.00 40% $18,000.00
Display Advertising $5,000 5000 0.75% 37.5 $200.00 $7,500.00 40% $4,500.00
SEO $10,000 15000 0.75% 112.5 $200.00 $22,500.00 40% $13,500.00
PPC $10,000 10000 2.00% 200 $200.00 $40,000.00 40% $24,000.00
Social media advertising $10,000 20000 0.75% 150 $200.00 $30,000.00 40% $18,000.00
Viral marketing $10,000 30000 0.50% 150 $200.00 $30,000.00 40% $18,000.00
Other campaigns 950
TOTAL - CONTRIBUTION MARGIN $114,000.00
TOTAL INVESTMENT (ANNUAL) (COLUMN B ABOVE - TOTAL) $92,000.00
TOTAL CONTRIBUTION MARGIN (ANNUAL) (COLUMN I TOTAL) $114,000.00
TOTAL PROFIT (CONTRIBUTION MARGIN - INVESTMENT) $22,000.00
RETURN ON INVESTMENT (PROFIT/INVESTMENT) (%) 23.91%