Direct mail campaign ROI calculator

A quick and dirty calculation to assess if your campaign is worth the effort.  Read here how to create a campaign and write an effective sales letter in my other posts.

 

[]
1 Step 1
Marketing list costcost per record
Print and Post costcost per record
Estimated response rateenter value in %
Estimated sales valueenter value in GBP
Gross profit marginenter value as %
Mail list records
RESULTS

Per Record

Campaign

Total Gains

[(FIELD4 )*(FIELD6)*(FIELD7)/10000]

[(FIELD4 )*(FIELD6)*(FIELD7)*(FIELD5)/10000]

Total Costs

[FIELD1 + FIELD2]

[(FIELD1 + FIELD2)*FIELD5]

Net profit/(loss)

[(FIELD4 )*(FIELD6)*(FIELD7)/10000-(FIELD1 + FIELD2)]

[(FIELD4 )*(FIELD6)*(FIELD7)*(FIELD5)/10000 - (FIELD1*FIELD5) - (FIELD2*FIELD5)]

ROI in %

[(FIELD4 )*(FIELD6)*(FIELD7)/(FIELD1 + FIELD2)/(100) -100]

[(FIELD4 )*(FIELD6)*(FIELD7)/(FIELD1 + FIELD2)/(100) -100]

Previous
Next