Dave Chaffey's e-marketing spreadsheets have been developed to help students using his E-marketing books and professionals following his training courses or digital marketing qualifications model investments in digital media.

• Register to download my free E-marketing spreadsheets

My digital marketing spreadsheets

There are four spreadsheets:

1. E-marketing planning spreadsheet - 3 worksheets for site conversion, media mix and e-mail marketing modelling
2. Online ad revenue model - This spreadsheet is for media site owners to estimate ad or affiliate marketing revenue from a site or section of site. It allows parameters such as % inventory, number of ad units, CPM and CPC to be set. Total revenue for each ad unit or container and corresponding Earnings per 100 clicks (EPC) or Earnings per thousand page views (eCPM) are calculated automatically.
3. Web metrics reporting spreadsheet - you will need to "enable macros" for automated plotting for a rolling 12 month period
4. E-mail campaign calculator spreadsheet - Accompanies Dave Chaffey's Total E-mail Marketing book

• Register to download my free E-marketing spreadsheets