Register free!
Search
 
     

The Green Industry's Resource Center


Click for Weather
Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2005, 02:05 AM
two_planks's Avatar
two_planks two_planks is offline
LawnSite Member
 
Join Date: Jan 2004
Location: great white north
Posts: 206
Flyer Tracking

I just spent the last 1/2 hour making a spreadsheat to track some flyers I mailed out on tuesday. I thought some of you might be able to use it so here it is.

It will work for up to 500 estimates, if you need more just extend columns A and C on sheet 2. I don't know how to make my formulas work without a number so if an estimate turns into a job enter 1 in the "job" column.

This sheet will keep track of:

Number of estimates
Number of jobs
Total job $$
Average job $$
% of total spent on the flyers (cost cell- enter you total cost for the flyers)
% of flyers turned into estimates
% of flyers turned into jobs
% of estimates turned into jobs

Hope it helps some people.

Ben
__________________

Last edited by two_planks; 01-28-2005 at 02:07 AM. Reason: forgot attachment
Reply With Quote
  #2  
Old 01-28-2005, 02:08 AM
two_planks's Avatar
two_planks two_planks is offline
LawnSite Member
 
Join Date: Jan 2004
Location: great white north
Posts: 206
I guess you can't upload spreadsheets. If someone knows how let me know, otherwise shoot me a pm with your email addy and I'll send it to you.
__________________
Reply With Quote
  #3  
Old 01-28-2005, 10:19 AM
Team Gopher's Avatar
Team Gopher Team Gopher is offline
LawnSite Platinum Member
 
Join Date: Jul 2003
Location: -
Posts: 4,046
Hi two_planks,

Do you have a website? You can post it on there and link to it.
Reply With Quote
  #4  
Old 01-28-2005, 10:24 AM
two_planks's Avatar
two_planks two_planks is offline
LawnSite Member
 
Join Date: Jan 2004
Location: great white north
Posts: 206
Quote:
Originally Posted by Team Gopher
Hi two_planks,

Do you have a website? You can post it on there and link to it.
No, thats something I'm working on. I've actually built the site already I just haven't found some where to host it yet.
__________________
Reply With Quote
  #5  
Old 01-28-2005, 10:55 AM
two_planks's Avatar
two_planks two_planks is offline
LawnSite Member
 
Join Date: Jan 2004
Location: great white north
Posts: 206
Just realized I can attach a .zip file.
Attached Files
File Type: zip Spring Flyer Results.zip (13.4 KB, 32 views)
__________________

Last edited by two_planks; 01-28-2005 at 10:58 AM. Reason: add zip file.
Reply With Quote
  #6  
Old 01-28-2005, 11:12 AM
two_planks's Avatar
two_planks two_planks is offline
LawnSite Member
 
Join Date: Jan 2004
Location: great white north
Posts: 206
You can use this one to predict results on a flyer or mailer that you are planning on sending out.
Attached Files
File Type: zip Winter Flyer Projections.zip (5.3 KB, 15 views)
__________________
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 11:29 AM.

Page generated in 0.07628 seconds with 8 queries