Just to give you an overview -
I have each line item separated because i treat each of them as an individual sum - the bold lines are then autosums of the rest of the campaigns....
Booked = how many ad impressions have been booked (this never changes)
Delivered = this changes and should be updated every day. it is the amount the campaign has served out of the booked impressions
Clicks = how many times someone has clicked on an ad in the amount of delivered impressions
CTR = the click through rate percentage of the delivered
Served % = (today's date - start date) / (end date - start date)
Duration % = this should be the percentage the campaign is through the campaign - this could possibly be what i have done for the served in which case how do i get the % served to change according to the delivered everyday and in relation to the booked?
OSI = duration / served (or the other way round....))
As you can see I'm in a total pickle - can you help or do you know anyone who might be able to?spreadsheet.jpg
Bookmarks