27 Templates most used by LocalMediaInsider members
Save time with a better starting point for a variety of projects
Welcome to the Templates area. This is where you find worksheets in excel and word that are used by local media around the country, plus one sheets and brochures. Use these directly, or just the formats to save time developing your own new tools.
Below are the top 25 most-used templates:
1. New metrics tracking worksheets – New metrics and targets for 2015 as advised by Borrell & Asssociates, including two excel spreadsheets used by Morris Communications to track performance across new metrics. Best practice.
Obits
2. Obituaries planning brochure – In hard copy and PDF, the Bay Area News Group says this brochure was part of their “go to market” strategy that tripled revenues.
3. Obituaries calculator - If you attended the last webinar, you know how to use this tool to size up opportunity in your market.
Events
4. Vendor packets - From the Chattanooga Times and others, Vendor information, sales flyers and contracts.
5. Day of checklist - Keeps producers organized! From Chattanooga Times', Angela Doggett.
6. Event P&L – The difference between making money and not making money, in excel.
7. List of event ideas from around the country, events criteria worksheet and competitive analysis worksheet – Use these tools to hone in on new events for 2015.
Excel
8. Restaurant week starter kit – Resources from the field.
Sales
9. Individual rep monthly forecast – One sheet in Excel.
10. First year sales development plan – Hiring new reps, layout your expectation in Excel.
11. ROI Campaign calculator – Help reps simplify ROI, in Excel.
12. Contract counter – Weekly sales meeting prompt to shift focus to long term deals.
13. Site potential calculator – Excel, shows how much of the opportunity you're getting, from Robert Grandfelt.
14. 45 Training Terms and the ever popular Geektionary- Oldies but still useful sets of terms. Update these with vocabulary your team is learning now.
15. Quiz show to help with training.
Telesales
16. Ultimate sales goal monthly planner in excel – Shared by Todd Handy, Deseret Digital.
17. Recruitment ad for part-time telesales – Also from Handy.
Mobile
18. App store review guidelines - Consistently one of the most used features on the site.
19. Mobile opportunity calculator – Add in all your mobile products and their potential. This calculator was created when mobile was smaller than desktop, and it still works. Created with LSM.
Deals
20. Value of an email name – From Second Street Media.
21. Group deal ROI calculator - Ditto.
Digital services
22. Advertiser survey – Ten questions to find out what they are buying.
23. Reputation repair postcard - Shared by Vendasta to allow reps to help clients solicit more reviews.
Native
24. Features and benefits – One sheet used in the field at the Quad City Times.
25. Guidelines – Client training online at the Washington Post.
26. Measuring results from native - Excelworksheet based on Deseret Digital's model
27. Native advertising glossary - Key terms defined to use for sales training
