Content marketing ROI calculator
Download the template (Google Sheets / Excel)
Download the template (Google Sheets / Excel)
There are no Macro’s of Javascript in the files.
Overview
The basic assumption of this sheet is that (extra) efforts in content marketing are intertwined with owned media channels and guiding prospect through your ‘funnel’ / salesproces.
Those owned media channels have their own metrics and dynamics, and will improve when your content marketing is done right.
Branding effects are allocated in some channels and mostly return in metrics like CTR en CR (=conversion rates)
The sheet assumes you work with some kind of ‘leads’.
How does this sheet work?
A |
You get -manually- your data from Google Analytics, Facebook Insights, Linkedin Analytics, CRM stats etc etc and fill them in in tab 2 and tab 3
|
B |
You set the expected improvement ratio’s in tab 4 (this is where the ‘sheetmagic’ happens ~so be real)
|
C |
Edit the sheets 5 and 7, so you have/get a grip on your content production planning
|
D |
Sheet 6 calculated itself entirely
|
E |
In sheet 8 you put the value you want to calculate with for revenue/turnover/gross margin / net margin for the first sale and repeat sales
|
F | ROI calculates |
G |
Sheet 10 and 11 is you where you manage the costprice / investment of content production, creation and promotion
|
We are a Dutch Marketing agency. Although all our automated communication and forms are in Dutch, rest assured we are able to read and write some English.. so… go ahead and fill in the form.
E-commercemanagers.com heeft als missie om bedrijven en organisaties succesvoller te laten zijn in het digitaal geautomatiseerde tijdperk.
Wij geloven dat analyse en inzicht in de oorzaken van vraagstukken cruciaal zijn vervolgens oplossingen te implementeren die efficient, effectief en schaalbaar zijn.
Data, automatisering en personalisatie hebben daar in de meeste gevallen een belangrijke rol in.
Wij werken op een agile wijze met scrum technieken en proberen snel tot de kern te komen.
Schrijf u nu in voor de maandelijkse nieuwsbrief:
E-commercemanagers.com
⛾ Goudenregen 12
8141 XA HEINO
☎ 038-2340222
✉ info [at] e-commercemanagers.com