Flyer Tracking

[two_planks]

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

[two_planks]

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.

[Team Gopher]

Hi two_planks,

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

[two_planks]

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.

[two_planks]

Just realized I can attach a .zip file.

[two_planks]

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