Administration Public Relations Activity Log Template
Track PR activities, personnel, and departments with automated lookups and activity summaries.
This template logs public relations activities including press releases, media interviews, and announcements with automatic employee position and department tracking via VLOOKUP. It maintains a centralized employee roster and activity type reference library, enabling PR teams to document campaigns, assign ownership, and generate activity summaries by type. Perfect for managing PR workflows, ensuring accountability, and auditing communication efforts across departments.
What's inside
- Employee roster with position and department lookup
- Automatic VLOOKUP population of staff roles from employee database
- Activity type categorization with summary sheets
- SUBTOTAL function for activity counting by type
- Company contact information header on all sheets
- Filterable activity log with lead person assignment
Download this template
.xlsx · 4 sheets · included with lifetime access
More in Records & Logs
Records & Logs5S Checklist
Track and score workplace organization inspections using the 5S methodology framework.
- Ranking system (A/B scores)
- Problem counting and tracking
- 5S principle categories
Records & LogsAddress Book
Organize and manage contact information for work and personal relationships efficiently.
- Structured name and contact fields
- Separate work and cell phone columns
- Email address storage
Records & LogsAddress Book
Organize contact information with names, phone numbers, and email addresses in one searchable location.
- Name field for contact identification
- Work phone number column
- Cell phone number column
Records & LogsAdministration Compliance Audit Schedule Template
A comprehensive compliance audit scheduling and tracking system with personnel management and status monitoring across multiple departments.
- Monthly calendar grid for visual scheduling
- Personnel directory with contact information
- Department-based organization