Administration Public Relations Activity Log Template watermarked preview
Records & Logs · General Activity Logs

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
#public relations#activity tracking#employee management#PR campaigns#administration#workflow logging

Download this template

.xlsx · 4 sheets · included with lifetime access

Download

More in Records & Logs