Hello. I am asking here for ideas and logic rather than examples. Let be begin by explaining what I have been asked to do.
I have been asked to create a new ad spot on our front page. This spot is planned to have no more than 10 rotating ads at any given time. However that doesn't mean there can't be 1 or even no ads to fill the spot at any given time.
On the "users" end -- I have created a page for our designers to upload their ads if there is a spot available and put it into a que with a start date if not. This is a requirement. The designers MUST be able to upload their ads themselves.
So I am left with the task of writing a script that will:
1) rotate the ads
2) account for impressions and clickthroughs (which I already have a plan for)
3) ensure that the ads in the sytem (which that number could change day to day given the nature of the advertising) get served evenly. So even rotation is a must.
Every time I draw a plan out, my logic is flawed. Given that the total number of ads is dynamic, I seem to be having trouble coming up with a dynamic rotaion that conforms to the number of ads in the DB for even distribution. Our goal is to give each person 10,000 hits a day, -- And from what I've come up with the individual impression count could range from 5,000 to 14,000. Not a very even distribution.
Another note, for those of you who are going to suggest ad tracking software. We have a very extensive ad tracking program, however this is a very unique solution we are providing and givin the dynamics of the proposed compaign, it's just not feasible to be constantly in the tracking system changing the ads when the designers can do it themselves.
Any thoughts, comments opinions are appreciated!