1. Missed the live Ask the Expert event?
    Not to worry. Check out the archived thread of the Q&A with Ken Hutcheson, President of U.S. Lawns, and the LawnSite community on the Franchising Forum.

    Dismiss Notice

Flyer Tracking

Discussion in 'Business Operations' started by two_planks, Jan 28, 2005.

  1. two_planks

    two_planks LawnSite Member
    Posts: 206

    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
     
  2. two_planks

    two_planks LawnSite Member
    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.
     
  3. Team Gopher

    Team Gopher LawnSite Platinum Member
    from -
    Posts: 4,041

    Hi two_planks,

    Do you have a website? You can post it on there and link to it.
     
  4. two_planks

    two_planks LawnSite Member
    Posts: 206

    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.
     
  5. two_planks

    two_planks LawnSite Member
    Posts: 206

    Just realized I can attach a .zip file.
     

    Attached Files:

  6. two_planks

    two_planks LawnSite Member
    Posts: 206

    You can use this one to predict results on a flyer or mailer that you are planning on sending out.
     

    Attached Files:

Share This Page