PDA

View Full Version : Flyer Tracking


two_planks
01-28-2005, 02:05 AM
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
01-28-2005, 02:08 AM
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
01-28-2005, 10:19 AM
Hi two_planks,

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

two_planks
01-28-2005, 10:24 AM
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
01-28-2005, 10:55 AM
Just realized I can attach a .zip file.

two_planks
01-28-2005, 11:12 AM
You can use this one to predict results on a flyer or mailer that you are planning on sending out.