Register free!

The Green Industry's Resource Center



Reply
 
Thread Tools   Display Modes
  #1  
Old 12-28-2005, 01:48 PM
dsmrolla06's Avatar
dsmrolla06 dsmrolla06 is offline
LawnSite Senior Member
 
Join Date: Apr 2005
Location: Elkhart, Indiana
Posts: 305
Marketing ROI sheet

Im trying to make an excel sheet that will show all of my marketing campaigns and projects. I have one sheet that will give an overview of all the marketing projects, including date sent, response rate, cost etc. I will then have a sheet for each project. I will have the total sent, and then have all the costs for the project. I then want to make a chart that will show the date and day of week i receive responses. Im not sure how to do. Also would anyone have any suggestions on anything else to include or have an example. When i finish i will post an attachment on here. Thanks for the help.
__________________
Mowit Lawns, LLC

'I don't know the key to success, but the key to failure is trying to please everybody.'
Bill Cosby

'If there are no stupid questions, then what kind of questions do stupid people ask? Do they get smart just in time to ask questions?'
Scott Adams
Reply With Quote
  #2  
Old 12-28-2005, 02:51 PM
Trinity Lawn Care, LLC's Avatar
Trinity Lawn Care, LLC Trinity Lawn Care, LLC is offline
LawnSite Senior Member
 
Join Date: Nov 2005
Location: NJ
Posts: 946
Pro Edge, sounds pretty good. Since you are doing such a defined track I would maybe add to that the specific areas that you are prospecting/farming. If you are farming a couple of different areas it would be nice to know which campaign is working where, and what response rate you are receiving from a specific group. This way you will have more true numbers instead of a broad spectrum overview.JMO
__________________
Rob
Reply With Quote
  #3  
Old 12-28-2005, 11:11 PM
dsmrolla06's Avatar
dsmrolla06 dsmrolla06 is offline
LawnSite Senior Member
 
Join Date: Apr 2005
Location: Elkhart, Indiana
Posts: 305
I agree that would be a good way to go. My first campaign is a letter with a business card and a postcard reply mail. Its going out to all chamber members that i have hand selected through the directory based on their area. The area with this campaign is mostly industrial parks and surrounding heavy commercial areas.

This campaign into 01A and 01B, which are the code names, 01 being whcih one, and A and B being variations. The variation is a contact and no contact, which is just the chamber representative. The contact are found from me calling business and receiving the name of the person that directly deals with the lawn care maintenance and decisions, and possibly may even have spoke with in person. This relates to my other thread, propecting new clients or whatever it was called. For any businesses that i have not called and received a contact for, i use the chamber rep, who may deal with lawn care, most likely not however. Im doing this to see how effective it is in getting to the right person.

I do not have these sorted by any demographic statistics, such as area or size of business of anything like that, but may do in the future. I wanted to be able to do a break down of the day of the week im am getting responses as compared to the day i send them out to even be able to eventually get a day that is most suitable. Sorry about the rambling, but i will post a copy of my sheet that i have done so far if anyone can tell me how to post it.
__________________
Mowit Lawns, LLC

'I don't know the key to success, but the key to failure is trying to please everybody.'
Bill Cosby

'If there are no stupid questions, then what kind of questions do stupid people ask? Do they get smart just in time to ask questions?'
Scott Adams
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump





Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright ©1998 - 2012, LawnSite.comô - Moose River Media
All times are GMT -4. The time now is 06:20 AM.

Page generated in 0.09046 seconds with 7 queries