1. Missed the live Ask the Expert event?
    Catch up on the conversation with Ken Hutcheson, President of U.S. Lawns, in 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
    Messages: 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
    Messages: 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 -
    Messages: 4,040

    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
    Messages: 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
    Messages: 206

    Just realized I can attach a .zip file.
     

    Attached Files:

  6. two_planks

    two_planks LawnSite Member
    Messages: 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