Agency #1
Always remember, small and medium sized businesses may not have a lot of advertising clout but who ever 'gets' our accounts will get better ad rates*** that could entice other new business for the agency. More volume, lower advertising rates, and the agency decides if you the customer gets the breaks or if agency profits just increase.
Agency #2
The schedule is only one worksheet in a medium sized spreadsheet that pulls together my overall budget. Of course, the numbers and some of the projects have been altered or deleted to protect my company's confidential information.The spreadsheet builds from right to left, going from ad prices to ad schedule to annual budget (the names in italics are worksheet names in the spreadsheet:
- Ad prices - just states the prices with discounts based on insertions. I wanted to be able to change the insertion rate, if desired, one place and have it filtered throughout.
- Ad detail - This is the list of ads with "date/media/feature" enhanced. Costs are added up by month/year/product/media, The number of insertions are tallied by month, by media, by product being features. Ad prices are pulled from the previous worksheet.
This gives me a lot of flexibility. After I set-up a 'strawman' schedule, I sit down with my management and juggled things around based on harvesting schedules, how much we want to advertise for a particular product, how many times a product should be advertised before a tradeshow, etc., etc. If I didn't have this flexibility, I would have to redo the schedule a dozen times. It's spending a good deal of time in the beginning to avoid spending a lot of time near the end. - Ad dates - are simple schedules that I use during the year as general look-up (what ad is next...). I make each of the media venues a copy with just their information on it.
- 07 project detail - has the advertising budget one line in it but details all the other projects and expenses I have during the year. Again, if I change an ad in the ad schedule an hour before handing in my overall budget, my budget is ready to print with the change.
- Budget - is just a line-by-line of my budget with no details. This is what I hand in to accounting.
- Actual - is a worksheet where I keep myself posted on how well I'm doing with my budget. Yes accounting gives me the numbers, but I like to play around with them.
View spreadsheet
*For those not familiar with media buys
Generally speaking a newspaper, magazine or other venue will publish rates and give advertising agencies a 15% commission off that rate. The venue invoices the agency minus 15% and the agency bills you the full rate plus any fees to pull together the ad. Please note: if you - the advertiser - gives the media outlet an electronic file ready-to-go they'll bill you with the 15% deducted off your invoice.
Why use an agency if you know what media you need to be in, how big of an ad you should do, and when it should run? Because a really good agency (for your product or service) will have enough customers buying the same media that you'll get a better rate even with the 15% tacked on. Also an agency who buys a lot, can demand a lot (better positioning, etc.).
*** A media venue will list its rates based on the number of insertions or frequency of ads. So if you run 10 ads chances are you'll pay more per ad than if you ran 20 ads. Know your media venue's rate cards. Make sure you don't advertise 19 times not knowing you could have advertised 20 times and gotten a better overall rate. Any good sales rep will alert you to this, but you should know it up front.
4 comments:
Good information just a little confusing.
Why do you have letters beside the advertisement in the AdDetail worksheet?
I get the overall idea. I like what it does. But how do you count insertions? And why do you count inserts per media per product?
Mar - this is worth a 'webinar' to explain. Do it!
I showed the spreadsheet to my ad agency's media buyer who said it was a good idea for a business who buys their own media. The buyer said she does something like it across the agency's accounts. Most of her clients would rather not see the detail you're showing.
Post a Comment