PAVILION Media Query Tracker.xlsx
Use this template to log, organize and analyze media queries to communicate to leadership.
Attention!
Check with your unit to ensure there are no local templates that should be used instead.
All media queries should be tracked for internal organization and data analysis. The information in this template can aid in faster responses to repeated queries. This template is also designed to help with data analysis and reports to enhance the commander’s understanding of public affairs’ impacts and effects.
Use this spreadsheet to log:
- Status
- Date/time received
- Organization
- Type of organization
- Subject
- Location of form
- Reporter
- Deadline
- Received by
- Coordination with
- Response by
- Date/time responded
- Time required
Recording the total time from receiving the query to the final response is a helpful data point for evaluating a team's efficiency. Use the analysis tab to evaluate average team response times and see the types of organizations (e.g., local, national, international) that request information and the subjects the media is inquiring about. Be sure to delete all of the instructions and examples before actively using the log.