Customizable Spreadsheet Template: Marketing Programs Analysis

Available Versions

These are not rigid spreadsheet templates. You can customize them in dozens of ways to get the features you want while reducing unneeded complexity.

Version	Description	Download Price
Light	The Light version has the same features as the Standard version, only it is smaller. It lets you try the customization process and download a customized working template for free.	Free
Standard	Estimates effectiveness of marketing and sales programs for a moderate number of programs and customers.	$69 $49
Advanced	Includes all the features in the Standard version, plus allows you to measure effectiveness of program for distinct products. It supports larger analyses with more programs, customers, and time periods. Has pivot table of customer information.	$99 $69
Advanced Extra-Large	Includes all the features in the Advanced version, plus it allows larger models with more of everything.	$139 $99

* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet.

Feature	Standard & Light Versions	Advanced & Extra-Large Versions	Comments
Marketing and Sales programs
Marketing programs			Analyzes effectiveness of marketing programs of your choice
Sales programs			Analyzes effectiveness of sales programs of your choice
Program Characteristics
Organized in families			You can have a family of seminars and track effectiveness of each separate seminar title, or each seminar delivery over time.
Program life			Effective lifetime of each marketing and sales program
Rate of decay of program effect			Specify rate at which effectiveness of each program decays over time
Expense of each program			Specify fixed program expense per period and variable expense per marketing touch
Customers			Customers and subordinate customer organizations
Customers with organizational units			Specify customers, including separate purchasing units.
Customer touches			Enter the number of 'touches' of each customer by each program over time
Advanced customer analysis			More performance measures for customers and products, such as program costs and contribution margins by program, customer and product
Pivot table of customer info			Slice customer data of many kinds in a pivot table
Products			Distinguish the effectiveness of each program at selling different products.
Contribution Margin			Computes contribution margin amounts and percent for each marketing and sales program

Feature	Standard Version	Advanced Version	Extra-Large Version
Time range of marketing activities	8	12	12
Marketing programs	10	20	30
Sales programs	0	8	12
Customers	10	50	100
Products	0	2	4

Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.